May 29, 2008 at 5:42 am
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
You can try the following link:
May 29, 2008 at 2:53 pm
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
You will get it from msdb DB. "Job History Table"
MCP, MCTS (GDBA/EDA)
May 29, 2008 at 8:29 pm
You will get it from msdb DB. "Job History Table"
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