Passing errors from called app back to SQL

[monkeylizard]

SQL 2005

I'm scheduling a VB app to be executed through SQL Agent (CmdExec). A fellow developer said that he thought I could set this up to pass any errors rasied in the VB app back to SQL instead of displaying a pop-up box like VB normally does. The idea, of course, is to use SQL's notification tools to tell me that the job had errors.

Can this be done, and if so, how? I tried Google, but since I don't know what Microsoft may have called this feature, I don't know what keyword(s) to search for.

Monkeylizard
Sometimes just a few hours of trial and error debugging can save minutes of reading manuals.

 

[calico]

Hi,

On google tried loking on those words:

RAISE ERROR
Event Viewer
SQL Alert

I am not suree if I understand your need and what you mean by SQL's notification tool

Calico