Needs to delete old calendars in AutoSys 4.5 before migration to WA AE 11.3.5

Products

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

Issue/Introduction

Description:

When trying to delete old calendars in AutoSys 4.5 by "autocal_asc -D calendar-name" it does not allow to delete the calendar.

Solution:

The solution is to proceed by the following steps to create a script which will allow to delete all your old calendars before your migration to WA AE 11.3.5:

1. Run the following query on your AutoSys database to get a list of all your calendars:
   
   select distinct(name) from calendar;
   cal1
   cal2
   cal3
   cal4
   
   
2. Run autocal_asc in Print mode on the calendars you want to delete to get a list of the dates in appropriate format:
   
   $ autocal_asc
   Utility to Add/Delete or Print entries in Calendar.
   Calendar Name: cal3
   Add (A) or Delete (D) or Print (P) ? P
   Days in the Calendar: cal3
   --------------------------------
   01/01/2011 08:00
   02/01/2011 08:00
   03/01/2011 08:00
   04/01/2011 08:00
   
   
3. Build a script with the following format:
   
   calender-name
   D
   list-of-dates
   calendar-name
   D
   list-of-dates
   
   Example:
   vi old-cal-del.txt
   cal3
   D
   01/01/2011 08:00
   02/01/2011 08:00
   03/01/2011 08:00
   04/01/2011 08:00
   cal4
   D
   01/01/2011 12:00
   02/01/2011 12:00
   03/01/2011 12:00
   04/01/2011 12:00
   
   
4. Run the script by autocal_asc:
   
   autcal_asc < old-cal-del.txt
   
   
5. You can run the same query as in step 1 and will see cal3 and cal4 are deleted as expected
   
   select distinct(name) from calendar;
   cal1
   cal2
   
   Note: This method needs to be used for AutoSys 4.x release.
   
   With WA AE 11.3.5 autocal_asc utility has been improved so that calendars can be deleted by:
   
   autocal_asc -D calendar-name

Environment

Release: ATSY1C99000-4.5-AutoSys-Job Management-Class 1 Remote Agent
Component: