Capacity Manager: how to remove old monitored databases and old jobs? (4352724)

Capacity Manager does not include the option to remove a database from monitoring.

1. Run select * from quest_cmo_databases and identify the database_id of the database you wish to drop

2. From the job page, right click on collection job and click disable. The job would still be in the dbms_scheduler job list but will not run.

3. To remove the job from Oracle scheduler, run as cmo owner:
begin
for c in (select job_name from quest_cmo_job_info where database_id = &&database_id) -- ****replace the &&database_id with the actual value****
loop
dbms_scheduler.drop_job(c.job_name);
end loop;
end;
/

4. Run the script cmo_delete_database.sql from the installation\repository folder. Note that you have to set the define variable (&&database_id) from step 2.