How to Force SQL Server Job Step to Fail

Problem

Need to force an operating system job type to fail.

Solution

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.

}