Dear All,

The problem is that:
i'm now going to schedule a job in SQL Server, before the job starts, i've added a job step(CmdExec) to run a VB program (its .exe, written my myself) to check for some cases, if it is passed, then the job carries on, if it is failed. then stop the job.
1) How can i get the return value from the VB in the job and 2) how can i write the VB program in order to return a value ?

Thx all experts