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

Document ID : KB000018759
Last Modified Date : 14/02/2018
Show Technical Document Details

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