Job Outcome Constants (SQLDMO_JOBOUTCOME

Job Outcome Constants (SQLDMO_JOBOUTCOME_TYPE)

microsoft.public.sqlserver.programming

22 Jun 2006 4:21 PM

marcmc

How can i write a simple procedure as below, call it from a job, and because
@m = 2 it will fail the job step and so show me the red x beside the job name
in ent mgr?

create procedure marc1 as

declare @m int
set @m = 2
if @m = 1
begin
    print '2'
end
else
begin
    print '2'
    return -1
end

22 Jun 2006 4:38 PM

Tracy McKibben

marcmc wrote:
Show quote

> How can i write a simple procedure as below, call it from a job, and because
> @m = 2 it will fail the job step and so show me the red x beside the job name
> in ent mgr?
>
> create procedure marc1 as
>
> declare @m int
> set @m = 2
> if @m = 1
> begin
>     print '2'
> end
> else
> begin
>     print '2'
>     return -1
> end

Use RAISERROR:

e.g. RAISERROR('My error message', 16, 1)