If you are unable to create a new account, please email support@bspsoftware.com

 

issue in weekly Scheduling in cognos 10.2.1 by using cognos event studio

Started by MANI-1986cognos, 15 Dec 2016 07:44:57 AM

Previous topic - Next topic

MANI-1986cognos

Hi Cognos Experts,

I am using cognos v 10.2.1.

1) I have a report which has to be scheduled from 10 AM to 11 AM and with the 20 mins intervals .
2) This schedule should be a weekly schedule from Monday to Friday and it should not run on SAT and SUN.
3) This report should be scheduled when the total number of records > 0.

So we have opted to use the cognos event studio to achieve this.

I have created an event where it will check the run date is current date and it will in turn have a job attached to it.

this job will in turn call a event where the main functionality is happening. In this event we will check the event condition and schedule it.

WE HAVE SCHEDULED IT WEEKLY FROM 10 AM TO 11 AM , MON TO FRI WITH 20 MINS INTERVAL.

SCHEDULES WILL BE : 10:00 AM,10:20 AM,10:40 AM, 11 AM.

THE RESULTS FOR THE ABOVE SCHEDULES WILL BE IN MY MAIL BOX BY

1) FOR 10 AM --> 10:20 AM
2) FOR 10:20 AM --> 10:40 AM
3) FOR 10:40 AM --> 11 AM
4) FOR 11 AM --> 11 20 AM

THE ISSUE IN THE ABOVE OUTPUTS FIRST 3 IS WORKING PERFECTLY BUT THE LAST ONE 4TH (EVENT EXECUTES BY 11 AM --> OUTPUT IN MAIN BOX 11:20 AM) is not working as expected.
SINCE ITS THE LAST EVENT ITS IN PENDING STATE ALL WAYS AND ITS TAKING ITS OWN TIME TO RUN. BUT EXPECTED IS THAT I SHOULD HAVE A MAIL BY 11 20 AM IN MY MAIL BOX WHICH IS NOT HAPPENING .

Thanks and Regards