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

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How do you proactively monitor Cognos schedules?

Started by CognosAdmn, 26 Jun 2019 12:22:12 PM

Previous topic - Next topic

CognosAdmn

Hello,

I was wondering if anyone has built any solutions to proactively monitor the number of schedules currently running? Ideally, I would like to receive a notification if the number of items in Current Activities tab reaches (eg) 50.

The reason for this request is: During the first week of the month, we have several hundreds of reports and jobs scheduled. In the past few months, the schedules jobs and reports started hanging; they either had a "Pending" status or "Waiting" status. We did adjust the tuning settings for BatchReportService and that has helped. However, in addition to the performance tuning settings, we would to like to have this alert set up.

I have created an Event with the following conditions:
"[Time stamp] >= current_date
and extract(hour,[Time stamp]) >= extract(hour,current_time) - 10
and  [Report type] = 'Report batchreportservice'
and  [Status] = ''
and  count([Report name] for report) >= 50"

but when running this event (even with a report count of 1), I always get a "Event Condition not met" message.


Have you done something similar or accomplished this differently? Any help is greatly appreciated.


Regards,
Shiyam