How to: Automatically Delete a Job (SQL Server Management Studio)
SQL Server 2005
This topic describes how to configure Microsoft SQL Server Agent to automatically delete jobs when they succeed, fail, or complete.
-
In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.
-
Expand SQL Server Agent, expand Jobs, right-click the job you want to edit, and then click Properties.
-
Select the Notifications page.
-
Check Automatically delete job, and choose one of the following:
-
Click When the job succeeds to delete the job status when it has completed successfully.
-
Click When the job fails to delete the job when it has completed unsuccessfully.
-
Click When the job completes to delete the job regardless of completion status.
-
Click When the job succeeds to delete the job status when it has completed successfully.
