如何在oracle 10g中安排程序/包/查询? [英] how to schedule procedure/package/query in oracle 10g?
问题描述
i有一个要求,比如我必须安排一个在高峰时段以外运行的程序。
任何人都可以帮助我如何在Oracle10g中自动完成工作。
实际上我研究过dbms_scheduler但是我不理解它。
假设我有这样的表格
crate table t1(id number,name varchar2(10))
插入t1值(101,''testjob'')
现在给我一个例子,就像每天早上12点我必须运行我的插入脚本,即如何自动化它。
Hi,
i got one requirement like i have to schedule one procedure which is running in other than peak hours.
can any body help me how to automate the job in Oracle10g.
actually i studied about dbms_scheduler but it is not understood by me.
assume i have the table like
crate table t1(id number,name varchar2(10))
insert into t1 values(101,''testjob'')
now give me one example like every day 12AM i have to run my insert script i.e how can i automate it.
推荐答案
你需要创建一个JOB,这将执行你想要的任何东西。
这里有几个链接:
Docs Oracle(带示例) [ ^ ]
另一个步骤 [ ^ ]
和最后一个,但更好:
在Oracle企业管理器网格控制中创建作业10g第2版(带有EM的屏幕)
You need to create a JOB, this will execute whatever you want.
here is a few links:
Docs Oracle (with example)[^]
Another step-by-step[^]
and the last, but better:
Creating Jobs in Oracle Enterprise Manager Grid Control 10g Release 2 (With Screens of EM.)
这篇关于如何在oracle 10g中安排程序/包/查询?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!