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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-07-03 : 07:25:35
|
| francis writes "Is it possible to run a vb program in sql jobs? If so, pls advise how?" |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2003-07-03 : 17:18:57
|
| If it's an exe that can be run from the command line and expects no user input then you can use a CmdExec job step to run it as if from the command line. If you need to pass dynamic parameters etc based on data from sql you can use a TSQL job step and shell out to the cmd line using xp_cmdshell. If the exe pops dialogs though the job will just hang so make sure it fails gracefully.HTHJasper Smith0x73656c6563742027546f6f206d7563682074696d65206f6e20796f75722068616e6473203f27 |
 |
|
|
|
|
|
How do I run a vb program in SQL Jobs