-
SQL Server 2005 Agent - Run (Start) Jobs from Command-line
Please, how do I Run/Start a Job from the Command-line?
It's not dtsrun.
Thank you very much.
Greg
-
Re: SQL Server 2005 Agent - Run (Start) Jobs from Command-line
One method is to invoke sp_start_job using the SQLCMD command-line utility:
SQLCMD -S MyServer -E -Q"EXEC msdb.dbo.sp_start_job @job_name = 'MyJob'"
--
Hope this helps.
Dan Guzman
SQL Server MVP
"gstark" wrote in message
news:OaAKovpEIHA.5360@TK2MSFTNGP03.phx.gbl...
> Please, how do I Run/Start a Job from the Command-line?
>
> It's not dtsrun.
>
> Thank you very much.
> Greg
>