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;