DISCOVER_JOBS Rowset

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.

Rowset Columns

The DISCOVER_JOBS rowset contains the following columns.

Column name Type indicator Length Description
JOB_CREATION_TIME DBTYPE_DBTIMESTAMP The server UTC date and time when the job was created.
JOB_DESCRIPTION DBTYPE_WSTR The job description assigned by server service.
JOB_EXECUTION_TIME_MS DBTYPE_I8 The time, in milliseconds, that the job is active.
JOB_ID DBTYPE_I4 The unique identifier of the job.
JOB_START_TIME DBTYPE_DBTIMESTAMP The server UTC date and time when the job was started.
JOB_THREADPOOL_ID DBTYPE_I4 The thread pool from which the current job was started.
JOB_TOTAL_TIME_MS DBTYPE_I8 The time, in milliseconds, since the job started.
SPID DBTYPE_I4 The session ID.

This schema rowset is not sorted.

Restriction Columns

The DISCOVER_JOBS rowset can be restricted on the columns listed in the following table.

Column name Type indicator Restriction State
SPID DBTYPE_I4 Optional.
JOB_ID DBTYPE_I4 Optional.
JOB_DESCRIPTION DBTYPE_WSTR Optional.
JOB_THREADPOOL_ID DBTYPE_I4 Optional.
JOB_MIN TOTAL_TIME_MS DBTYPE_I8 Optional.

See Also

XML for Analysis Schema Rowsets