SQL Agent

Results 1 to 2 of 2

Thread: SQL Agent

  1. #1
    Join Date
    Dec 1969

    Default SQL Agent

    Is it possible to get the current status of a SQL Agent job from the database. I&#039;ve looked in msdb..sysJobs but there doesn&#039;t appear to be anything relating to this.<BR><BR>I&#039;m trying to run a number of different jobs in parallel and when the last one finishes I want to start another job. I was hoping to use the current status of each of the parallel jobs to control this. Any other suggestions would be useful otherwise I&#039;ll have to resort to setting a flag in the database with the status of each parallel process.<BR><BR>Thanks,<BR><BR>Gavin

  2. #2
    Join Date
    Dec 1969

    Default sp_help_Job <nt>


Posting Permissions

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