job keep running if fail

Dear All

In SQL Server 2000, I schedule a job to run a exe. I expect the return of this result show the success or fail. However, I find the job keep running if fail. Actually, I want to see the failed status in enterprise manager.

Could you give me some suggestions how to return a fail from VB6 program to SQL Server? Maybe give me other directions to solve the problem? Thanks a lot.

More Information
I run the exe by double click. if it fail, it return a prompt message box.

Alex

This is a SSIS not DTS or VB6 forum, so you may get better responses on a more appropriate forum or newsgroup-

http://www.devx.com/vb2themax/Tip/18288

|||

Reading again is see you mention a message box. This will cause the scheduled job to just hang. You should never throw message boxes or any other form of UI when running unattended. I think there may have been an option suppress errors in message boxes, somewhere in project properties, but it has been a long time since I used VB6. Try the newsgroup, or just searching Google Groups.

sql