Appworx Calendar Holiday Schedule Date Selection Report

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

We use Calendars within Application Manager to schedule the execution dates to run jobs. Is there a report within Application Manager that will show us the last few dates that are selected for specific Calendar. We would like to be alerted when there are no more selected dates on a specific calendar. Or be able to run a report that will show us the last few dates selected on a Calendar. 

Environment

Release : 9.4x

Component :CA Automic Applications Manager

Resolution

Unfortunately, we do not have any out of the box reports that shows the last few dates that are selected for specific Calendar. You may need to build a new report to get the information you're looking for.

You can have your DBA build your own SQL using the associated tables. Here are the tables:
Calendar dates are stored in the SO_HOLIDAYS table, and the name of the Calendars are stored in the SO_HOLIDAY_GRPS table.

Additionally,

AW_MODULE_SCHED holds all the calendar information 

Here's an example query:

select so_module as Module, aw_sch_name as Schedule, so_holiday_name as Calendar, so_holiday as Dates  from so_job_table a,  aw_module_sched b,  so_holiday_grps c, so_holidays e where b.aw_job_seq=a.so_job_seq  and e.so_holiday_grp=c.so_holiday_grp and b.aw_sch_units=c.so_holiday_grp and e.so_holiday > sysdate -1 and aw_sch_units > '1';