| Scheduling Jobs with Java [message #91908] |
Mon, 04 August 2003 06:18 |
Dirk Bielemeier
Messages: 1
Registered: August 2003
|
Junior Member |
|
|
Hello together!
How is it possible to start a new job with a java stored procedure? We have a table called JOB_DEFINITIONS, that includes a column named SQL_STATEMENT. At a specific time a job daemon should start a JOB. To do so, it should read the JOB_DEFINITION-entry and start the SQL_STATEMENT, that could be something like 'BEGIN TEST_PACKAGE.START_JOB; END;'.
I don't want to use DBMS_JOB to start the routine, more likely i would prefer to handle the new job from a stored java routine. Has anyone experience here?
Greetings
Dirk
Duesseldorf / Germany
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
