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