Post reply

Exectuting jobs from a remote machine on the LAN

  • December 2, 2011 at 8:32 am

    #391017

    I would like to run a single job from another machine on the network. How would I be able to do that?

    Thanks

    Mike

  • December 2, 2011 at 8:44 am

    #1415953

    To be clear,

    Are you asking to execute job1 that is on ServerA from WorkstationB automatically or manually?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • December 2, 2011 at 9:01 am

    #1415978

    You always execute jobs from the server. Even if you connect from your workstation using SSMS, you are "asking" SQL Server to run the job.

    If you want to run a job in SQL Agent, use SQLCMD to connect to the instance and execute sp_start_job.

    If you want to run a Windows Scheduled Task on another machine, you need to use something like psexec from SysInternals to connect to that host and execute the job

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply