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

  • Article

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