| Oracle Scheduler Query [message #124728] |
Tue, 21 June 2005 02:51  |
sreek_s
Messages: 45
Registered: May 2005
Location: Andaman Nikobar
|
Member |
|
|
Hi ,
I have a java program in which i have a main() method. I want to invoke the main() method every night at 12 using oracle scheduler. I am using oracle 10g.
How to configure the scheduler to invoke a java method?
Any samples , links are welcome.
Regds,
Srikanth
|
|
|
|
| Re: Oracle Scheduler Query [message #124743 is a reply to message #124728] |
Tue, 21 June 2005 03:47  |
Frank Naude
Messages: 4581
Registered: April 1998
|
Senior Member |
|
|
Read chapter "Using the Scheduler" in the Database Administrator's Guide.
Here is an untested example to get you started:
BEGIN
DBMS_SCHEDULER.CREATE_JOB (
job_name => 'my_java_job',
job_type => 'EXECUTABLE',
job_action => '/usr/bin/java /path/to/myClass',
repeat_interval => 'FREQ=DAILY;BYHOUR=23',
enabled => TRUE
);
END;
/
Best regards.
Frank
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
