autocal_asc preview dates for extended calendars

Products

• Autosys Workload Automation

Issue/Introduction

While there is an option through the AutoSys Calendar Utility (option 2, 5) which will display/preview the calendar dates for a specified extended calendar, there is a need to be able to do the same from command line and redirect the output to a file.

Environment

Release : 12.x, 24.x

Component : CA Workload Automation AE (AutoSys)

Resolution

There are no preview command line switches for autocal_asc.
While there are export options, the export of an extended calendar includes only its definition, not the list of generated/preview dates.
If the calendar is a standard calendar then it does display dates, as that is all it is, just a list of dates.

Until some enhancement request happens, the options are limited to:

1. Interactively use autocal_asc to display the dates for a specified calendar.
   
   
2. Query the db directly. requires db access and it is highly discouraged to interact with the DB directly as the schema can/does change between releases.
   
   Example:
   select day from ujo_calendar where name='<name>' order by day;

IMPORTANT: Querying the DB too much can have negative impact on database performance and availability, which in turn will have impact AutoSys functionality/availability. 
   Broadcom strongly advises against routine heavy DB query usage via external means.
   
   
3. The AutoSys webservice can also list calendars both standard and extended but like autocal_asc it is limited to only the definition, and will not display dates.
   See Manage Calendars (AEWS) in the AutoSys documentation.

Understanding that none of the current options may be ideal, unfortunately, these are the only available options at this time.

 

If these options are not viable for your organization, then the recommendation is to raise an Request For Enhancement (RFE) for consideration to implement a means to display/preview the calendar dates for extended calendars in a future release of the product.