Job Orchestration and Holiday Schedule

[Derek2]

Have a need to skip jobs on certain days that align to holidays.

Was thinking about having a single job that checks for a holiday on a DB table and exits the process if the query returns a boolean true.

Just looking for ideas on what others have done.

[Prakhar1]

Hi @Derek Sutliff​ , according to me the DB table idea looks good for me because to find if the date is holiday or not is pretty difficult.

Finding weekends are easy but not the holiday.

[ashif2]

DB table approach is good , In addition to that , there should be additional check in place to make sure the holidays for upcoming year (say 2022) is updated .