August 14, 2004

Did you know you can start a job from the Query Analyzer? Here’s how you do it: exec msdb.dbo.sp_start_job @job_name = ‘My SQL job’

The WshShell Exec method can be used to launch a process. It returns an object that can be used to monitor execution and to access the stdin and stdout streams. The following function uses it to launch a command line and return it’s output, with a timeout parameter: Function ExecCommandLine