We use Event Studio to schedule reports, usually with condition 1=1 because we always want the report to run, and a specific date\time for the reports to run. I need a list of when these are scheduled to run, and whether they are on a specific day, or every day, or every Monday, etc. I have found data in the content store to tell me most of this info, but cannot find the scheduled run time anywhere. I can find the history from run reports, exactly when they ran, but am having trouble joining that info to the content store scheduling info. Has anyone figured this out & can point me in the right direction?
Thanks
Lori
The overview over all scheduled items in the Cognos Administration Interface doen't fit your needs?
btw, what puzzles me: Why don't you use the normal Scheduler instead of Event Studio Events? I'm looking for an overvalue while using scheduled Events which all-time-run-conditions instead of just schedule the reports directly but i actually can't find one... ;)
I have no idea why Event Studio was chosen to schedule reports instead of the 'Schedule Report' functionality. It was set up this way before I came on board. It was also set up 3 versions ago, so there might have been functionality not available way back when. I should probably ask those questions of my user.
My user wants an excel spreadsheet of the job name, the scheduled run time, and whether it is scheduled daily, weekly, monthly, or quarterly, if it is scheduled for a particular day of the month, day of the week, etc. I can't see all that info on the 'Upcoming Activities' screen.
I'm still slogging thru on this problem. Never say never, and all that jazz.
Lori
Ah ok.
Just looked around in our Content Store. There are some tables around with names like NC_SCHEDULE, NC_TASK and some around them. As i got it, the scheduled run times are stored here. Also the information, in what cycle they are scheduled. The next run times of scheduled events and taks (does anyone know the difference of event and task?) could be in the tables like NC_SCHEDULE_QUEUE and NC_TASK_QUEUE.
Maybe this helps you out?
If you get a working solution, would be cool if you share them with us. Thanks in advance.
Oh, I'm finding all kinds of tables with scheduling information. I can get a list of Event names, when they last ran, and whether they are daily, weekly, monthly, etc. And I can get a list of events (but no names) with the next scheduled run time, and whether they are daily, weekly, monthly, etc. But I have yet to figure out how to get the Event Name matched up to the next scheduled run time. As far as I can tell there is no obvious data relating the two tables. I don't want to just go with the last ran date, and extrapolate forward, because for instance, the event is scheduled for 7:30AM, but Cognos service does not start until 8AM, so the last run time will show as 8AM, not 7:30AM.
Confusing, I know. Just an FYI - on the NC tables, the 'dates' are stored as 19 digit numbers, which are the number of microseconds since 01-01-1970. Don't congratulate me on figuring that one out - I have a math\computer whiz who gave me the answer pretty quickly without me gouging my eyes out. ::)