OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » Scheduling Task

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Scheduling Task [message #73716]

Wed, 23 June 2004 22:50

Brayan
Messages: 315
Registered: June 2002

Senior Member

Hi,

I want to schedule a SQL/PLSQL script to run at midnight. If anybody has ideas please share with me.

we are using Enterprise Oracle 9i.

Thanking you in advance,
Ronald.

Report message to a moderator

Re: Scheduling Task [message #73721 is a reply to message #73716]

Thu, 24 June 2004 03:29

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

if the job is an oracle stored procedure,
use DBMS_JOB to schedule within oracle.
if the job is a script or anonymous pl/sql blocks / sql block, then
create a batch file and schedule it from your OS.
in windows creat a .bat file and use windows scheduler or use AT command

example: please have a look here

http://www.orafaq.com/scripts/win/sched.txt

in unix, craete a shell script and scedule in crontab.

Report message to a moderator