Schedules Waiting for Events

security CMC
1

Hi Folks-
Is there anyway we can get a list of scheduled reports and events they are waiting for (if any). CMC gives us the next run time and other details, but Events does not show-up anywhere.

I was thinking System Profiler may be able to help me with that, but Events in SP does not break itself down to document-level.

Let me know if you have any suggestions.

Thanks
Jhyaikuti

jhyaikuti (BOB member since 2009-07-29)

2

Try using query builder.

Marfi :poland: (BOB member since 2006-12-18)

3

I tried using the Query Builder. Could not find anything that would indicate Events a report is waiting for?
Can you please elaborate more?

jhyaikuti (BOB member since 2009-07-29)

4

Just stumbled into this post… System Profiler does capture this information - there is of course the EVENT table that it generates, but also an EVENT_USAGE table that links Events to their associated scheduled reports.

crystal01 :us: (BOB member since 2006-08-30)