If you have several 'Quarterly' type requirements there is a different approach you can take, which is to create a "Cycle Calendar" first that would define the start and end date of each quarter. You can then use that Cycle calendar in your extended calendar and use the keywords for cycles.
The condition Cfri#L is the last friday of the Cycle. If you have other last ddd of the quarter, you can easily do that. There are many other Cycle keywords like the nth workday of a cycle or the nth week of a cycle, that may ease these types of use cases. Here is a link to the keywords. You'll find the cycle ones towards the bottom of the page.
https://techdocs.broadcom.com/us/en/ca-enterprise-software/intelligent-automation/autosys-workload-automation/12-0/scheduling/ae-scheduling/manage-your-calendars/date-condition-keywords.html
Original Message:
Sent: Jul 28, 2023 10:48 AM
From: RPatel
Subject: How to setup extended calendar for running the autosys job Friday after every three months?
Hi Venkateshwar,
One more question how do I modify this jil if I want to use the same calendar for another job that needs to be executed Sunday or any last given day of the Quarter?
will this work?
calendar: Quarterly_Last_Day_Calendar_End_Date
description: Quarterly Last Day End Date For Automatic Date Generation
01/01/2038 00:00:00
extended_calendar: Quarterly_Last_Day_Calendar
description: Last Day of every quarter
workday: mo,tu,we,th,fr
non_workday: O
holiday: 0
holcal: Quarterly_Last_Day_Calendar_End_Date
cyccal:
adjust: 0
condition: (mar&(mon,tue,web,thu,fri,sat,sun)#L)|(jun&(mon,tue,web,thu,fri,sat,sun)#L)|(sep&(mon,tue,web,thu,fri,sat,sun)#L)|(dec&(mon,tue,web,thu,fri,sat,sun)#L)
usage job 1:
usage :
run_calendar: Quarterly_Last_Day_Calendar
days_of_week: fr
start_times: "17:00"
usage job 2:
usage :
run_calendar: Quarterly_Last_Day_Calendar
days_of_week: su
start_times: "17:00"
Original Message:
Sent: Jul 28, 2023 01:31 AM
From: Venkateshwar Goud Badrigari
Subject: How to setup extended calendar for running the autosys job Friday after every three months?
Hi Patel,
If you are using r12.0 and above, there is no restriction on the last date. If you are running r11.3.6 or lower versions then the date cannot go beyond 2038 due to 32bit restriction. If you are running r12.0 or above, you can use any date and an extended calendar will be created with all dates as requested.
If you wish to import the calendar use the below method:
1. Create a text file with the below content, say you name it as C:\tmp\test_cals.txt :
calendar: Quarterly_Last_Friday_Calendar_End_Date
description: Quarterly Last Friday End Date For Automatic Date Generation
01/01/2038 00:00:00
extended_calendar: Quarterly_Last_Friday_Calendar
description: Last friday of every quarter
workday: fr
non_workday: O
holiday: 0
holcal: Quarterly_Last_Friday_Calendar_End_Date
cyccal:
adjust: 0
condition: (mar&fri#L)|(jun&fri#L)|(sep&fri#L)|(dec&fri#L)
2. You can use "autocal_asc -I C:\tmp\test_cals.txt" command to import the calendars into the database.
I hope this helps.
------------------------------
Regards,
Venkateshwar Badrigari
Lead Software Engineer
CA Technologies - A Broadcom Company
venkateshwar.badrigari@broadcom.com
Original Message:
Sent: Jul 27, 2023 10:11 PM
From: Retesh Patel
Subject: How to setup extended calendar for running the autosys job Friday after every three months?
Hi Venkateshwar,
Thanks for the prompt reply!
How does it look in terms of jil file? Why are you suggesting date as "01/01/2038" ? Is that something Autosys can handle only 15 years in the future?
Will this JIL file work? will it be one file or should be import as two separate files?
calendar: Quarterly_Last_Friday_Calendar_End_Date
description: Last Friday of Quarter end
9/29/2023 0:00
12/29/2023 0:00
3/29/2024 0:00
6/28/2024 0:00
9/27/2024 0:00
12/27/2024 0:00
3/28/2025 0:00
6/27/2025 0:00
9/26/2025 0:00
12/26/2025 0:00
3/27/2026 0:00
6/26/2026 0:00
9/25/2026 0:00
12/25/2026 0:00
3/26/2027 0:00
6/25/2027 0:00
9/24/2027 0:00
12/31/2027 0:00
3/31/2028 0:00
6/30/2028 0:00
9/29/2028 0:00
12/29/2028 0:00
3/30/2029 0:00
6/29/2029 0:00
9/28/2029 0:00
12/28/2029 0:00
3/29/2030 0:00
6/28/2030 0:00
9/27/2030 0:00
12/27/2030 0:00
3/28/2031 0:00
6/27/2031 0:00
9/26/2031 0:00
12/26/2031 0:00
3/26/2032 0:00
6/25/2032 0:00
9/24/2032 0:00
12/31/2032 0:00
3/25/2033 0:00
6/24/2033 0:00
9/30/2033 0:00
12/30/2033 0:00
3/31/2034 0:00
6/30/2034 0:00
9/29/2034 0:00
12/29/2034 0:00
3/30/2035 0:00
6/29/2035 0:00
9/28/2035 0:00
12/28/2035 0:00
3/28/2036 0:00
6/27/2036 0:00
9/26/2036 0:00
12/26/2036 0:00
3/27/2037 0:00
6/26/2037 0:00
9/25/2037 0:00
12/25/2037 0:00
extended_calendar: Quarterly_Last_Friday_Calendar
description: Last friday of every quarter
workday: fr
non_workday: O
holiday: 0
holcal: Quarterly_Last_Friday_Calendar_End_Date
cyccal:
adjust: 0
condition: (mar&fri#L)|(jun&fri#L)|(sep&fri#L)|(dec&fri#L)
Original Message:
Sent: Jul 27, 2023 01:08 AM
From: Venkateshwar Goud Badrigari
Subject: How to setup extended calendar for running the autosys job Friday after every three months?
Mr Patel,
You can generate the extended calendar you wanted with the following
definition, you will not have to generate the calendars every year, below
definition will generate the calendars for every year until 2038:
1. Start with creating a Standard Calendar
2. When you are prompted for "Calendar Name:" give a name, I gave it
"Quarterly_Last_Friday_Calendar_End_Date"
3. When you are prompted for "Description", you can give your own
description
4. When you are prompted for "Date (MM/DD/YYYY [HH:MM]):" give "01/01/2038"
as the date
5. When you are prompted for "Date (MM/DD/YYYY [HH:MM]):" again, just hit
enter, this will generate the standard calendar
6. move on to the extended calendar definition and give it a name when you
are prompted for "Enter Name:", I gave it "Quarterly_Last_Friday_Calendar"
7. When you are prompted to "Enter Description:", you can give your own
description
8. When you are prompted for "Enter Workdays [XXXXX..]:", enter "fr"
9. Hit enter for the next two options to consider defaults.
10. When you are prompted for "Enter Holiday Calendar [none]:", give the
standard calendar we created in #1, I gave
"Quarterly_Last_Friday_Calendar_End_Date"
11. Hit enter for the next two options to consider defaults.
12. When you are prompted for "Enter Date Conditions [DAILY]:"
enter "(mar&fri#L)|(jun&fri#L)|(sep&fri#L)|(dec&fri#L)"
13. You will be prompted to preview the calendar, enter 1 to preview, and
you will notice that the dates are generated till 2037
14. Save the calendar and create jobs with start_time as "05:00" and
run_calendar as "Quarterly_Last_Friday_Calendar"
Hope this helps.
Regards,
*Venkateshwar Badrigari*
Lead Software Engineer
CA Technologies - A Broadcom Company
Plot 115/1, 115/16-115/21 | Hyderabad, 500032
venkateshwar.badrigari@broadcom.com
--
This electronic communication and the information and any files transmitted
with it, or attached to it, are confidential and are intended solely for
the use of the individual or entity to whom it is addressed and may contain
information that is confidential, legally privileged, protected by privacy
laws, or otherwise restricted from disclosure to anyone else. If you are
not the intended recipient or the person responsible for delivering the
e-mail to the intended recipient, you are hereby notified that any use,
copying, distributing, dissemination, forwarding, printing, or copying of
this e-mail is strictly prohibited. If you received this e-mail in error,
please return the e-mail to the sender, delete it from your computer, and
destroy any printed copy of it.
Original Message:
Sent: 7/26/2023 3:57:00 PM
From: RPatel
Subject: How to setup extended calendar for running the autosys job Friday after every three months?
How to setup extended calendar for running the Autosys job Friday at specific time at 5:00pm after every three months?
can you please advise on exact calendar setup and do I need to update this calendar every year?
Thanks a bunch in advance for your help!