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!
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).