Sorting by the Status column in a WCC view is not alphabetical
search cancel

Sorting by the Status column in a WCC view is not alphabetical

book

Article ID: 235952

calendar_today

Updated On:

Products

Autosys Workload Automation

Issue/Introduction

When sorting a list of jobs in a Monitoring view by the status column, it doesn't appear to be an alphabetical sort by the status name.
What determines the sort order for the status column?

Environment

Autosys 12.x
WCC
WORKLOAD CONTROL CENTER

Resolution

In the WCC database, a job status is stored as a numeric code. When you sort by status, it uses the numeric code to determine the order rather than the actual status name. Here are the codes for each status...

1 - RUNNING
3 - STARTING
4 - SUCCESS
5 - FAILURE
6 - TERMINATED
7 - ON_ICE
8 - INACTIVE
9 - ACTIVATED
10 - RESTART
11 - ON_HOLD
12 - QUE_WAIT
13 - WAIT_REPLY
14 - PEND_MACH
15 - RESWAIT
16 - ON_NOEXEC
17 - SUSPENDED