var job_num number;
begin
dbms_job.submit(:job_num,'pro_tixing(sysdate,sysdate+30);',SYSDATE,'TRUNC(SYSDATE + 1)');
end;
print job_num
--------------------------------------------------------------------------
begin
dbms_job.run(26);
end;
/
--------------------------------------------------------------------------
SELECT JOB, NEXT_DATE, NEXT_SEC, FAILURES, BROKEN FROM ALL_JOBS;
SELECT * FROM ALL_JOBS;
--------------------------------------------------------------------------
begin
dbms_job.remove(25);
end;
/
--------------------------------------------------------------------------