Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

DISCOVER_JOBS Rowset

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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.

Community Additions

ADD
Show:
© 2015 Microsoft