SQL Agent CmdExec - how to throw error without seeing JIT debugger option

  • I have a .NET console app that I'm executing from SQL Agent. I am handling some exceptions, but in one case I want to throw the exception and stop the job. When this happens the Visual Studio Just-In-Time Debugger dialog pops up. What needs to happen so that the job will simply fail (with the exception being logged to the job history)?

  • TRY....CATCH is an option

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

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

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