Job History Detail (PD_JH)
- Organization of this page
Function
The Job History Detail (PD_JH) record indicates job history information incorporated into the Microsoft SQL Server schedule. One record is created for each case of job step history.
This is a multi-instance record.
- Note:
-
-
Collection of history information and monitoring of operations by alarms are performed for the jobs executed while PFM - Agent for Microsoft SQL Server is running. Collection of history information and monitoring of operations are not performed for the jobs executed while PFM - Agent for Microsoft SQL Server is stopped.
-
Records whose Step ID field is 0 indicate job history, not job steps. The following table lists the fields and values for job history.
Field
Value
Step Name
(Job results)
Command
(Unknown)
Subsystem
(Unknown)
-
The values of the Job Name, Command and Subsystem fields indicate the information at the time when the information is collected, not when the job is executed. Therefore, if the job step definition is changed after the job is executed, the field values might change as follows:
Operation
Value
When the job definition is changed
Delete the job
The job history can't collect.
The job name is changed
New job name
When the job step definition is changed
Delete the job step
(Unknown)
The job step definition or the order of executing job steps is changed
New job step definition
-
Default and changeable values
Item |
Default value |
Changeable |
---|---|---|
Collection Interval |
300 |
Y |
Collection Offset |
0 |
Y |
Log |
No |
Y |
LOGIF |
(Blank) |
Y |
Over 10 Sec Collection Time |
No |
N |
ODBC key field
-
PD_JH_COMPLETION_TIME
-
PD_JH_INSTANCE_ID
-
PD_JH_STEP_ID
Lifetime
From the time a job incorporated into the Microsoft SQL Server schedule is created until the time it is deleted
Record size
-
Fixed part: 681 bytes
-
Variable part: 8,631 bytes
Fields
View name (Manager name) |
Description |
Summary |
Format |
Delta |
Data source |
---|---|---|---|---|---|
Command (COMMAND) |
Command executed by a subcommand |
-- |
string(8001) |
No |
msdb..sysjobsteps.command |
Completion Time (COMPLETION_TIME) |
Job or step completion time |
-- |
time_t |
No |
msdb..sysjobhistory.(run_date+run_time+run_duration) |
Instance ID (INSTANCE_ID) |
Job history ID |
-- |
long |
No |
msdb..sysjobhistory.instance_id |
Job Name (JOB_NAME) |
Job name |
-- |
string(257) |
No |
msdb..sysjobs.name |
Record Time (RECORD_TIME) |
Interval end time (GMT format) |
-- |
time_t |
No |
Agent Collector |
Record Type (INPUT_RECORD_TYPE) |
Record type (always JH) |
-- |
char(8) |
No |
Agent Collector |
Retries (RETRIES) |
Job or step retry count |
-- |
long |
No |
msdb..sysjobhistory.retries_attempted |
Run Duration (RUN_DURATION) |
Time required for job or step completion (in HHMMSS format) |
-- |
long |
No |
msdb..sysjobhistory.run_duration |
Run Status (RUN_STATUS) |
Execution status. The following values are valid: Failure, Success, Retry, Cancelled, or In progress. |
-- |
string(15) |
No |
msdb..sysjobhistory.run_status |
Start Time (START_TIME) |
Interval start time (GMT format) |
-- |
time_t |
No |
Agent Collector |
Step ID (STEP_ID) |
Step ID |
-- |
long |
No |
msdb.. sysjobhistory.step_id |
Step Name (STEP_NAME) |
Step name |
-- |
string(257) |
No |
msdb.. sysjobhistory.step_name |
Subsystem (SUBSYSTEM) |
Subsystem used for executing the step. Values such as LogReader and Sync are valid. |
-- |
string(81) |
No |
msdb..sysjobsteps.subsystem |