How to remove / delete / un-schedule Oracle OEM scheduled backup jobs

 

9-Aug-2012

 

This article discusses how to delete an RMAN backup job schedule from Oracle Enterprise Manager.

 

At one of my client sites, I am using RMAN to perform weekly full database backups and daily incremental backups. Furthermore, I am using OEM to create the RMAN scripts and schedule said backups.

 

As far as I can see, there is no way to make changes to RMAN backup jobs that have been scheduled through OEM. The only option to modify an existing OEM-scheduled backup job is to delete the existing job and create a new one. This alone is enough to convince me that using OEM to schedule backups is a questionable practice for managing database backups. But that’s another topic.

 

The problem I spent far too many hours resolving was in determining exactly how to delete an existing backup job in OEM. The answer is dead easy, but unfortunately, it seems to be a national secret. Here is the secret.

 

To permanently delete a scheduled backup job from OEM 10g:

 

  1. In the OEM application, on the Home tab, there is a section, “Related Links”, near the bottom of the page. Click the link “Jobs”. (A similar link (also named “Jobs”) appears on the ADMINISTRATION tab, under the Database Administration section, in the Database Scheduler subsection, but that takes you somewhere quite different.)

 

  1. This will display the Job Activity page. It displays a list of OEM-scheduled backup jobs, including jobs that have executed recently and jobs that it has queued to run in the future.

 

  1. Use the “Select” radio buttons on the left side of the list to select the job you want to delete. You need to select a job that is queued for execution, not one of the jobs that have already run.

 

  1. Click the Delete button.

 

  1. OEM will then ask you “Do you want to delete just this run or delete all runs of job: job-name?” .

 

  1. Click the Delete All Occurrences button to un-schedule the job.

 

So that’s the secret. Yes, I had noticed the Delete button on the Job Activity page, but until I tried it, I had assumed that “deleting” a job from this list would simply delete that particular instance of the job, but that OEM would continue to automatically resubmit the job into the execution queue at the appropriate time. When it asks the magic question above, that’s exactly what it will do if you just click the Delete button. The Delete All Occurrences button is the magic that handles un-scheduling a job “permanently”, so-to–speak. I have yet to see any documentation that mentions the Delete All Occurrences button.




Return to Tyndall Park