Job status

  • Let me know the table name to check the status of job whether it is running or not?

    Thanks for any help

  • You can try the following link:

    http://www.mssqltips.com/tip.asp?tip=1054

  • You can use execute master.dbo.xp_sqlagent_enum_jobs 1,

    'garbage' -- doesn't seem to matter what you put here

    you can insert this into a temp table and pick out the job you are interested in, state = 1 is running, can't remember the other values. I use this to poll for jobs and run a report for jobs that have been running for n number of minutes.

    Andrew

  • You will get it from msdb DB. "Job History Table"

    Manoj

    MCP, MCTS (GDBA/EDA)

  • You will get it from msdb DB. "Job History Table"

    Manoj

    MCP, MCTS (GDBA/EDA)

Viewing 5 posts - 1 through 4 (of 4 total)

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