Simple instances of jobs in Oracle

Oracle job is a function provided by oracle to regularly execute a stored procedure or package.

Main scenarios
Perform related operations on the background at regular intervals. For example, save the data of one table to another at every night, and 2. Back up the database at regular intervals.

I. Create a test table

1. SQL>Create table TEST (a date );

The table has been created.
Ii. Create a custom Process

1. SQL>Create or replace procedure MYPROC
2. 2 begin
3. 3 insert into TEST values (sysdate );
4. 4 end;
5. 5/
7. The process has been created.

3. Create a JOB

1. SQL>Variable job1 number;
2. SQL>
3. SQL>Begin
4. 2 dbms_job.submit (: job1, 'myproc; ', sysdate, 'sysdate + 100'); -- 1/1440 minutes a day, that is, one minute to run the test process
5. 3 end;
6. 4/
8. The PL/SQL process is successfully completed.

4. Run the JOB

1. SQL>Begin
2. 2 dbms_job.run (: job1 );
3. 3 end;
4. 4/
6. The PL/SQL process is successfully completed.

V. query a job

1. SQL>Select to_char (a, 'yyyy/mm/dd hh24: mi: ss') time from TEST;
3. Time
4. -------------------
5. 2001/01/07 23:51:21
6. 2001/01/07 23:52:22
7. 2001/01/07 23:53:24

Vi. delete a JOB

1. SQL>Begin
2. 2 dbms_job.remove (: job1 );
3. 3 end;
4. 4/bitsCN_com
6. The PL/SQL process is successfully completed.

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