0 积分	0 好友	4 主题

[升级] 如何获取一个job的DDL 语句

1^#

发表于 2012-12-3 16:06:01 | 查看: 6442| 回复: 3

现有一个job ，如何才能获取创建这个JOB 的DDL 语句

2^#

发表于 2012-12-3 16:10:19

FYI

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);