krn.JobThreadGetInfo
This job returns information about the server’s threads, in particular about the job currently or last executed on the respective thread. It is the lightweight snapshot (which thread ran which job, as whom, for how long); the detailed drill-down into a single thread is provided by krn.JobThreadGetCallStack.
2. Output Parameters
| Name | Type | Dependency | Description |
|---|---|---|---|
|
STRING |
— |
Base64-encoded buffer with one record per thread. See the structure below. |
|
STRING |
— |
Semicolon-separated description of the fields returned per record in |
3. Structure of the Info buffer
The buffer is base64-encoded and decodes to one record per thread.
The 20 fields described by the InfoType parameter are plain ASCII text separated by NUL characters (0x00); only these 20 fields form the stable contract.
After the last field an undocumented binary structure follows (internal pointers; in memory dumps additionally a copy of the active session-GUID list) that should be ignored.
The timestamp fields (created, start, performed, stop) use the format <epoch>.<sequence>, i.e. Unix epoch seconds followed by a running sequence number.
InfoType returns the following field order:
| Field | Description |
|---|---|
|
OS thread identifier (identical to the thread identifiers from krn.QueueGetStatistic and krn.JobThreadGetCallStack) |
|
Queue the thread belongs to |
|
Index of the thread within its queue ( |
|
Runtime of the current or last executed job in seconds (right-justified) |
|
Number of jobs processed by this thread |
|
Identifier of the connection handling the job; |
|
Creation or enqueue time of the job |
|
Monotonically increasing job instance identifier |
|
Name of the current or last executed job |
|
Security/impersonation context level (inferred) |
|
Start time of the job |
|
Time at which processing actually began |
|
End time of the job; equals |
|
Status code of the job ( |
|
Content-processing flag (inferred) |
|
GUID of the work session that owns the job |
|
Name of the station (computer name) |
|
User the job runs as |
|
Currently executed SQL statement; only populated while the thread runs a database query |
|
Status code of the database connection |
Idle threads return jobname, sessguid and username empty, connection = -1 and the timestamps 0.000.