none
Notification for MSPS blocking queue jobs RRS feed

  • Question

  • All,

    I am looking for a solution to notify administrators of blocking jobs in the queue without them having to manually go each time and verify the queue.

    Has anyone worked on a similar solution? Not sure if any of you would know about the query to retrieve these jobs from the database too.

    Any pointers and guidance would be much appreciated.

    Many thanks.


    Regards, Naweed

    Thursday, January 10, 2013 4:31 PM

All replies

  • Hi Naweed,

    You can play around with the tables and views (name starting from MSP_QUEUE) of each Draft and Publish. For example see the view MSP_QUEUE_BOOKKEEPER_PUBLISHED_VIEW.

    You can generate your query based on your requirement.

    HTH


    Thanks, Kashif

    Friday, January 11, 2013 6:47 AM