A personal repository of technical notes. - CSC

How to Force SQL Server Job Step to Fail


Need to force an operating system job type to fail.


In a .NET application, set the ExitCode of the Environment object to a value other than zero. C#.NET example:

private static void TestSqlJobOutput()
       System.Console.WriteLine("Sample Error Message 1"); // Shows up in SQL Server job history log.
       Environment.ExitCode = 1; // Causes SQL Server job step to fail when application ends.

No comments:

Post a Comment