Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!nx01.iad01.newshosting.com!newshosting.com!post01.iad01!not-for-mail From: NetComrade Newsgroups: comp.databases.oracle.server Subject: Re: Restart DBMS_JOBS Date: Thu, 02 Feb 2006 14:45:34 -0500 Message-ID: References: X-Newsreader: Forte Free Agent 1.93/32.576 English (American) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Organization: Acecape, Inc. Cache-Post-Path: nntp.acecape.com!unknown@p78-65.acedsl.com X-Cache: nntpcache 3.0.1 (see http://www.nntpcache.org/) Lines: 19 X-Complaints-To: abuse@newshosting.com Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:260600 On Thu, 2 Feb 2006 09:06:11 +0100, "Ben de Boer" wrote: >Hi everybody, >We run an Oracle database Version 8.1.7.2.0 on a unix machine. >For some jobs to run we use DBMS_JOBS.SUBMIT ... >Now sometimes, special for short running programs, it will be started a >second time, >after finishing without errors. >Does anybody has some same problems and solved it. You're saying that sometimes a submittied job runs twice? That can happen only if you submittied it twice, or it failed the first time.. You'll need to 'trace' the job ids, and trace the program from within itself (e.g. via some log table). ....... We run Oracle 9.2.0.6 on RH4 AMD remove NSPAM to email