I want to know if it's possible to manually insert (create) new jobs from an insert statement directly into the sys.job$ table. I was able to do the insert, and the process appears to run, but it doesn't do anything, it doesn't really run ... is there another table that needs to be populated when creating a new job manually like that? What all must I keep in mind when doing something like this?
Here's a sample of one I tried to do ...
INSERT into sys.job$
(job, lowner, powner, cowner, next_date, total, interval#, flag, what)
(226, 'SYSTEM', 'SYSTEM', 'SYSTEM', to_date('19-NOV-2001 10:30:00', 'DD-MON-YYYY HH:MI:SS'), 0, 'NULL', 0, 'project.psvwc_populate;')
Any assistance or documentation on this would be greatly appreciated.
I think is not a practical way to setup jobs using Direct Insert int sys$ table. In my opinion one should be using DBMS_JOB package. The user can be given execute privilege on the same.
I thought of using that ... I'm actually trying to create a job scheduling program on a web browser with Active Server Pages ... can I call a database package like that with an ASP SQL call? Anybody know?
Click Here to Expand Forum to Full Width