作业提交时报错！

Question

variable v_jobnum number;
begin
 dbms_job.submit(:v_jobnum,
                 'auc.up_bcsdata_backup_test',
                 to_date('2004/04/21 02','yyyy/mm/dd hh24'),
                 'to_date('2004/04/21 02','yyyy/mm/dd hh24')+1');
end;

Answer 1

http://www.douzhe.com/jh/19/150556.htmlhttp://www.ccw.com.cn/htm/app/aprog/01_3_12_2.asp

Answer 2

variable v_jobnum number;
begin
 dbms_job.submit(:n'v_jobnum',
                 'auc.up_bcsdata_backup_test',
                 to_date('2004/04/21 02','yyyy/mm/dd hh24'),
                 'to_date('2004/04/21 02','yyyy/mm/dd hh24')+1');
end;