SQL7 VB Job Return Codes

01-14-2004, 09:08 AM

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?

01-14-2004, 09:48 AM
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?

01-14-2004, 10:43 AM
How would I get the retrun code from the VB exe to the batch file?

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum