2014-06-30 00036CNY5433 6104 0.000 130676.080
2014-06-30 00350CNY5453 6107 500495181.380 0.000
2014-06-30 00350CNY5562 6107 0.000 50571245.930
2014-06-30 00350CNY7591 6124 69524032.280 0.000
2014-06-30 00036CNY9971 6104 4313539.170 0.000
2014-06-30 00036CNY6025 6121 105.860 0.000
2014-06-30 00350CNY5149 6118 0.000 108304.850
2014-06-30 00350CNY5605 6110 0.000 1790434.050
2014-06-30 00350CNY7274 6110 78709183.050 0.000
2014-06-30 00350CNY7272 6110 1000000.000 0.000
2014-06-30 00350CNY9322 6107 0.000 316363894.130
2014-06-30 00350CNY8804 6120 328682.870 0.000
2014-06-30 00350CNY0961 6116 330410.960 0.000
2014-06-30 00350CNY0845 6116 0.000 3041470.520
2014-06-30 00350CNY0745 6116 3041470.520 0.000
2014-06-30 00350CNY0975 6116 200000000.000 0.000
2014-06-30 00350CNY8578 6110 0.000 98844709.540
2014-06-30 00350CNY7492 6110 3501396.240 0.000
2014-06-30 00350CNY8635 6110 98844709.540 0.000
2014-06-30 00350EUR9875 6112 0.000 3000000.000
3.创建加载数据文件的EXCUTABLE类型job,执行并查看日志
-- 创建executable job
begin
dbms_scheduler.create_job(
job_name => 'LF_PERL',
job_type => 'EXECUTABLE',
job_action => '/ETL/loader/RWA_EDW_PLEDGE_IMPAWN_INFO.pl',
start_date => systimestamp,
number_of_arguments => 1,
-- job_class => 'no_logging_class',
auto_drop => true,
comments => 'LF_PERL');
end;
-- 传入参数
begin
dbms_scheduler.set_job_argument_value(job_name => 'LF_PERL',
argument_position =>1 ,
argument_value =>'etl_test' );
end;
-- 执行
begin
dbms_scheduler.run_job(job_name =>'LF_PERL');
end;
-- 删除job
begin
dbms_scheduler.drop_job(job_name => 'LF_PERL');
end;
-- 清除job日志
begin
dbms_scheduler.purge_log(job_name => 'LF_PERL');
end;
-- 查看JOB
select * from user_scheduler_jobs t
where job_name = 'LF_PERL'
;
-- 查看JOB执行情况
select * from user_scheduler_job_run_details t
where job_name = 'LF_PERL'
?