Oracle Job

SQL*Plus: Release 11.1.0.7.0 - Production on Fri Jun 3 14:51:26 2011

Copyright (c) 1982, 2008, Oracle. All rights reserved.

Enter user-name: ***
Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> create table job_test(a date);

Table created.

SQL> create or replace procedure prc_job_test as
2 begin
3 insert into job_test values (sysdate);
4 end;
5 /

Procedure created.

SQL> variable testjob1 number;
SQL> begin
2 dbms_job.submit(:testjob1,'prc_job_test;',sysdate,'sysdate+1/1440');
3 commit;
4 end;
5 /

PL/SQL procedure successfully completed.

SQL> begin
2 dbms_job.run(:testjob1);
3 end;
4 /

PL/SQL procedure successfully completed.

SQL> begin
2 dbms_job.remove(:testjob1);
3 end;
4 /

PL/SQL procedure successfully completed.

SQL>drop procedure prc_job_test;

SQL>drop table job_test;