Export (0) Print
Expand All
Expand Minimize
1 out of 1 rated this helpful - Rate this topic

How to: Automatically Delete a Job (SQL Server Management Studio)

This topic describes how to configure Microsoft SQL Server Agent to automatically delete jobs when they succeed, fail, or complete.

To automatically delete 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 edit, and then click Properties.

  3. Select the Notifications page.

  4. Check Automatically delete job, and choose one of the following:

    • ClickWhen the job succeedsto delete the job status when it has completed successfully.

    • ClickWhen the job failsto delete the job when it has completed unsuccessfully.

    • ClickWhen the job completes to delete the job regardless of completion status.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.