Create Oracle Database Job Service: Plsqldev Operation Job

Plsqldev operation Job Create JOB1, select the Job folder, right-  2, click New   3, corresponding fill complete, you can click "View SQL" to view the SQL statement, OK, click "Apply" is created 4, at this time , the job folder corresponding job creation completed, directly visible job number, right-click can be related operation    know the reason why--Knowledge Understanding job Parameters: is the Binary_ineger returned by the submit () process. Work number that uniquely identifies a job. What parameter: is the PL/SQL code block that will be executed.  next_date parameter: Indicates when the job will run.  interval parameter: The frequency at which the work will be re-executed.  no_parse parameter: Indicates whether this work should be parsed at the time of submission or execution--true indicates that this PL/SQL code should parse when it first executes, and false indicates that this PL/SQL code should be parsed immediately.   Describes the interval parameter value, defines how often the job executes (some to be verified) 12 o'clock Midnight: ' TRUNC (sysdate + 1) ' 8:30 A.M. daily: ' TRUNC (sysdate + 1) + (8*60+30)/(24*60) ' Every Tuesday noon 12 o'clock: ' Next_day (TRUNC (sysdate), ' Tuesday ') + 12/24 ' on the first day of the Month 12 o'clock Midnight: ' TRUNC (Last_day (sysdate) + 1) ' The last day of the quarter 11 o'clock: ' TRUNC (add_months (sysdate + 2/24, 3), ' Q ') -1/24 ' every Saturday and Sunday 6:10 A.M.: ' TRUNC (LEAST (Next_day (sysdate, ' SATURDAY '), Next_day ( Sysdate, "SUNDAY"))) + (6X60+10)/(24x60) ' per minute execution: ' TRUNC (sysdate, ' mi ') + 1/(24*60) ' or ' sysdate+1/1440 ' daily 1 o'clock in the morning execution: ' TRUNC ( Sysdate) + 1 +1/(24) ' Timed execution Weekly: Every Monday 1 o'clock in the morning: ' TRUNC (Next_day (sysdate, ' Monday ')) +1/24 ' Monthly scheduled execution: 1st 1 o'clock in the morning per month: ' TRUNC (Last_day ( sysdate)) +1+1/24 'Quarterly scheduled execution: the first day of the Quarter 1 o'clock in the morning execution: ' TRUNC (Add_months (sysdate,3), ' Q ') + 1/24 ' per half-yearly scheduled execution: July 1 and January 1 1 o'clock in the morning: ' Add_months (TRUNC (sysdate , ' yyyy '), 6) +1/24 ' scheduled execution every year: January 1 1 o'clock in the morning every year: ' Add_months (trunc (sysdate, ' yyyy '), +1/24 '  

Create Oracle Database Job Service: Plsqldev Operation Job