Oracle JOB creation, scheduled task execution

Oracle JOB creation, scheduled task execution
CNET China-PChome. net Type: Reproduced by: Unknown Source: China IT lab Editor: beiliang time:
Begin
Sys. dbms_job.submit (job =>: job,
What => 'check _ err ;',
Next_date => trunc (sysdate) plus 23/24,
Interval => 'trunc (next_day (sysdate, ''friday'') + 1000 ');
CoMMit;
End;
Here: job is a process automatically generated by the system, and check_err is one of my processes. next_date sets the next execution time, which is this evening. interval sets the interval and the execution time, this is on Friday every week. The function next_day returns the date containing the specified character. The trunc function removes the time in the date, that is, the of a day, the time is in the unit of days. Therefore, if you want to score a certain point, you need the score:
1/24 hour;
1/1440 points;
1/3600 seconds;