Errors from command files

[Alan]

Help!
I have a scheduled command exec that executes every minute. If the execution is successful it returns zero or non-zero if error. I would like to raise an error, that would be trapped as an alert to take corrective action.

[JL]

On 11/10/98 1:24:06 PM, Alan wrote:
> Help!
I have a scheduled command exec that executes every minute. If
> the execution is successful it returns zero or non-zero if error. I would
> like to raise an error, that would be trapped as an alert to take
> corrective action.

***

Use RAISERROR with a userdefined error-number ( 50001 or higher )
( You must define this error number in
SEM: Manage Alerts: Edit Alerts: ... behind the Error Number label : New
)
And then define an alert which responds to this error Number