Question on Standard and Extended AutoSys Calendars

Products

• CA Workload Automation AE - Business Agents (AutoSys)
• CA Workload Automation AE - Scheduler (AutoSys)
• 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;