May 12, 2010 at 11:14 am
Hi All,
Can someone help me to set up a trace to monitor a job? One of my clients is saying that she is getting a page for a particular job is stopping and starting on every Sunday. I know that, we can check the job activity log in the view history of the job & SQL agent log. But I did’t find any information related to the job in the log.
First I want to know that is it possible to monitor a job through SQL profiler? If it is, then please let me know to setup the trace to monitor a particular job in the SQL Server.
Thanks in advance.
Regards
Raj
May 12, 2010 at 11:27 am
Picking out a particular job in profiler may be difficult.
You said you couldn't find that job's run information in history. That indicates 2 possible issues to me, first it didn't run and the person is mistaken about the source of her pages, OR that you have the settings for job history set too low. I believe the defaults are 1000 rows of history and up to 100 rows per job. What this works out to is that 5-10 jobs can monopolize the entire history and everything else gets forgotten. I'm not sure what your settings are but I like to set the max rows at like 100,000-300,000 depending on the number of jobs and the rows per job at 1000. This means that with 100 jobs I will have up to 1000 rows of history for each..
CEWII
May 17, 2010 at 5:54 am
Are you calling a stored procedure in your job? if yes, you can setup profiler for SP very easily by applying filter on TextData column.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply