+ Reply to Thread
Results 1 to 2 of 2

SQL Server 2005 Agent - Run (Start) Jobs from Command-line

  1. 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



  2. 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
    >



+ Reply to Thread