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

Property Default value
Job properties to capture
  • Custom 1 (Job.Info.Attr1)
  • Custom 2 (Job.Info.Attr2)
  • Custom 3 (Job.Info.Attr3)
  • Custom 4 (Job.Info.Attr4)
  • Custom 5 (Job.Info.Attr5)
  • Customer name (Job.CustomerName)
  • Duplex (Job.Duplex)
  • Input data stream (Job.InputDatastream)
  • Input file name (Job.InputFile)
  • Job arrival time (Job.FileReceiptTime)
  • Job class (Job.Class)
  • Job copies requested (Job.Copies)
  • Job destination (Job.Destination)
  • Job form (Job.Form)
  • Job name (Job.Name)
  • Job priority (Job.Priority)
  • Job size (sheets) (Job.JobSize)
  • Parent server (Job.Instance)
  • Persistence job id (Job.PersistenceID)
  • Previous printer (Job.PreviousPrinter)
  • Promoted (Job.Promote)
  • Promotion time (Job.PromoteTime)
  • Reconciliation user (Job.Insert.ReconcileUser.ID)
  • Requested location (Job.Locations)
  • Requested printer (Job.RequestedPrinter)
  • Reprint count (Job.ReprintCount)
  • Retention period (Job.RetainDuration)
  • Scheduled by (Job.ScheduleUserId)
  • Source input device (Job.SourceInputDeviceName)
  • Time submitted (Job.SubmitTime)
  • Total pages (Job.TotalPages)
  • Total sheets (Job.TotalSheets)
  • Use parent settings (Job.ParentJob)
  • Workflow (Job.JobType)

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.