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
.