Oracle job learning

Oracle job

Execute the following script in plsql to create a job that is executed at every night.

Begin

Sys. dbms_job.submit (job =>: job, -- job ID

What => 'dbms _ output. pub_line (''asdf ''); ', -- execute the script

Next_date => to_date ('17-01-2011 16:17:31 ', 'dd-mm-yyyy hh24: mi: ss'), -- next execution time

Interval => 'trunc (sysdate) + 100'); -- execution interval

Commit;

End;

The following example shows the possible values of the interval parameter:

A. Run the command every 5 minutes.

Interval => 'trunc (sysdate, 'mi ') + 5/24/60'

B. Run the command once every hour.

Interval => 'trunc (sysdate, 'hh') + 100'

C. Execution in one hour

Interval => 'sysdate + 123'

For more information about Oracle, see Oracle topics page http://www.bkjia.com/topicnews.aspx? Tid = 12