Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jestupinan
Starting Member
6 Posts |
 Posted - 2004-07-09 : 09:25:49
|
Hi,I have a Job which has a CmdExec Step which calls a VB.exe file. The file is executed fine but the Job shows Status: FailedAny clue?  I'm working on SQL Server 2000 SP4Thanks |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-07-09 : 10:26:00
|
| Guessing, but: is the VB app returning something which is causing ERRORELVEL to be set to something other than zero?Maybe the VB app is not explicitly setting a return value, and the "random" return value is causing it?Kristen |
 |
|
|
jestupinan
Starting Member
6 Posts |
Posted - 2004-07-09 : 11:19:56
|
| Kristen,The VB App is been executed by a main() module. It makes a few files operations and then ends.It does not return any explicit number. How can I return a value in VB6 when App ends?Thank you |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-07-09 : 12:39:30
|
| I don't know much about VB, but probable by having RETURN 0 as the last statement in main()Kristen |
|
|
|
|
|
|
JOB Shows Fail Status