Oracle Job Drafts

Sa

--declaring a jobDECLAREjob2014_12_16 Number;BEGINDbms_job. SUBMIT (Job2014_12_16,--This parameter is out type                  'syncv5;', To_date (To_char (sysdate+1,'MM/DD') ,'MM/DD'),                 'TRUNC (Last_day (sysdate) + 1)');--' sysdate + 1/(60*24*60) '); --' sysdate+1/1440 '  COMMIT; Dbms_output. Put_Line (JOB2014_12_16); --outputs the value of the JOB2014_12_16 variable that is assignedEND;/--View the job ID you just createdSelect *  fromSys.user_jobs--Run JobbeginDbms_job.run ( A); Commit; End; /--Stop JobbeginDbms_job.broken ( A, TRUE); Commit; End; /--Delete JobDECLAREBEGINDbms_job.remove ( the); COMMIT;End;/DECLAREJOB22 Number;BEGINSYS. Dbms_job. SUBMIT (JOB22,'proc5;',--job to perform (example of a stored procedure to execute)Sysdate,'TRUNC (sysdate+1)');--cycle of Job execution (daily 0 o'clock in the morning)Dbms_output. Put_Line (job22);END;/'sysdate + 30/(60*24*60)'SELECT COUNT(*) fromweb_monitor_table;

Oracle Job Drafts