oracle10g数据库jobs的问题
SQL> begin
2 dbms_scheduler.create_job
3 (
4 job_name => 'Merge_Data',
5 job_type => 'PLSQL_BLOCK',
6 job_action => 'begin MergeData(to_number(to_char(sysdate-1,''YYYYMMDD'')),&&DBTYPE); end;',
7 repeat_interval => 'FREQ=DAILY;BYHOUR=3;byminute=0',
8 enabled => true
9 );
10 end;
11 /begin
dbms_scheduler.create_job
(
job_name => 'Merge_Data',
job_type => 'PLSQL_BLOCK',
job_action => 'begin MergeData(to_number(to_char(sysdate-1,''YYYYMMDD'')),); end;',
repeat_interval => 'FREQ=DAILY;BYHOUR=3;byminute=0',
enabled => true
);
end;ORA-27477: "FENGHUO.MERGE_DATA" already exists
ORA-06512: at "SYS.DBMS_ISCHED", line 99
ORA-06512: at "SYS.DBMS_SCHEDULER", line 262
ORA-06512: at line 3
SQL> exitSQL> select count(*) from user_jobs; COUNT(*)
----------
0SQL> select count(*) from all_jobs; COUNT(*)
----------
0
数据库中有这个定时任务,但是为什么查询不到呢,但是我用PL/SQL Developer软件就可以看到这个定时任务。
SQL> begin
2 dbms_scheduler.create_job
3 (
4 job_name => 'Merge_Data',
5 job_type => 'PLSQL_BLOCK',
6 job_action => 'begin MergeData(to_number(to_char(sysdate-1,''YYYYMMDD'')),&&DBTYPE); end;',
7 repeat_interval => 'FREQ=DAILY;BYHOUR=3;byminute=0',
8 enabled => true
9 );
10 end;
11 /begin
dbms_scheduler.create_job
(
job_name => 'Merge_Data',
job_type => 'PLSQL_BLOCK',
job_action => 'begin MergeData(to_number(to_char(sysdate-1,''YYYYMMDD'')),); end;',
repeat_interval => 'FREQ=DAILY;BYHOUR=3;byminute=0',
enabled => true
);
end;ORA-27477: "FENGHUO.MERGE_DATA" already exists
ORA-06512: at "SYS.DBMS_ISCHED", line 99
ORA-06512: at "SYS.DBMS_SCHEDULER", line 262
ORA-06512: at line 3
SQL> exitSQL> select count(*) from user_jobs; COUNT(*)
----------
0SQL> select count(*) from all_jobs; COUNT(*)
----------
0
数据库中有这个定时任务,但是为什么查询不到呢,但是我用PL/SQL Developer软件就可以看到这个定时任务。
创建之后要commit