如何获取一个job的ddl,有个需要要查看job的语句,使用get_ddl语句不行,找了很久把这个贴出来。
SQL> create table ttime (t1 timestamp);
Table created.
SQL> exec dbms_job.submit(:v_job,what=>'begin insert into ttime values(systimestamp); end;',next_date=>SYSDATE,INTERVAL=>'sysdate+1/86400');
SQL> select job from dba_jobs;
JOB
----------
1
set serveroutput on ;
declare
job_body varchar2(32767);
begin
dbms_job.user_export(1,job_body);
dbms_output.put_line(job_body);
end;
/
dbms_job.isubmit(job=>1,what=>'begin insert into ttime values(systimestamp); end;',next_date=>to_date('2012-12-03:08:03:52','YYYY-MM-DD:HH24:MI:SS'),interval=>'sysdate+1/86400',no_parse=>TRUE);