Export (0) Print
Expand All

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.

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.

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft