Google - oracle dbms_job
del.icio.us - dbms_job
26 Scheduler Concepts For Oracle 10g R2
93 DBMS_SCHEDULER
範例來源:Oracle: How to Schedule Job using DBMS_JOB package ? -- URGENT
variable jobno number;
begin
dbms_job.submit(
:jobno, 'proc1;',
trunc(sysdate)+15/24,
'trunc(SYSDATE+(1/24),''HH'')',
TRUE);
commit;
end;
/
print jobno
Oracle DBMS_JOB
Oracle dbms_job example - Burleson - 1
Oracle dbms_job example - Burleson - 2
Using the power of DBMS_JOB.SUBMIT - Natalka Roshak
Chapter 13 Job Scheduling in the Database - 13.2 Job Queue Architecture
Chapter 13 Job Scheduling in the Database - 13.4 DBMS_JOB Examples
DBMS_JOB,UTL_SMTP, DBMS_UTILITY.GET_TIME
沒有留言:
張貼留言