Monday, March 19, 2012

Job Failure External Log

Someone in this newsgroup has suggested turning on External Log to see the
job failure information as follow:
Job's properties, choose the step, click 'Edit' then choose 'Advanced' tab.
There would be 'Output file' field. Check if it is set and if it is, then
look at the file.
For a scheduled job failure, I find that there is no external log is
enabled. I would like to know where is the best place to put the external
log ? I don't want to mix it with other logs.
Thanks
I would put it with the other logs, but name it differently or put it in a
sub-directory underneath the logs directory. There it will easier to find.
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"Jason" <anonymous@.discussions.microsoft.com> wrote in message
news:OtHNrfpZFHA.464@.TK2MSFTNGP15.phx.gbl...
> Someone in this newsgroup has suggested turning on External Log to see the
> job failure information as follow:
> Job's properties, choose the step, click 'Edit' then choose 'Advanced'
tab.
> There would be 'Output file' field. Check if it is set and if it is, then
> look at the file.
> For a scheduled job failure, I find that there is no external log is
> enabled. I would like to know where is the best place to put the external
> log ? I don't want to mix it with other logs.
> Thanks
>

No comments:

Post a Comment