Home » SQL & PL/SQL » SQL & PL/SQL » no entry in dba_jobs_running
no entry in dba_jobs_running [message #236248] Wed, 09 May 2007 07:18 Go to next message
Messages: 5
Registered: May 2007
Junior Member
i removed : before jobno parameterin dbms_job.submit().Its working.Included in dba_jobs.But there is no entry in dba_jobs_running.I set the interval as 10 min.
I tried a job that inserts a record to table in every 10 secs using dbms_scheduler package.its working well.But no entry in dba_scheduler_running_jobs.
Re: no entry in dba_jobs_running [message #236252 is a reply to message #236248] Wed, 09 May 2007 07:25 Go to previous message
Michel Cadot
Messages: 65146
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Did you commit after dbms_job.submit?
2/ Job may run so fast that you can't see it in "running" views

Previous Topic: difference between two timestamps
Next Topic: how to give hint in view
Goto Forum:

Current Time: Mon Aug 21 07:16:42 CDT 2017

Total time taken to generate the page: 0.02104 seconds