Does detailed steps (job) activities for SQL Agent jobs get logged
step by step in the SQL Profiler Trace output (or file if specified)?
I did see an Agent entry for the scheduled start date/time for my job
but nothing further.

I know about the SQL Agent Log, but wondered if the Profiler Trace
could give detailed output of this activity as well.

Thanks in advance.

Zee-SS-DBA Atlanta GA

If you are looking for detailed info about a step of a job then you should
use a specific log for that step.

I'll show the way in case you are not aware of this property: Open up SSMS
(I assume it's 2005\2008, if it's 2000 then this feature is also available
but path is different). Then go to SQL Server Agent and find your job. Then
go to the job's properties and go to Steps. Edit your step and go to
Advanced. You'll see that there's an edit box (output file) where you can
enter a path for the log file and check "Include step output in history" so
that you'll see more info about the steps in the job history.

--
Ekrem Önsoy - SQL Server MVP
http://www.ekremonsoy.net - http://ekremonsoy.blogspot.com
MCDBA, MCITPBA & DBD, MCSD.Net



"Zee-SS-DBA" <zee.ss.dba (AT) gmail (DOT) com> wrote