script to check long running job

• sqlfriend

  SSC Guru

  Points: 52769

  More actions

  August 9, 2012 at 12:11 pm

  #265806

  Recently we found there is a job in one of our testing server runs about 3 days and it is still running.

  Is there a script that I can use to check long run sql agent jobs in all our sql servers, and better yet to notify me if there is a job running for example more than 6 hours.

  Thanks

• Orlando Colamatteo

  SSC Guru

  Points: 182276

  More actions

  August 14, 2012 at 1:18 pm

  #1525752

  Have you done any searches online? What have you found?

  Have you tried developing a process yourself? What have you tried so far?

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato