Feed Hang Checker

This routine introduces a new SQL Server agent job into an existing instance of BPM Connect to detect and notify  hung jobs. 

Apply this script to the BPM Connect database.
BPMC_HANG_CHECKER.sql

For hang checker to work properly, SQL Server notification needs to be enabled and functioning in the BPMC Connect environment.

Once this script is applied, navigate to Data Process Control -> Settings, and set the "HangThreshold" key to the amount of minutes before a feed is considered hung. 

Hang checker introduces a new SQL Server agent job called BPMC_HANG_CHECKER and it requires manual configuration in Agent to get the notification working.  Any feed that exceeds the HangThreshold will cause this job to fail.  Emails can be assigned to the "on failure" event in the jobs notification properties.

The default schedule for this job is set to sniff every 1 minute for hung jobs indefinitely.  In some cases this 1 minute sniffer may be too aggressive.  This number can be tuned as per the requirements of the environment.

This functionality has been tested DBObjects version 1.6.0 or greater.