How do you determine if a SQL Server Agent Job is running, is there a way to automate the process, is there an easy way to determine all of the SQL Server Agent jobs that are currently running? Greg Larsen answers these questions, showing different methods that determine the state of an individual job, or all SQL Server Agent jobs.

This story continues at http://www.databasejournal.com/featu...le.php/3491201