DECLARE
V_JOBID NUMBER;
BEGIN
DBMS_JOB.SUBMIT(V_JOBID,
'p_114_2014114_code();',
to_date('09-01-2014 00:00:00', 'dd-mm-yyyy hh24:mi:ss'),
'SYSDATE+5/(24*60*60)');
DECLARE
v_JobID PLS_INTEGER;
BEGIN
SAVEPOINT SPT_SAVEPOINT;
V_JOBID NUMBER;
BEGIN
DBMS_JOB.SUBMIT(V_JOBID,
'p_114_2014114_code();',
to_date('09-01-2014 00:00:00', 'dd-mm-yyyy hh24:mi:ss'),
'SYSDATE+5/(24*60*60)');
COMMIT;
END;
END;
=========================================================================
DECLARE
v_JobID PLS_INTEGER;
BEGIN
SAVEPOINT SPT_SAVEPOINT;
BEGIN
SELECT JOB
INTO v_JobID
FROM USER_JOBS
WHERE UPPER(WHAT) = 'p_c_pics_trs_getmobileno;'
AND ROWNUM = 1;
EXCEPTION
WHEN NO_DATA_FOUND THEN
v_JobID := 0;
END;
SELECT JOB
INTO v_JobID
FROM USER_JOBS
WHERE UPPER(WHAT) = 'p_c_pics_trs_getmobileno;'
AND ROWNUM = 1;
EXCEPTION
WHEN NO_DATA_FOUND THEN
v_JobID := 0;
END;
IF v_JobID = 0 THEN
DBMS_JOB.SUBMIT(v_JobID, 'p_c_pics_trs_getmobileno;', TRUNC(SYSDATE + 1, 'DD') + 1/24,
'TRUNC(SYSDATE + 1, ''DD'') + 3/24', FALSE,0);
ELSE
DBMS_JOB.CHANGE(v_JobID, 'p_c_pics_trs_getmobileno;', TRUNC(SYSDATE + 1, 'DD') + 1/24,
'TRUNC(SYSDATE + 1, ''DD'') + 3/24',0);
END IF;
DBMS_JOB.SUBMIT(v_JobID, 'p_c_pics_trs_getmobileno;', TRUNC(SYSDATE + 1, 'DD') + 1/24,
'TRUNC(SYSDATE + 1, ''DD'') + 3/24', FALSE,0);
ELSE
DBMS_JOB.CHANGE(v_JobID, 'p_c_pics_trs_getmobileno;', TRUNC(SYSDATE + 1, 'DD') + 1/24,
'TRUNC(SYSDATE + 1, ''DD'') + 3/24',0);
END IF;
DBMS_JOB.BROKEN(v_JobID, FALSE);
COMMIT;
EXCEPTION
WHEN OTHERS THEN
ROLLBACK TO SAVEPOINT SPT_SAVEPOINT;
RETURN;
END;
EXCEPTION
WHEN OTHERS THEN
ROLLBACK TO SAVEPOINT SPT_SAVEPOINT;
RETURN;
END;