How to find the creation or modification date of an AutoSys job

Products

• Autosys Workload Automation

Issue/Introduction

How can a scheduler or administrator check when an AutoSys job was created, who created it, or when it was last updated?

Environment

Autosys Workload Automation AE (All Versions)

Workload Control Center (WCC) / AutoSys Web UI

Resolution

You can find the creation time, modification time, and associated user IDs using three primary methods:

Method 1: Via the AutoSys Web UI / WCC (Version 24.x and newer)

In the modernized web interface, you can view metadata directly from the graphical user interface:

1. Log in to the AutoSys Web UI.

2. Navigate to the Monitor dashboard.

3. Search for the desired job.

4. Customize your table columns by clicking the column selector and enabling Create Time, or Modify Time.  NOTE - The WebUI does not include options to display who made the insert or update.

Method 2: Querying the AutoSys Database

You can query the underlying database view/table ujo_job. Note that the timestamps (create_stamp and update_stamp) are stored as Unix epoch integers. Use the appropriate conversion functions based on your database type:

SELECT job_name, create_stamp, create_userid, update_stamp, update_userid FROM ujo_job WHERE is_active=1 AND is_currver=1 ORDER BY job_name

Method 3: Via Autotrack CLI and Audit Files (Historical Tracking)

If your instance has change tracking active, you can query history through the command line:

• Autotrack Utility: If the autotrack feature is enabled (Level 1 or Level 2), use the following command to display a full audit trail of updates and creations for a specific job:

  Bash

   

  autotrack -J <job_name> -v
  

• Audit Archive Logs: Historical tracking data can also be retrieved directly from the file system by inspecting the text files located at:

  Plaintext

   

  $AUTOUSER/archive/audit*