Start MS-SQL Server Jobs from the Query Analyzer
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’
Menu
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.