Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: DBMS_JOB does not run on NT - SOLVED !
No , it was not ;-)
Sorry , i knew it , but overlooked it ;-)
It's working now !
Thanks a lot to all who replied !
DBAndrey
-----Original Message-----
Sent: Sun, July 14, 2002 5:51 PM
To: Andrey Bronfin; LazyDBA.com Discussion
Is job_queue_processes set to greater than zero?
Mike
-----Original Message-----
Sent: Sunday, July 14, 2002 10:32 AM
To: LazyDBA.com Discussion
Dear gurus !
I submit a job via the DBMS_JOB package , it looks OK , select from
user_jobs shows that broken='N' .
When i execute the job manually , using dbms_job.run , it runs , but it does
not run automatically (each 5 minutes , as i have specified when submitting
the job).
Any guess ?
Thanks a lot !
DBAndrey
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: andreyb_at_elrontelesoft.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Sun Jul 14 2002 - 12:28:25 CDT