How to: Start a Job (SQL Server Management Studio)

This topic describes how to start running a Microsoft SQL Server Agent job.

To start a job

  1. In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.

  2. Expand SQL Server Agent, and expand Jobs. Depending on how you want the job to start, do one of the following:

    • If you are working on a single server, or working on a target server, or running a local server job on a master server, right-click the job you want to start, and then click Start Job.
    • If you want to start multiple jobs, right-click Job Activity Monitor, and then click View Job Activity. In the Job Activity Monitor you can select multiple jobs, right-click your selection, and click Start Jobs.
    • If you are working on a master server and want all targeted servers to run the job simultaneously, right-click the job you want to start, click Start Job, and then click Start on all targeted servers.
    • If you are working on a master server and want to specify target servers for the job, right-click the job you want to start, click Start Job, and then click Start on specific target servers. In the Post Download Instructions dialog box, select the These target servers check box, and then select each target server on which this job should run.

See Also

Concepts

Implementing Jobs
Running Jobs

Help and Information

Getting SQL Server 2005 Assistance