How to list and filter AutoSys jobs by a specific status

Products

• Autosys Workload Automation

Issue/Introduction

How do I generate a list of AutoSys jobs filtered by specific statuses (such as ON_ICE, ON_HOLD, or ON_NOEXEC)?

Environment

Workload Automation AE (AutoSys Edition) 24.x

Resolution

You can filter and list jobs by status using several methods depending on your interface preference:

Method 1: Via AutoSys Web Server (AEWS) REST API

You can query the WebService via a command-line HTTP client or directly through a web browser. Note that the pipe character (|) represents a logical OR and should be URL-encoded as %7C.

• From a command line (Linux/Windows):

  Bash

   

  curl -X 'GET' 'https://<AEHOST>:9443/AEWS/job?filter=strStatus==ON_ICE%7CstrStatus==ON_HOLD%7CstrStatus==ON_NOEXEC' -k --user "<user>:<password>" -i
  

• From a web browser:

  Plaintext

   

  https://<AEHOST>:9443/AEWS/job?filter=strStatus==ON_ICE%7CstrStatus==ON_HOLD%7CstrStatus==ON_NOEXEC
  

Method 2: Via the Command Line Utility (autorep)

You can use the standard CLI utility and parse the output using filters. Note that autorep uses 2-character abbreviations for statuses (e.g., OI for ON_ICE, OH for ON_HOLD).

Bash

 

autorep -J ALL | grep -e ' OH ' -e ' OI '

Method 3: Via Workload Control Center (WCC) UI

1. Log in to the WCC UI.

2. Navigate to the Monitor tab.

3. Use the advanced search/filter options in the Monitoring view to select the desired job statuses from the status dropdown or criteria fields.

Method 4: Via Direct Database Query (Read-Only)

Disclaimer: Direct database queries should be run with care and only as read-only operations.

You can query the ujo_jobst view within the AutoSys database. The internal numeric values for these statuses are 7 (ON_ICE), 11 (ON_HOLD), and 16 (ON_NOEXEC).

SQL

 

SELECT job_name, status FROM ujo_jobst WHERE status IN (7, 11, 16);

Additional Information For a complete listing of job status strings and their corresponding internal numeric values, please consult the product documentation matching your release version:

JobStatusValues