COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Connection, Viewer, Scheduler => Topic started by: okh310 on 07 Apr 2015 03:49:50 PM

Title: Scheduling a report to run on a certain day of month and every day after
Post by: okh310 on 07 Apr 2015 03:49:50 PM
I'm trying to set up an event studio alert schedule.  My report basically checks to see if a user has submitted data into the system.  I want to run this check on teh 18th of the month and every day after UNTIL they have submitted the data. 

I have the event studio condition and email alert.  I can schedule it to run on the 18th day of the month.  BUT how do i tell it to run every day after the 18th UNTIL there is data submitted?  Not sure.  Thanks in advance.
Title: Re: Scheduling a report to run on a certain day of month and every day after
Post by: MFGF on 08 Apr 2015 04:11:56 AM
Quote from: okh310 on 07 Apr 2015 03:49:50 PM
I'm trying to set up an event studio alert schedule.  My report basically checks to see if a user has submitted data into the system.  I want to run this check on teh 18th of the month and every day after UNTIL they have submitted the data. 

I have the event studio condition and email alert.  I can schedule it to run on the 18th day of the month.  BUT how do i tell it to run every day after the 18th UNTIL there is data submitted?  Not sure.  Thanks in advance.

Hi,

You can't do this directly. One option is to create another very simple agent that checks the date and checks whether data exists. You would schedule this agent to run every day, and return a True result for dates on or after 18th and data not existing. In this situation it would fire off the agent you have already created. For dates before 18th or where data exists, it wouldn't fire off your existing agent.

Cheers!

MF.
Title: Re: Scheduling a report to run on a certain day of month and every day after
Post by: okh310 on 08 Apr 2015 09:01:54 AM
Thank you for the suggestion.  I will test it out and let you know how it goes!