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? j
Are you heading out to lunch
-Original Message-
Sent: Thursday, October 23, 2003 11:14 AM
To: Multiple recipients of list ORACLE-L
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 li
I am so sorry, I replied to the wrong email.
-Original Message-
Sent: Thursday, October 23, 2003 12:46 PM
To: '[EMAIL PROTECTED]'
Are you heading out to lunch
-Original Message-
Sent: Thursday, October 23, 2003 11:14 AM
To: Multiple recipients of list ORACLE-L
id prefer to ha
Check if the job fails for some reason, any trace files for j??? in udump or
bdump
Also check job_queue_processes setting
Waleed
-Original Message-
Sent: Thursday, October 23, 2003 11:14 AM
To: Multiple recipients of list ORACLE-L
id prefer to handle this in the database.
>
> From: "
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 que
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 thi
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 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 db
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 execute