Scheduling a report to run on 2nd business day excl hol

[bbrown1519]

Hi all,
I need a report to run on the 2nd business day of each month excluding Canadian (and company) holidays.  The report is built on a data module so I can't use the Event agent.  I have identified the following dates that the report should run for 2026 (2026-01-05,2026-02-03,2026-03-03,2026-04-02,2026-05-02,2026-06-02,2026-07-03,2026-08-05,2026-09-02,2026-10-02,2026-11-03,2026-12-02).
I can manually schedule the report 12 times but was wondering if there was an alternate way to do that?
thx!

[dougp]

I have a date table that includes holidays.  So Event Studio would work.  It doesn't seem it would be much effort for someone to create a package for Event Studio to use.

Alternatively, you could use an external event (https://www.ibm.com/docs/en/cognos-analytics/12.0.x?topic=scheduling-set-up-trigger-occurrence-server) based on a script that computes 2nd business day.  On Windows I might do this by calling a PowerShell script from a Windows Scheduled Task.  But you can also call the script from an ETL process to be sure it's not just on a schedule, but also that it runs following successful completion of your data mart load (instead of after a failure or while the data is still being loaded).