Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Posts
    63

    Question Unanswered: How to know if a job is running...

    Howdy folks... just a quick question. Is there a system table that holds a variable that states if a job is currently running or not? Something like a status column for jobs. If so, where is it? and if not, any suggestions aside from setting a flag in a table when it runs and stops?

    TIA

  2. #2
    Join Date
    Dec 2002
    Posts
    63
    ha! Found my own answer... sp_help_job

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •