Finding all Job Schedules that are set to a specific time zone using sql

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

How do I find all Job Schedules that are set to a specific time zone value in sqlplus?

Environment

Release : 9.3

Component : Applications Manager

Resolution

The below statement can be run to check the time zone sequence number for the time zone name that is specified. The example below shows the timezone EST. Replace this value with the time zone name value as required:

select aw_tz_name, aw_tz_seq
from aw_timezone_list
where aw_tz_name like 'EST';

Once the time zone sequence number for the specified time zone is found, run the below statement to get the Job name and Schedule which is using the specified time zone:

select a.so_module, b.aw_sch_name
from so_job_table a, aw_module_sched b
where a.so_job_seq=b.aw_job_seq
and b.aw_time_zone='<TZ SEQ VALUE>';

The second statement should return the Job(s) name and Schedule name that is using the specified time zone value.