Schedule Report on a particular day

[neelimakoppu]

Hi All,

I have to schedule a report to run monthly. It should run on Monday which comes after Last friday of the month.
For ex: If you consider this month May, Last Friday is 29th May. My report should run on 1 June (Monday).
In Report scheduler, I see we can set to run on a partiicular day. Can we set the day that I have described above? Please help me. Thanks in advance.

[nsaxena]

Hi...i guess first monday of the every month may not fit in your case..you can try scheduling using trigger...

[EarthDog]

You could try to create an Event Studio agent and make your custom logic to trigger your report. Have you considered this?

[neelimakoppu]

I'm completely new to cognos.
To use By Trigger option, I don't have any other job to trigger this report. Can we trigger, even if it doesn't depend on any other job to finish?

I'm not aware of writing agent in Event studio.
Do you mean we need to write a code such that, when the date satisfying the condition is achieved, it triggers the report? We've to write agent using Java or javascript?
what ever agent we write in event studio, will run everyday and checks whether the condition is satisfied or not and then runs the report?
Can you please help me with that?

[cognos810]

Hello Neelimakoppu,
With the help of Event studio, you can achieve this.
In a Framework Manager Model that you already use or may be a new one, create a query subject with one data item in it. The expression for that data item, lets call it [SCHEDULE_CHECK] should be...
CASE
WHEN _day_of_week (_add_days(current_date , -3),1) =5
AND _days_between (
_last_of_month (_add_days(current_date , -3)),
_add_days(current_date , -3)
) < 7
THEN 1
ELSE 0
END
In simple terms, every day check for this...
Go back 3 days, check if it is a Friday "AND" if it is the last Friday of the month. If yes, run the report.

Then create a new event in event studio against the package which has the above data item. In the event condition, [SCHEDULE_CHECK]=1. In the steps of the event, add the report you want to execute. Save the event and then schedule it for everyday.

-Cognos810