rajeshkapure
October 1st, 2005, 11:25 AM
Hi All,
I have tried with Oracle9i to schedule jobs which will automatically run whenever the database is being loaded. i have use tode.
I have created 1 job using TODE.
I have also seen that in the dba_jobs view the jobs are queued. Though
But I also found that in view dba_jobs_running no jobs are running. That leads me to think that they are not running at all.
And, again I have also modified my init.ora file to set
JOB_QUEUE_PROCESSES =30
JOB_QUEUE_INTERVAL =60
Still then I am getting no difference.
Please give me a broad idea how these job scheduling are to done in Oracle.
Regards
Rajesh kapure
I have tried with Oracle9i to schedule jobs which will automatically run whenever the database is being loaded. i have use tode.
I have created 1 job using TODE.
I have also seen that in the dba_jobs view the jobs are queued. Though
But I also found that in view dba_jobs_running no jobs are running. That leads me to think that they are not running at all.
And, again I have also modified my init.ora file to set
JOB_QUEUE_PROCESSES =30
JOB_QUEUE_INTERVAL =60
Still then I am getting no difference.
Please give me a broad idea how these job scheduling are to done in Oracle.
Regards
Rajesh kapure