PL/SQL Timer question - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

PL/SQL Timer question

PL/SQL Timer question# Database - 数据库

a*q2008-08-03 07:08

1 楼

Hi,
My query need to run on the weekend in my office. How could I set a timer in
the script during the weekday. It is not server. so I don't need to go to office on weekend. Thanks.

j*a2008-08-03 07:08

2 楼

Scheduled Task in Windows
Crontab in Unix.

I*e2008-08-03 07:08

3 楼

Oracle has schedule support inside the database.

j*a2008-08-03 07:08

4 楼

You can do it in OEM as JOBs.
However, the OEM has to be configured to connect to Management Server, not
the stand alone mode.

I*e2008-08-03 07:08

5 楼

Google it. This is one:
http://www.oracle-base.com/articles/10g/Scheduler10g.php

【在 a******q 的大作中提到】

: Hi,
: My query need to run on the weekend in my office. How could I set a timer in
: the script during the weekday. It is not server. so I don't need to go to office on weekend. Thanks.