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
rajalakshmi
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: 64139
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

Regards
Michel
Previous Topic: Query giving tabelar representation
Next Topic: Doubt in the query regarding deletion of duplicate records from the table
Goto Forum:
  


Current Time: Thu Dec 08 08:36:23 CST 2016

Total time taken to generate the page: 0.18383 seconds