begin
variable job1;
begin
dbms_job.submit(:job1,'appdb.fl_static_main;',sysdate,'sysdate+1/24');
commit;
end;
end;
variable job1;
begin
dbms_job.submit(:job1,'appdb.fl_static_main;',sysdate,'sysdate+1/24');
commit;
end;
end;
variable job number;
begin
sys.dbms_job.submit(:job,
'begin 'appdb.fl_static_main;end;',
sysdate,
'sysdate+1/24');
commit;
end;
variable job1 number;
的错误,提示还是刚才那个呀,大哥们再帮小妹想想办法呀
job number; sys.dbms_job.submit(:job,
'begin 'appdb.fl_static_main;end;',
sysdate,
'sysdate+1/24');
commit;
begin
dbms_job.submit(:job1,'appdb.fl_static_main;',sysdate,'sysdate+1/24');
commit;
end;
/用SQLPLUS执行,再看看select * from sys.DBA_JOBS
declare
job1 number(10,2):= -1;
begin
sys.dbms_job.submit(job1,
'appdb.fl_static_main;',
sysdate,
'sysdate+1/24');
commit;
end;