oracle删除oem中自动备份job

原文地址：http://blog.csdn.net/rudygao/article/details/30511357

1.在Oracle oem中可以执行自动备份的job,注意,其不在dba_jobs,dba_scheduler_jobs中

2.查看oem中的job

select a.job_name, b.execution_hours, b.execution_minutes
  from sysman.mgmt_job a, sysman.mgmt_job_schedule b
where a.schedule_id = b.schedule_id
   and a.job_type = 'Backup';

3.删除oem中的job,注意必需先DELETE_ALL_EXECUTIONS,而后STOP_ALL_EXECUTIONS,最后DELETE_JOB

DECLARE
BEGIN
  MGMT_JOBS.DELETE_ALL_EXECUTIONS(P_JOB_NAME => 'BACKUP_LABAPROD_000022', P_JOB_OWNER => 'SYS');
  MGMT_JOBS.STOP_ALL_EXECUTIONS(P_JOB_NAME => 'BACKUP_LABAPROD_000022', P_JOB_OWNER => 'SYS');
  MGMT_JOBS.DELETE_JOB(P_JOB_NAME => 'BACKUP_LABAPROD_000022', P_JOB_OWNER => 'SYS');
END;

4. 在Server -> Scheduler Central -> Jobs 中可以找到该job