id prefer to handle this in the database.
From: Gene Sais [EMAIL PROTECTED]
Date: 2003/10/23 Thu AM 10:29:33 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: stupid dbms_job question
It's called cron :). Or you could run a shell script that executes
I had an issue with dmbs_job where the jobs would become broken if I altered them.
Have you checked if the job becomes broken after you change the interval?
Gudmundur
im trying to submit a job that runs every 5 minuts. Only way I can get the
submit to work is as follows...
variable jobno
Just a shot in the dark
Have you set initialization parameters in the init file?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 23, 2003 6:14 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Re: stupid dbms_job question
id
An interval of
trunc(sysdate)+(trunc(to_char(sysdate,'s')/900)+1)*5/24/60
ought to give you every 5 minutes. Courtesy of Tom...
On Thu, 2003-10-23 at 10:29, Gene Sais wrote:
It's called cron :). Or you could run a shell script that executes
then sleeps for 5 mins.
[EMAIL PROTECTED]
what initialization parameters? job_queue_processes is fine.
From: Gints Plivna [EMAIL PROTECTED]
Date: 2003/10/23 Thu AM 11:49:32 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Re: stupid dbms_job question
Just a shot in the dark
Have you set
Ryan,
remove the trunc() from sysdate+1/96 trunc is removing your time part. or you
should be using ROUND(SYSDATE+1/96,'MI') instead.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in
What is JOB_QUEUE_INTERVAL set to? If it's more than 5 minutes then what your seeing
is what you get.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Thursday, October 23, 2003 10:09 AM
To: Multiple recipients of list ORACLE-L
im trying to submit a job
JOB_QUEUE_INTERVAL I think
But I found that it is obsolete in Release 9.0.1
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 23, 2003 7:15 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Re: stupid dbms_job question
what
: Gene Sais [EMAIL PROTECTED]
Date: 2003/10/23 Thu AM 10:29:33 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: stupid dbms_job question
It's called cron :). Or you could run a shell script that executes then
sleeps for 5 mins.
[EMAIL PROTECTED] 10/23/03 10:09AM
to handle this in the database.
From: Gene Sais [EMAIL PROTECTED]
Date: 2003/10/23 Thu AM 10:29:33 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: stupid dbms_job question
It's called cron :). Or you could run a shell script that executes then
sleeps for 5 mins
ORACLE-L [EMAIL PROTECTED]
Subject: Re: stupid dbms_job question
It's called cron :). Or you could run a shell script that executes then
sleeps for 5 mins.
[EMAIL PROTECTED] 10/23/03 10:09AM
im trying to submit a job that runs every 5 minuts. Only way I can get
the submit to work
that it is obsolete in Release 9.0.1
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 23, 2003 7:15 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Re: stupid dbms_job question
what initialization parameters? job_queue_processes is fine.
From
12 matches
Mail list logo