Top "Dbms-job" questions

How to stop Oracle dbms_job

My dbms_job has been running for nearly thirty days. The number of total time keeps rising, but I can't …

database oracle dbms-job

Script to disable all jobs in Oracle (DBMS_JOB package)?

I'm looking for a script which disables all the jobs. Right now I highlight them all in Toad, click the …

oracle plsql oracle10g dbms-job

View the DBMS jobs log oracle

I have a scheduled a job in DBMS jobs (not DBMS scheduler). I can see the job has failed in …

oracle dbms-job

Creating a Job in Oracle using DBMS_JOB

I'm trying to create a job that will run a certain procedure every Christmas. This is how far I have …

sql oracle dbms-job

DBMS_JOB vs DBMS_SCHEDULER

What is the difference between DBMS_JOB and DBMS_SCHEDULER ?

oracle scheduler job-scheduling dbms-scheduler dbms-job

Altering JOB_QUEUE_PROCESSES

Does altering the JOB_QUEUE_PROCESSES to 0 on an Oracle DB block the Oracle jobs from being scheduled too? I …

database oracle dbms-scheduler dbms-job

Trying to make a job to be executed after each 1 minute,but its not working?

I have made this job,that should be executed in an interval of 1 minute,but it's not working. When I …

oracle plsql oracle9i dbms-job

Oracle-DBMS jobs scheduler change the start time

I have a DBMS_jobs which is scheduled to run a procedure FINDING_PROCEDURE at 6 am evey day. Can anyone …

oracle dbms-job

Oracle: how do I take a Job offline from PL/SQL?

I need to look for a JOB by thw WHAT column. Check if it is actually running. If not take …

oracle jobs dbms-job