Post reply

leaving a SQL Agent job as failed

  • April 7, 2016 at 4:58 am

    #315293

    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

    #1870393

    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

    #1870476

    Thanks, John

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply