Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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. |