Post reply

Finding jobid from sysprocesses table.

  • 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

  • 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.

  • May 1, 2003 at 6:29 pm

    #455960

    Antares,

    Thanks a lot. Didn't think about that.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply