Tuesday, 26 January 2010

Execute a SQL Agent job from TSQL

exec msdb.dbo.sp_start_job 'jobname'

(does what it says on the tin!)

No comments: