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

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

To stop 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, expand Jobs, right-click the job you want to stop, and then click Stop Job.

   If you want to stop multiple jobs, right-click Job Activity Monitor, and then click View Job Activity. In the Job Activity Monitor, select the jobs you want to stop, right-click your selection, and then click Stop Jobs.

   For a multiserver job, a STOP instruction for the job is posted to all target servers of the job.

See Also

Concepts

Implementing Jobs

Help and Information

Getting SQL Server 2005 Assistance