stupid dbms_job question
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 number; variable instno number; begin select instance_number into :instno from v$instance; dbms_job.submit(:jobno, 'statspack.snap;', trunc(sysdate+1/24,'HH'), 'trunc(SYSDATE+1/24,''HH'')', TRUE, :instno); commit; end; i then do: dbms_job.interval(:jobno,'trunc(sysdate+1/96)'; commit; my next_date column in dba_jobs is set to 15 minutes in the future, HOWEVER, it doesnt actually run. The time passes, the next_date does not get set again to nother 15 minutes in the future and the job doesnt run. Ive read the manual. Read metalink. read asktom and Im obvious too stupid to figure this one out. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: Re: stupid dbms_job question
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 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 is as follows... variable jobno number; variable instno number; begin select instance_number into :instno from v$instance; dbms_job.submit(:jobno, 'statspack.snap;', trunc(sysdate+1/24,'HH'), 'trunc(SYSDATE+1/24,''HH'')', TRUE, :instno); commit; end; i then do: dbms_job.interval(:jobno,'trunc(sysdate+1/96)'; commit; my next_date column in dba_jobs is set to 15 minutes in the future, HOWEVER, it doesnt actually run. The time passes, the next_date does not get set again to nother 15 minutes in the future and the job doesnt run. Ive read the manual. Read metalink. read asktom and Im obvious too stupid to figure this one out. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). 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 is as follows...variable jobno number;variable instno number;begin select instance_number into :instno from v$instance; dbms_job.submit(:jobno, 'statspack.snap;', trunc(sysdate+1/24,'HH'), 'trunc(SYSDATE+1/24,''HH'')', TRUE, :instno); commit;end;i then do:dbms_job.interval(:jobno,'trunc(sysdate+1/96)';commit;my next_date column in dba_jobs is set to 15 minutes in the future, HOWEVER, it doesnt actually run. The time passes, the next_date does not get set again to nother 15 minutes in the future and the job doesnt run.Ive read the manual. Read metalink. read asktom and Im obvious too stupid to figure this one out. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: stupid dbms_job question
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 number; variable instno number; begin select instance_number into :instno from v$instance; dbms_job.submit(:jobno, 'statspack.snap;', trunc(sysdate+1/24,'HH'), 'trunc(SYSDATE+1/24,''HH'')', TRUE, :instno); commit; end; i then do: dbms_job.interval(:jobno,'trunc(sysdate+1/96)'; commit; my next_date column in dba_jobs is set to 15 minutes in the future, HOWEVER, it doesnt actually run. The time passes, the next_date does not get set again to nother 15 minutes in the future and the job doesnt run. Ive read the manual. Read metalink. read asktom and Im obvious too stupid to figure this one out. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). Þessi póstur var sendur með vefpósti mi, http://www.mi.is -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gudmundur Josepsson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
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 dbms_job question 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 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 is as follows... variable jobno number; variable instno number; begin select instance_number into :instno from v$instance; dbms_job.submit(:jobno, 'statspack.snap;', trunc(sysdate+1/24,'HH'), 'trunc(SYSDATE+1/24,''HH'')', TRUE, :instno); commit; end; i then do: dbms_job.interval(:jobno,'trunc(sysdate+1/96)'; commit; my next_date column in dba_jobs is set to 15 minutes in the future, HOWEVER, it doesnt actually run. The time passes, the next_date does not get set again to nother 15 minutes in the future and the job doesnt run. Ive read the manual. Read metalink. read asktom and Im obvious too stupid to figure this one out. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gints Plivna INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: stupid dbms_job question
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] 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 is as follows... variable jobno number; variable instno number; begin select instance_number into :instno from v$instance; dbms_job.submit(:jobno, 'statspack.snap;', trunc(sysdate+1/24,'HH'), 'trunc(SYSDATE+1/24,''HH'')', TRUE, :instno); commit; end; i then do: dbms_job.interval(:jobno,'trunc(sysdate+1/96)'; commit; my next_date column in dba_jobs is set to 15 minutes in the future, HOWEVER, it doesnt actually run. The time passes, the next_date does not get set again to nother 15 minutes in the future and the job doesnt run. Ive read the manual. Read metalink. read asktom and Im obvious too stupid to figure this one out. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). Richard Quintin, DBA Information Systems Computing, DBMS Virginia Tech -- Magnificent promises are always to be suspected. -- Theodore Parker -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Quintin, Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Re: stupid dbms_job question
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 dbms_job question 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 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 is as follows... variable jobno number; variable instno number; begin select instance_number into :instno from v$instance; dbms_job.submit(:jobno, 'statspack.snap;', trunc(sysdate+1/24,'HH'), 'trunc(SYSDATE+1/24,''HH'')', TRUE, :instno); commit; end; i then do: dbms_job.interval(:jobno,'trunc(sysdate+1/96)'; commit; my next_date column in dba_jobs is set to 15 minutes in the future, HOWEVER, it doesnt actually run. The time passes, the next_date does not get set again to nother 15 minutes in the future and the job doesnt run. Ive read the manual. Read metalink. read asktom and Im obvious too stupid to figure this one out. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gints Plivna INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Re: stupid dbms_job question
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 this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: stupid dbms_job question
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 that runs every 5 minuts. Only way I can get the submit to work is as follows... variable jobno number; variable instno number; begin select instance_number into :instno from v$instance; dbms_job.submit(:jobno, 'statspack.snap;', trunc(sysdate+1/24,'HH'), 'trunc(SYSDATE+1/24,''HH'')', TRUE, :instno); commit; end; i then do: dbms_job.interval(:jobno,'trunc(sysdate+1/96)'; commit; my next_date column in dba_jobs is set to 15 minutes in the future, HOWEVER, it doesnt actually run. The time passes, the next_date does not get set again to nother 15 minutes in the future and the job doesnt run. Ive read the manual. Read metalink. read asktom and Im obvious too stupid to figure this one out. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Re: stupid dbms_job question
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 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 dbms_job question 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 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 is as follows... variable jobno number; variable instno number; begin select instance_number into :instno from v$instance; dbms_job.submit(:jobno, 'statspack.snap;', trunc(sysdate+1/24,'HH'), 'trunc(SYSDATE+1/24,''HH'')', TRUE, :instno); commit; end; i then do: dbms_job.interval(:jobno,'trunc(sysdate+1/96)'; commit; my next_date column in dba_jobs is set to 15 minutes in the future, HOWEVER, it doesnt actually run. The time passes, the next_date does not get set again to nother 15 minutes in the future and the job doesnt run. Ive read the manual. Read metalink. read asktom and Im obvious too stupid to figure this one out. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gints Plivna INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gints Plivna INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Re: stupid dbms_job question
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: 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 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 number; variable instno number; begin select instance_number into :instno from v$instance; dbms_job.submit(:jobno, 'statspack.snap;', trunc(sysdate+1/24,'HH'), 'trunc(SYSDATE+1/24,''HH'')', TRUE, :instno); commit; end; i then do: dbms_job.interval(:jobno,'trunc(sysdate+1/96)'; commit; my next_date column in dba_jobs is set to 15 minutes in the future, HOWEVER, it doesnt actually run. The time passes, the next_date does not get set again to nother 15 minutes in the future and the job doesnt run. Ive read the manual. Read metalink. read asktom and Im obvious too stupid to figure this one out. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Re: stupid dbms_job question
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 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. [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 is as follows... variable jobno number; variable instno number; begin select instance_number into :instno from v$instance; dbms_job.submit(:jobno, 'statspack.snap;', trunc(sysdate+1/24,'HH'), 'trunc(SYSDATE+1/24,''HH'')', TRUE, :instno); commit; end; i then do: dbms_job.interval(:jobno,'trunc(sysdate+1/96)'; commit; my next_date column in dba_jobs is set to 15 minutes in the future, HOWEVER, it doesnt actually run. The time passes, the next_date does not get set again to nother 15 minutes in the future and the job doesnt run. Ive read the manual. Read metalink. read asktom and Im obvious too stupid to figure this one out. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). --- This message and any included attachments are from Siemens Medical Solutions USA, Inc. and are intended only for the addressee(s). The information contained herein may include trade secrets or privileged or otherwise confidential information. Unauthorized review, forwarding, printing, copying, distributing, or using such information is strictly prohibited and may be unlawful. If you received this message in error, or have reason to believe you are not authorized to receive it, please promptly delete this message and notify the sender by e-mail with a copy to [EMAIL PROTECTED] Thank you -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Cortese Joseph INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Re: stupid dbms_job question
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 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 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 number; variable instno number; begin select instance_number into :instno from v$instance; dbms_job.submit(:jobno, 'statspack.snap;', trunc(sysdate+1/24,'HH'), 'trunc(SYSDATE+1/24,''HH'')', TRUE, :instno); commit; end; i then do: dbms_job.interval(:jobno,'trunc(sysdate+1/96)'; commit; my next_date column in dba_jobs is set to 15 minutes in the future, HOWEVER, it doesnt actually run. The time passes, the next_date does not get set again to nother 15 minutes in the future and the job doesnt run. Ive read the manual. Read metalink. read asktom and Im obvious too stupid to figure this one out. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). --- This message and any included attachments are from Siemens Medical Solutions USA, Inc. and are intended only for the addressee(s). The information contained herein may include trade secrets or privileged or otherwise confidential information. Unauthorized review, forwarding, printing, copying, distributing, or using such information is strictly prohibited and may be unlawful. If you received this message in error, or have reason to believe you are not authorized to receive it, please promptly delete this message and notify the sender by e-mail with a copy to [EMAIL PROTECTED] Thank you -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Cortese Joseph INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Re: stupid dbms_job question
Well, you didn't say what version of the database we were talking about. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Thursday, October 23, 2003 12:39 PM To: Multiple recipients of list ORACLE-L 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 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 dbms_job question 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 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 is as follows... variable jobno number; variable instno number; begin select instance_number into :instno from v$instance; dbms_job.submit(:jobno, 'statspack.snap;', trunc(sysdate+1/24,'HH'), 'trunc(SYSDATE+1/24,''HH'')', TRUE, :instno); commit; end; i then do: dbms_job.interval(:jobno,'trunc(sysdate+1/96)'; commit; my next_date column in dba_jobs is set to 15 minutes in the future, HOWEVER, it doesnt actually run. The time passes, the next_date does not get set again to nother 15 minutes in the future and the job doesnt run. Ive read the manual. Read metalink. read asktom and Im obvious too stupid to figure this one out. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gints Plivna INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gints Plivna INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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