Question on Standard and Extended AutoSys Calendars

book

Article ID: 16808

calendar_today

Updated On:

Products

CA Workload Automation AE - Business Agents (AutoSys) CA Workload Automation AE - Scheduler (AutoSys) CA Workload Automation Agent

Issue/Introduction



How do you easily find out if a standard calendar is referenced in an extended calendar?

Environment

CA Workload Automation AE r11.3+

Resolution

You can perform a simple SQL query search in the database. The SQL query statement that would provide this information is as follows:

SELECT name AS ext_cal_name, as_cyccal AS cycle_calendar, as_holcal AS holiday_calendar FROM AEDBADMIN.UJO_EXT_CALENDAR;