Finding jobid from sysprocesses table.

• sa24

  SSCrazy Eights

  Points: 8027

  More actions

  May 1, 2003 at 11:34 am

  #81889

  I'm trying to schedule a job which would be running every morning and will check if any other jobs are running. I'm checking the sysprocesses table for program_name column and that would give me the job id. My issue being that when i convert this jobid to varbinary, it is different as compared to the jobid value in sysjobs. Please advise

• Antares686

  SSC Guru

  Points: 125444

  More actions

  May 1, 2003 at 5:44 pm

  #455955

  Look at sp_help_job in BOL you can look for a job with a specific @execution_status. This should help.

• sa24

  SSCrazy Eights

  Points: 8027

  More actions

  May 1, 2003 at 6:29 pm

  #455960

  Antares,

  Thanks a lot. Didn't think about that.