Tag: jobs

How to queue up calls to stored procedures in Oracle?

jobs locking oracle sql stored-procedures

I have a stored procedure in oracle (which schedules a one-time job to run another procedure, if this is relevant). The job calls another stored procedure which runs for a few minutes, and performs inserts updates and deletes and also uses loops. Now while the long procedure is running, if there is another call for it to run, is it

How to SELECT all JOBS that using a DBLINK on oracle?

dblink job-scheduling jobs oracle sql

Is my pleasure to say helo to all of you. I need help on oracle to select all JOBS that using a DBLINK on oracle, to stop them during maintenance. I will appreciate your help.