Home Forums SQL Server 7,2000 T-SQL Finding jobid from sysprocesses table. RE: Finding jobid from sysprocesses table.

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