COGNOiSe.com - The IBM Cognos Community

Hi Cognos Community,

We have below question regarding one Event/Agent in our Cognos production

We have one event which runs every day except first of the month and it is scheduled to run by Trigger.

This event has 20 jobs 

Event condition is - _first_of_month({sysdate}) <> {sysdate}

Now our requirement is to run one of the job out of 20 jobs from this event separately.

For this i have removed all the jobs from existing event and kept the job which we required to run separately and Saved As the Event with different name and gave event condition as same as existing event (_first_of_month({sysdate}) <> {sysdate})

The next day when the triggered fired from DW, I could see only the existing evet started running and the other event I Saved As from existing event has not started running.

I am thinking it might be because we have same event condition for both events or it maybe I Saved As from existing event? But not sure.

Any suggestions here please and please let me know if it is possible to run multiple events with same event condition parallelly with same trigger.



Thanks,

Lokeswara

So, you created an Event Studio Agent, but is it scheduled?

Yes It is scheduled to run by trigger as soon as Data Refresh is completed on Datawarehouse

Quote from: Lokesh Reddy on 10 Dec 2024 09:11:13 AMHi Cognos Community,

We have below question regarding one Event/Agent in our Cognos production

We have one event which runs every day except first of the month and it is scheduled to run by Trigger.

This event has 20 jobs

Event condition is - _first_of_month({sysdate}) <> {sysdate}

Now our requirement is to run one of the job out of 20 jobs from this event separately.

For this i have removed all the jobs from existing event and kept the job which we required to run separately and Saved As the Event with different name and gave event condition as same as existing event (_first_of_month({sysdate}) <> {sysdate})

The next day when the triggered fired from DW, I could see only the existing evet started running and the other event I Saved As from existing event has not started running.

I am thinking it might be because we have same event condition for both events or it maybe I Saved As from existing event? But not sure.

Any suggestions here please and please let me know if it is possible to run multiple events with same event condition parallelly with same trigger.



Thanks,

Lokeswara

Is the event set to fire the job for new events, or just for ongoing? If it's not set to fire for new events, it won't do anything the first time it runs. It checks the previous stored result from when the agent last ran against the current result. If the previous result was null (ie nothing stored), it treats the event as being new. If you don't have the agent set to do anything for new events, nothing happens (apart from the current true/false result being stored). Wondering if this is your issue? If so, it should start to run successfully from now on, as there is a result stored.
Cheers!
MF.