ORA-20414: The specified job has active executions.

SQL> select JOB_ID, JOB_NAME, JOB_DESCRIPTION from sysman.mgmt_job;

JOB_ID
--------------------------------
JOB_NAME
----------------------------------------------------------------
JOB_DESCRIPTION
--------------------------------------------------------------------------------
0DB38BB49E3AE3F7E050A8C0030C1D0F
BACKUP_ABRA_HOURLY_INCREMENT
Whole Database Backup

SQL> begin
 sysman.mgmt_jobs.stop_all_executions('BACKUP_ABRA_HOURLY_INCREMENT','SYS');
 sysman.mgmt_jobs.delete_job('BACKUP_ABRA_HOURLY_INCREMENT','SYS');
end;
/ 2 3 4 5
begin
*
ERROR na radku 1:
ORA-20414: The specified job has active executions.
ORA-06512: na "SYSMAN.MGMT_JOB_ENGINE", line 4490
ORA-06512: na "SYSMAN.MGMT_JOB_ENGINE", line 5183
ORA-06512: na "SYSMAN.MGMT_JOB_ENGINE", line 5266
ORA-06512: na "SYSMAN.MGMT_JOBS", line 315
ORA-06512: na line 3

Řešení
Dle MOS: How to Force Stop a Stuck Job in Grid Console (Doc ID 430626.1)

SQL> exec mgmt_job_engine.stop_all_executions_with_id('0DB38BB49E3AE3F7E050A8C0030C1D0F');
Procedura PL/SQL uspesne dokoncena.

select EXECUTION_ID, status from MGMT_JOB_EXEC_SUMMARY where job_id ='0DB38BB49E3AE3F7E050A8C0030C1D0F' ; 
EXECUTION_ID STATUS
-------------------------------- ----------
0F346975A10E4F2EE050A8C0030C19AD 5
0F3F4B937A3CC6B0E050A8C0030C1D3C 5
0F41D1A6B61C896AE050A8C0030C67C5 5
0F4C620A544C561FE050A8C0030C40C7 5
0F5AFE6C1916766FE050A8C0030C6C90 5

511 radku vybrano.

SQL> UPDATE mgmt_job_exec_summary SET status = 8,end_time = (sysdate - 1) WHERE job_id ='0DB38BB49E3AE3F7E050A8C0030C1D0F';
511 radku aktualizovano.

select EXECUTION_ID, status from MGMT_JOB_EXEC_SUMMARY where job_id ='0DB38BB49E3AE3F7E050A8C0030C1D0F' ;
EXECUTION_ID STATUS
-------------------------------- ----------
0F346975A10E4F2EE050A8C0030C19AD 8
0F3F4B937A3CC6B0E050A8C0030C1D3C 8
0F41D1A6B61C896AE050A8C0030C67C5 8
0F4C620A544C561FE050A8C0030C40C7 8
0F5AFE6C1916766FE050A8C0030C6C90 8

SQL> commit;
Potvrzeni dokonceno.

SQL> exec mgmt_job_engine.delete_job('0DB38BB49E3AE3F7E050A8C0030C1D0F');

Procedura PL/SQL uspesne dokoncena.

SQL> commit;

Potvrzeni dokonceno.

Komentáře