Agent

• sudhakara

  SSCrazy Eights

  Points: 9425

  More actions

  April 2, 2010 at 1:09 pm

  #138221

  Hi,

  can you share your knowledge on finding out the log running sql jobs in sql server 2005 by using T-sql query ?

  Thanks in Advance.

• NJ-DBA

  SSChampion

  Points: 13834

  More actions

  April 5, 2010 at 8:55 am

  #1145773

  Assuming you mean "long" running jobs? Maybe this is what you are looking for: http://sqlserverpedia.com/blog/sql-server-bloggers/sql-server-agent-%E2%80%93-query-to-find-long-running-jobs/