Post reply

Job status

  • May 29, 2008 at 5:42 am

    #121629

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

    Thanks for any help

  • May 29, 2008 at 6:46 am

    #821719

    You can try the following link:

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

  • May 29, 2008 at 2:53 pm

    #822016

    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

  • May 29, 2008 at 8:27 pm

    #822062

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

    Manoj

    MCP, MCTS (GDBA/EDA)

  • May 29, 2008 at 8:29 pm

    #822063

    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