Sql query for Job and Process Flow name, description, job type, and schedule information

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

Is there a sql to query for the following information:

Job/Module Name
Process Flow Name
Description
Job Type
Schedule Name
Schedule Unit
Schedule Frequency
Schedule Start Time
Schedule active or inactive

Resolution

The following sql can be run to query for this information:

SELECT
    a.so_module AS "Job Name",
    a.so_job_descr AS "Job Description",
    a.so_command_type AS "Job Type",
    b.aw_sch_name AS "Schedule Name",
    CASE b.aw_sch_units
        WHEN -6 THEN 'Workday'
        WHEN -5 THEN 'Minutes'
        WHEN -4 THEN 'Hourly'
        WHEN -3 THEN 'Daily'
        WHEN -2 THEN 'Weekly'
        WHEN -1 THEN 'Monthly'
        ELSE h.so_holiday_name
    END AS "Schedule Units",
    b.aw_sch_interval AS "Schedule Frequency",
    TO_CHAR(TRUNC(SYSDATE) + (b.aw_start_time / (24 * 60 * 60)), 'HH24:MI') AS "Schedule Start Time",
    b.aw_active AS "Schedule active/inactive"
FROM
    so_job_table a
INNER JOIN
    aw_module_sched b ON a.so_job_seq = b.aw_job_seq
LEFT JOIN
    so_holiday_grps h ON b.aw_sch_units = h.so_holiday_grp AND b.aw_sch_units > 0;

 

 

Additional Information

To understand Schedule Units and Frequency:

1. If for example, the Schedule Units is "Hourly" and the Schedule Frequency is "2", this means the schedule runs every 2 hours.

2. If Schedule Units is listed as any other value besides Workday, Minutes, Hourly, Daily, Weekly, or Monthly, the value is referencing a Calendar name.