• Blacked process Th Hold is used to identify blocked query and process/alert or trigger any WMI event,

    moreover you can use it for broker services

    When you configure BPTHold SQL will automatically notify event.

    For that you can use SP_Configure for configuring BPT. Values would be seconds