Automating an Oracle script on Windows

[071]

Hello,

I have a cleanup script which I would like to run on a weekly basis.

Could anyone tell me how I could achieve this ?

Running Oracle 10 G on Windows 2003.

Thanks in advance.

Cheers,
71

 

[LKBrwnDBA]

Use the WinDoze () scheduler.


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[071]

Thanks but I don't want to include the oracle password in the batch file !

There must be a way of achieving this using DBMS scheduler ?

Cheers,
71

 

[LKBrwnDBA]

Depends what you want to "clean up".


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[071]

It's a purge script, why would it depend on what I want to purge ? Isn't it possible to log is as the user in question and get Oracle to call the purge script or would I have to create the script within Oracle itself.

Cheers,
71

 

[LKBrwnDBA]

You can use EM to schedule the job.


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb