We have a stored procedure setup on one of our database servers which goes through and sees if we have any long running jobs and returns a 1 or 0 depending on whether there are any long running jobs or not. Is there any way to setup an alert for this in Advanced Alert Manager so that it runs the Stored Procedure every so often and then creates an alert if there is a long running job?
