CREATE OR REPLACE PROCEDURE spQcJob
AS
v_jobname NUMBER;
v_date DATE;
v_Count int;
BEGIN
select count(*) into v_Count from dba_jobs where what='spOprScoreDaily;';
IF v_Count>0 THEN
select job into v_jobname from dba_jobs where what='spOprScoreDaily;';
sys.DBMS_JOB.REMOVE(v_jobname);
END IF;
v_date := TRUNC(SYSDATE+1,'DD')+6/24;
sys.DBMS_JOB.SUBMIT(v_jobname,'spOprScoreDaily;',v_date,'TRUNC(SYSDATE+1,''DD'')+6/24');
COMMIT;
END spQcJob;
/
EXECUTE spQcJob;
/
DECLARE
v_Job NUMBER;
BEGIN
DBMS_JOB.SUBMIT(v_Job, 'p_maintendata;', TRUNC(SYSDATE), 'SYSDATE + 1');
COMMIT;
END;
/