RE: Re: stupid dbms_job question

2003-10-23 Thread Goulet, Dick
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

RE: Re: stupid dbms_job question

2003-10-23 Thread Cortese Joseph
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

RE: Re: stupid dbms_job question

2003-10-23 Thread Cortese Joseph
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

RE: Re: stupid dbms_job question

2003-10-23 Thread Khedr, Waleed
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: "

RE: Re: stupid dbms_job question

2003-10-23 Thread Gints Plivna
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

RE: Re: stupid dbms_job question

2003-10-23 Thread Jamadagni, Rajendra
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

RE: Re: stupid dbms_job question

2003-10-23 Thread rgaffuri
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 >

RE: Re: stupid dbms_job question

2003-10-23 Thread Gints Plivna
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

Re: Re: stupid dbms_job question

2003-10-23 Thread rgaffuri
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