Can I create a job to run on-demand in the 10g Scheduler?
734426Feb 1 2011 — edited Feb 3 2011hi -- I have a job currently set to run every second. The job executes the sql statements that are written to a table -- if there are any there. There aren't records in the table often, but when there are they need to be processed immediately. It works great, but it seems like overkill to have the job "polling" the table every second.
Is there a way to somehow have the job execute on demand rather than on a schedule? I can't use a trigger on the table because triggering data needs to be committed before the sql statements are executed...
Thanks,
Carol