SQL7 VB Job Return Codes

Tia,

I have a scheduled job run by SQL Agent that is a VB6 exe. The job runs fine 99% of the time, but has occasionally failed. When the job fails, I would like to utilize the SQL Agent to call a pager, send an email, etc. Unfortunately, I can't seem to get my VB exe to return a return code to the SQL Agent. Am I trying something impossible or am I having a brian lock?

I'm not sure if the VB application is able to send out a return code. Could you not put it in a batch file and have a return code in the batch file?

How would I get the retrun code from the VB exe to the batch file?