April 7, 2016 at 4:58 am
The SQL Agent jobs that are set up where I work all have a final step labeled 'complete.' This step does one simple 'select getdate()'
This step is not in the workflow. The steps before it will all lead to a job completion in either success or a failure.
Should a job ever fail, one of my co-workers will run the last step manually, so that the last time the job was run it succeeded.
Is there a reason that a SQL Agent Job cannot be left as having failed in its last attempt?
April 7, 2016 at 5:12 am
None whatsoever. But there are a couple of reasons why you might not want that. Maybe the job is disabled and you don't want a big red X on your job activity monitor in perpetuity. Or maybe you reviewed the failure and decided it's not important and therefore don't want it appearing on your failed jobs report.
John
April 7, 2016 at 7:41 am
Thanks, John
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply