Thanks for the question, Marcelo.
Asked: January 10, 2019 - 6:36 pm UTC
Last updated: January 11, 2019 - 6:13 am UTC
Version: 12
Viewed 1000+ times
You Asked
Hi Tom,
I am trying to develop a concurrent program manager (same Oracle EBS does). My Question is which options you recomend to do it and why? Advanced queue Library, pure PL/SQL, java, OS Level, OCI ???
Thanks in advance.
Best Regards,
Marcelo
and Connor said...
Depends on what your needs are.
If its mainly running database programs (eg PLSQL or programs existing on the db server) I probably wouldn't write anything, I'd just use the Scheduler (check out DBMS_SCHEDULER).
Extending that, you might be able to utilize the job architecture in Enterprise Manager if you want to schedule things on multiple monitored hosts.
If it's more sophisticated than that, then you're probably looking at writing some programs in [pick your favourite 3GL] and have them listen on queues via AQ
But be careful not re-invent the wheel here - if your needs are truly complex, then you'd probably be better off with a third party scheduling solution (eg Tidal etc)
Is this answer out of date? If it is, please let us know via a Comment