今天用PL/SQL Developer写了一个简单的作业调度:
1.,鼠标右键点击 jobs 弹出 Create Job 对话框。
2.,在对话框中输入相应的值,其中
What——作业执行时将要调用的存储过程,如
begin PROC_STAT_MA_ORDERGOODS(to_char(sysdate,'yyyymmddhh24')); commit; end;
Next date——下一次作业执行时间;
Interval——作业执行时间间隔,这个参数涉及到Next date的值,Next date是按照Interval计算出来的。
3,Interval几种常用的写法——
每分钟执行:Interval => sysdate+1/1440;
每小时执行:Interval => sysdate+1/24;
每天定时执行:Interval => sysdate+1;
每周定时执行:Interval => sysdate+7;
相关推荐
On the "View" ribbon you can now choose between a Single Document Interface (SDI) or Multiple Document Interface (MDI - the same as in PL/SQL Developer 11.0 and earlier). In SDI mode you always see ...
The Oracle Advanced PL/SQL Developer Professional Guide helps you to master the advanced PL/SQL concepts in Oracle 11g. The book aims to be a sure selection for the Associate level Oracle ...
plsql创建存储过程并创建job定时任务执行-详细笔记文档总结
<br> 前言 第1章 PL/SQL综述 1.1 SQL简介 1.2 PL/SQL简介 1.3 Oracle 10g PL/SQL新特征 第2章 PL/SQL开发工具 2.1 SQL*Plus 2.2 PL/SQL Developer 2.3 Procedure ...
On the "View" ribbon you can now choose between a Single Document Interface (SDI) or Multiple Document Interface (MDI - the same as in PL/SQL Developer 11.0 and earlier). In SDI mode you always see ...
On the "View" ribbon you can now choose between a Single Document Interface (SDI) or Multiple Document Interface (MDI - the same as in PL/SQL Developer 11.0 and earlier). In SDI mode you always see ...
On the "View" ribbon you can now choose between a Single Document Interface (SDI) or Multiple Document Interface (MDI - the same as in PL/SQL Developer 11.0 and earlier). In SDI mode you always see ...
When using date/time selector in the SQL result grid, PL/SQL Developer would lose focus The file format encoding preference "Always as UTF8" did not work for the Program Window Crash recovery saved ...
1. 打开SQLDeveloper,建立system链接、bs+学号连接登录ORCL数据库。 2. 在SQLDeveloper中,用密码tiger解锁scott账号。 3. 触发器注意事项 (1)触发器可以声明为在对记录进行操作之前,在之前(检查约束之前和 ...
Application,development,sql*plus,worksheet,,4)pl/sql,developer,属于第三方软件,主要用于开发,测试,优化oracle,pl/sql,的 存储过程.如:触发器,此软件oracle不带,需要单独安装。,5)oracle的企业管理器(oem,...
Sql Developer Oracle Enterprise Manager 第二章 用户和权限 一、 用户介绍 ORACLE用户是学习ORACLE数据库中的基础知识,下面就介绍下类系统常用的默认ORACLE用户: 1. sys用户:超级用户,完全是个...
), interpreted (然后 PL/SQL 模块将被编译为 PL/SQL 字节代码格式), debug (PL/SQL 模块将用探测调试符号来编译), non_debug。 默认值: " interpreted, non_debug " plsql_native_linker: 说明: 此参数指定链接...