Struck Jobs

[former_member182521]

I am trying to get the list of Struck jobs from Cronacle. I created the process monitor filter to get the list of struchk jobs that are waiting for more than 4 hours. Is there any query which I can generate for this requirement so that I can schedule and send alerts?

struckjobs.jpg

[gmblom · Accepted solution]

Hello,

Active Monitoring module can setup rules on all processes that are in a certain state longer than a certain amount of time.

For a report (Definitions->Reports) you can use the following query:
select * from Job j where j.ParentJob is null and j.Status in ('W', 'U', 'u') and j.RunStart < now('subtract 4 hours')

Regards Gerben