Holiday Exclusion Dates

How to exclude holiday dates from Schedule Watcher

Since Automate currently does not include a 'Holiday Exclusion' option in the Schedule Watcher trigger's properties, users have to manually exclude the proper dates under the 'Exclusions' tab. Unfortunately, this can only be accomplished on a per task basis and can get pretty tedious, especially if a user, for example, needs to modify over 70 tasks. Therefore, as a work-around some customers created a table or text file with the holiday dates in it . In this case, Automate can read this file as one of the first steps of the task to evaluate whether the current day is a 'Holiday Exclusion' day and act accordingly.

The attached sample task will perform what was explained above. Basically, the task will loop through a text file which includes the holiday exclusion dates (new line delimited) using the 'Loop List' action. An 'If' Statement is used within the 'Loop List' and 'End Loop' actions to evaluate if the current date matches any dates within the text file. If it does, a Stop Task action is used to stop the current task and mark as aborted. If there are no matching dates, a message box will appear displaying 'No exclude dates found. Task will proceed.'

Note that in order for the sample task to work properly in your system, some steps need to be modified. The current date / time format is mmddyy but this can easily be modified within the 'Format DateTime' action's 'General' tab. When selecting a particular date/time format, make certain that it is identical to the one selected within the text file Automate will read from (on step #5). Additionally, you will have to create a text document with the proper date format that Automate can read from.

Task Category:

Active Directory