Automic Calendar Events

[Anchelin Hutchison]

hi All

i need to setup a calendar event for a job that kicks off a ssis package. the package should run the 9th business day of every month. (so it should exclude weekends).

I tried but like for January, it shows as on the 9th and not on the 13th (which is the 9th business day of January :( )

can someone PLEASE assist?

regards

[Leon Carroll]

You'll want an offset calendar for this.  

You'll need the following calendar events - 1st day of the month and working days.   The working days should be based on Monday to Friday subtracting any holidays for your region

Then create a new Calender event 9th_working_day_month as an offset event, matching to the 1st day of the month, matching to the nearest date after the 1st day of the month to the target event of working days with an additional offset of 8 days.

There's an example here for the third working Monday here which is similar 
https://docs.automic.com/documentation/webhelp/english/ALL/components/DOCU/24.3.0/Automic%20Automation%20Guides/Content/AWA/Objects/obj_CALE_Examples.htm?tocpath=Using%7CDesigning%7CObject-Specific%20Properties%7CCalendars%20(CALE)%7C_____5

[Anchelin Hutchison]

hi Leon

Thank you for this. I appreciate it.

I noticed that the 1st day of February and March,etc fall on a Saturday,
but I need to skip the weekend and then only start the working day the next
Monday.

How can I achieve this with the solution you already provided?

Thank you so much in advance.🙏

[Daryl Brown]

There's a few ways to build this.

For example:

• Setup a monthly calendar for 1ST_OF_MONTH
• Setup a weekly calendar for ALL_DAYS
• Setup a weekly calendar keyword for SATURDAYS
• Setup a weekly calendar keyword for SUNDAYS
• Setup a calendar keyword (probably a group one) for HOLIDAYS

For your 1ST_BUS_DAY_OF_MONTH calendar keyword, set this up as an offset keyword one with the following config:

• start with the existing event of 1ST_OF_MONTH
• define three exceptions:
  • on collision with SATURDAYS, Match to target event after or on SATURDAYS / Match to ALL_DAYS / Advance by 1
  • on collision with SUNDAYS, Match to target event after or on SUNDAYS / Match to ALL_DAYS / Advance by 1
  • on collision with HOLIDAYS, Match to target event after or on HOLIDAYS / Match to ALL_DAYS / Advance by 1

[Anchelin Hutchison]

hi Daryl

February 9th working day is still on the 12th and should be on the 13th.
See attached configs please.

[image: image.png]
[image: image.png]
Regards

[Daryl Brown]

I'm not seeing your images here...can you try attaching/pasting them again?

[Anchelin Hutchison]

please see image

[Daryl Brown]

What does your WORKINGDAYS_xxxx keyword look like?

Right now, you have this configured to start with the 1st day of the month, and count off the next 8 valid days from your WORKINGDAYS_xxxx keyword.  If that keyword isn't excluding Saturdays, Sundays, and holidays, then that's your problem -- you're literally just adding 8 days (not necessarily 8 *business* days), and then offsetting the result based on whether it falls on a Saturday or Sunday.  Your WORKINGDAY_xxxx keyword should be using those same exclusions for Saturdays and Sundays.

[Anchelin Hutchison]

hi Daryl

see attached.  where can i get training...i am struggling!

please..how can i get this to work? :(

thank you for all your assistance thus far.

[Daryl Brown]

Oh, I see the issue.  (Took me a bit!  Don't worry; you're close.)

You're using a starting event of the 1st day of the month, rather than the 1st working day of the month.  (What you've effectively defined right now is the "8th working day following the first day of the month", which is not quite the same as the "9th working day of the month".)  To find the 9th working day of the month, you'll need to start by knowing when the first working day of the month is, not just the first day itself.  So you'll need to define yourself a 1ST_WORKING_DAY_OF_MONTH -- basically just like you have it above, but without the additional 8 days offset.  (Change that part back to 0.)

Next, to correct your 9TH_WORKING_DAY_OF_MONTH, you'll just need to change your starting event from 1STDAYOFMONTH to 1ST_WORKING_DAY_OF_MONTH.  Once you do that, you won't need to worry about the Saturday and Sunday exceptions, as you'll already be skipping over those by virtue of postponing by dates already in your WORKINGDAY_xxxx event.

[Anchelin Hutchison]

hi Daryl

Just an update. I did not want to leave this thread as "unresolved". 

The developer decided to built in the 9th working day calendar event in his ssis package.

Thank you so much for all your assistance as well as the other guys higher up in thread. i appreciate it.