BEGIN
SYS.DBMS_SCHEDULER.CREATE_JOB
(
job_name => 'JOB_SP_INSERT_VEH_ALM_REC' --全部改成你自己的job名称
,start_date => TO_TIMESTAMP_TZ('2012/08/03 16:00:00.000000 +08:00','yyyy/mm/dd hh24:mi:ss.ff tzh:tzm')
,repeat_interval => 'FREQ=SECONDLY;INTERVAL=5'
,end_date => NULL
,job_class => 'DEFAULT_JOB_CLASS'
,job_type => 'PLSQL_BLOCK'
,job_action => 'sp_insert_veh_alm_rec;' --调用的这个存储过程名称后有个分号
,comments => NULL
);
SYS.DBMS_SCHEDULER.SET_ATTRIBUTE
( name => 'JOB_SP_INSERT_VEH_ALM_REC'
,attribute => 'RESTARTABLE'
,value => FALSE);
SYS.DBMS_SCHEDULER.SET_ATTRIBUTE
( name => 'JOB_SP_INSERT_VEH_ALM_REC'
,attribute => 'LOGGING_LEVEL'
,value => SYS.DBMS_SCHEDULER.LOGGING_OFF);
SYS.DBMS_SCHEDULER.SET_ATTRIBUTE_NULL
( name => 'JOB_SP_INSERT_VEH_ALM_REC'
,attribute => 'MAX_FAILURES');
SYS.DBMS_SCHEDULER.SET_ATTRIBUTE_NULL
( name => 'JOB_SP_INSERT_VEH_ALM_REC'
,attribute => 'MAX_RUNS');
BEGIN
SYS.DBMS_SCHEDULER.SET_ATTRIBUTE
( name => 'JOB_SP_INSERT_VEH_ALM_REC'
,attribute => 'STOP_ON_WINDOW_CLOSE'
,value => FALSE);
EXCEPTION
-- could fail if program is of type EXECUTABLE...
WHEN OTHERS THEN
NULL;
END;
SYS.DBMS_SCHEDULER.SET_ATTRIBUTE
( name => 'JOB_SP_INSERT_VEH_ALM_REC'
,attribute => 'JOB_PRIORITY'
,value => 3);
SYS.DBMS_SCHEDULER.SET_ATTRIBUTE_NULL
( name => 'JOB_SP_INSERT_VEH_ALM_REC'
,attribute => 'SCHEDULE_LIMIT');
SYS.DBMS_SCHEDULER.SET_ATTRIBUTE
( name => 'JOB_SP_INSERT_VEH_ALM_REC'
,attribute => 'AUTO_DROP'
,value => TRUE);
SYS.DBMS_SCHEDULER.ENABLE
(name => 'JOB_SP_INSERT_VEH_ALM_REC');
END;
/
--copy过去 用toad8.5以上的版本执行, pl/sql(7.1.4.1390)不支持!
分享到:
相关推荐
Oracle Scheduler用法,彻底放弃JOB
详细描述Oracle10 如何建立以及解析Job的
-- job 创建 begin dbms_scheduler.create_job ( job_name => 'AGENT_LIQUIDATION_JOB', job_type => 'STORED_PROCEDURE', job_action => 'AGENT_LIQUIDATION.LIQUIDATION', --存储过程名 start_date...
NULL 博文链接:https://wuaner.iteye.com/blog/717793
Scheduler job计划!Scheduler job计划!Scheduler job计划!Scheduler job计划!Scheduler job计划!Scheduler job计划!
If database administration with Oracle is part of your job, you’ll be glad to have Oracle 11g For Dummies in your cubicle. This nuts-and-bolts guide walks you through the mysteries of Oracle and ...
Oracle 在10g 版本以前,计划任务用的是DBMS_JOB 包,10g 版本引入DBMS_SCHEDULER 来替代先前的DBMS_JOB,在功能方面,它比DBMS_JOB 提供了更强大的功能和更灵活的机制 管理,但DBMS_JOB 包的使用相对比较简单,也基本...
亲,你是不是配置OBIEE的Ibot时老出错,邮件是不是老发不出去!没错,这篇文档将是你不错的选择!
JobScheduler运行可执行文件,脚本和数据库过程,并可以与MySQL,PostgreSQL,SQL Server,Oracle数据库一起使用。 JobScheduler提供顺序和并行任务执行,作业链,跨平台计划,事件,作业同步,负载共享,故障转移和...
Oracle系统包 一.dbms_output 二.dbms_job 三.dbms_pipe 四.dbms_alert 五.dbms_transaction 六.dbms_session 七.dbms_rowid 八.dbms_rls 九.dbms_ddl 十.dbms_shared_pool 十一.dbms_random 十二.dbms_logmnr 十三....
OEM and the Job Scheduler OEM and the Event Management System Chapter 14 Maintaining User Accounts Application Design Requirements Running the Application Documenting the User State A Sample ...
oracle定时任务.txt
Unix Job Scheduler 678 Source Control and Team Coding 693 Support for Version Control Products 693 Third Party File Based Source Control 694 Team Coding 697 Status in the Editor Status Bar or Team ...
2.2 创建资料库 10 ... 2.3.4 新建主键和外键 15 2.4 创建逻辑模型 17 2.4.1 创建逻辑层 17 2.4.2 查看逻辑层 18 2.4.3 修改逻辑层 18 2.5 创建展现模型 19 2.5.1 创建展现层 19 2.6 保存资料库 20 ... 2.7.2 重启...
2.2 创建资料库 10 2.2.1 资料库 10 2.3 创建物理模型 11 2.3.1 导入物理表 11 2.3.2 选择维度表和事实表 12 2.3.3 完成物理模型 14 2.3.4 新建主键和外键 15 2.4 创建逻辑模型 17 2.4.1 创建逻辑层 17 ...
Other features include Import/ Export Wizard, Query Builder, Report Builder, Data Synchronization, Backup, Job Scheduler and more. Features in Navicat are sophisticated enough to provide ...
Other features include Import/ Export Wizard, Query Builder, Report Builder, Data Synchronization, Backup, Job Scheduler and more. Features in Navicat are sophisticated enough to provide professional...
Other features include Import/ Export Wizard, Query Builder, Report Builder, Data Synchronization, Backup, Job Scheduler and more. Features in Navicat are sophisticated enough to provide professional...
64位版本的 PLSQL 正式版,只能运行在64位系统中,需要你安装 64 位的 Oracle11g 或 Oracle12c 客户端。 安装中文包时请注意安装路径是否为PLSQL程序的路径。 备注:新版本Ribbon启用了 Ribbon 界面,改动较大,不...
64位版本的 PLSQL 正式版,只能运行在64位系统中,需要你安装 64 位的 Oracle11g 或 Oracle12c 客户端。 安装中文包时请注意安装路径是否为PLSQL程序的路径。 备注:新版本Ribbon启用了 Ribbon 界面,改动较大,不...