This topic has not yet been rated - Rate this topic

DISCOVER_JOBS

SQL Server 2008

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	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.

Reference

XML for Analysis Schema Rowsets

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD