Job Step Duration
Use this data collector to capture information about the duration of steps when they
process jobs in your workflows.
General
| Property | Default value |
|---|---|
| Database table name | job_step_durations |
| Error log directory | /aiw/aiw1/stepdurationdump |
| Remove expired entries | Off |
| Retention period |
Properties to capture
Usage note: In addition to the default selected job properties, the Job Step Duration data collector always captures data about:
- Job number
- The unique number that identifies the job on the system.
- PostgreSQL database table column name:
id.
- Creation time
- Local time when the event was stored.
- PostgreSQL database table column name:
created_at.
- Creation UTC time
- UTC time when the event was stored.
- PostgreSQL database table column name:
created_at_utc.
- Current Workflow
- The current workflow used by the job.
- PostgreSQL database table column name:
job_workflow.
- Current phase (Job.Phase)
- The name of the workflow phase that is processing the job.
- PostgreSQL database table column name:
job_phase.
- Current step (Job.Step)
- The name of the step that is processing the job within the current phase.
- PostgreSQL database table column name:
job_step.
- Record
- Automatically generated sequence number.
- PostgreSQL database table column name:
record.
- Step queued duration
- Total time the job is queued before running.
- PostgreSQL database table column name:
step_queued_duration.
- Step processing duration
- The total time the job is in the processing state.
- PostgreSQL database table column name:
step_processing_duration.
- Step processing end
- The time the step ends processing.
- PostgreSQL database table column name:
step_processing_end.
- Step processing start
- The time when the step starts processing.
- PostgreSQL database table column name:
step_processing_start.
- Step run duration
- The total time the step was in the queued and processing states.
- PostgreSQL database table column name:
step_run_duration.
- Step template
- The name of the step template that was used to define the step.
- PostgreSQL database table column name:
step_template. - Step waiting duration
- The total time the step is in waiting state.
- PostgreSQL database table column name:
step_wait_duration. - Total step duration
- The total time the step was queued, processed, and in waiting state.
- PostgreSQL database table column name:
total_step_duration.