RAISERROR within SQLServerAgent job

[Andel]

Hello folks,

I'm trying to use RAISERROR on my stored proc to log an error message to the event log. This is fine. The problem is, when I use SQLServerAgent to run the stored proc, the sqlagentjob reports failure everytime. How can I use the raiserror command and have the sqlagent job reports success?

Here's a sample (part) of the stored proc.

raiserror('Test Error Message', 16,1) with log

 

[SQLDenis]

put an if in front of it

if app_name() not like 'SQLAgent - TSQL JobStep%'
begin
raiserror('Test Error Message', 16,1) with log
end

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

 

[Andel]

ok, but will it still execute the raiserror if app_name() not like 'SQLAgent - TSQL JobStep%'?

 

[SQLDenis]

one way to find out, take the code and run it in query analyzer

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/