How do you guys cope with jobs that fail due to windows errors? SQL Agent does not see them as errors so the job completes successfully, which it is not.
I mean things like getting access denied while trying to write to a windows folder.
I would get the output of a xp_cmdshell command into a temp-table. Then you can query this temp-table for possible errors. Use RAISE ERROR when there is an error found.
** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply