Provides information about the active jobs executing on the server. A job is a part of a command that executes a specific task on behalf of the command.
The DISCOVER_JOBS rowset contains the following columns.
The server UTC date and time when the job was created.
The job description assigned by server service.
The time, in milliseconds, that the job is active.
The unique identifier of the job.
The server UTC date and time when the job was started.
The thread pool from which the current job was started.
The time, in milliseconds, since the job started.
The session ID.
This schema rowset is not sorted.