Re: Cronjob
[EMAIL PROTECTED] wrote: > Anyone whom can tell me how to delete a job that is created by crontab. > > Thanks in advance > > > Roland > > man crontab -- -- Bill "Shrek" Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. Your e-mail has been returned due to insufficient voltage. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cronjob
crontab -e On Wed, 24 Apr 2002, bill thater wrote: > [EMAIL PROTECTED] wrote: > > > Anyone whom can tell me how to delete a job that is created by crontab. > > > > Thanks in advance > > > > > > Roland > > > > > > man crontab > > > -- > -- > Bill "Shrek" Thater ORACLE DBA > [EMAIL PROTECTED] > > You gotta program like you don't need the money, > You gotta compile like you'll never get hurt, > You gotta run like there's nobody watching, > It's gotta come from the heart if you want it to work. > > Your e-mail has been returned due to insufficient voltage. > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: bill thater > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cronjob
"man kill" Scott Shafer San Antonio, TX 210-581-6217 > -Original Message- > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, April 24, 2002 9:29 AM > To: Multiple recipients of list ORACLE-L > Subject: Cronjob > > Anyone whom can tell me how to delete a job that is created by crontab. > > Thanks in advance > > > Roland > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cronjob
crontab -r ... [EMAIL PROTECTED] pms.osd.mil Para:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Enviado por: cc: (cco: Ivan Llamoca/NOVASALUD) [EMAIL PROTECTED] Asunto: RE: Cronjob 24/04/2002 21:19 Por favor, responda a ORACLE-L "man kill" Scott Shafer San Antonio, TX 210-581-6217 > -Original Message- > From:[EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > Sent:Wednesday, April 24, 2002 9:29 AM > To:Multiple recipients of list ORACLE-L > Subject: Cronjob > > Anyone whom can tell me how to delete a job that is created by crontab. > > Thanks in advance > > > Roland > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Ivan Llamoca INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cronjob
crontab -e is bad! 1000 points if you can figure out why. ( guess I'm watching too much 'Whose Line Is It Anyway?" ) Jared Alex <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 04/24/2002 10:07 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Re: Cronjob crontab -e On Wed, 24 Apr 2002, bill thater wrote: > [EMAIL PROTECTED] wrote: > > > Anyone whom can tell me how to delete a job that is created by crontab. > > > > Thanks in advance > > > > > > Roland > > > > > > man crontab > > > -- > -- > Bill "Shrek" Thater ORACLE DBA > [EMAIL PROTECTED] > > You gotta program like you don't need the money, > You gotta compile like you'll never get hurt, > You gotta run like there's nobody watching, > It's gotta come from the heart if you want it to work. > > Your e-mail has been returned due to insufficient voltage. > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: bill thater > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cronjob
Title: RE: Cronjob A wrong keystroke could blow away the entire crontab file by accident. %:| -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 24, 2002 5:19 PM To: Multiple recipients of list ORACLE-L Subject: Re: Cronjob crontab -e is bad! 1000 points if you can figure out why. ( guess I'm watching too much 'Whose Line Is It Anyway?" ) Jared Alex <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 04/24/2002 10:07 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: Re: Cronjob crontab -e On Wed, 24 Apr 2002, bill thater wrote: > [EMAIL PROTECTED] wrote: > > > Anyone whom can tell me how to delete a job that is created by crontab. > > > > Thanks in advance > > > > > > Roland > > > > > > man crontab > > > -- > -- > Bill "Shrek" Thater ORACLE DBA > [EMAIL PROTECTED] > > You gotta program like you don't need the money, > You gotta compile like you'll never get hurt, > You gotta run like there's nobody watching, > It's gotta come from the heart if you want it to work. > > Your e-mail has been returned due to insufficient voltage. > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: bill thater > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > > 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.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists 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: Cronjob
So you wipe out a few jobs in the crontab. Big deal! It just means your sysadmin has to stay up late explaining my backups and payroll didn't run. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Wednesday, April 24, 2002 5:19 PM To: Multiple recipients of list ORACLE-L Subject: Re: Cronjob crontab -e is bad! 1000 points if you can figure out why. ( guess I'm watching too much 'Whose Line Is It Anyway?" ) Jared Alex <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 04/24/2002 10:07 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Re: Cronjob crontab -e On Wed, 24 Apr 2002, bill thater wrote: > [EMAIL PROTECTED] wrote: > > > Anyone whom can tell me how to delete a job that is created by crontab. > > > > Thanks in advance > > > > > > Roland > > > > > > man crontab > > > -- > -- > Bill "Shrek" Thater ORACLE DBA > [EMAIL PROTECTED] > > You gotta program like you don't need the money, > You gotta compile like you'll never get hurt, > You gotta run like there's nobody watching, > It's gotta come from the heart if you want it to work. > > Your e-mail has been returned due to insufficient voltage. > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: bill thater > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cronjob
You'll lose your entire crontab if you do a crontab -e when /var is full? (I've had this happen to me on HP-UX...) Marc Cure Oracle DBA, OCP 8i -Original Message- [EMAIL PROTECTED] Sent: Wednesday, April 24, 2002 5:19 PM To: Multiple recipients of list ORACLE-L crontab -e is bad! 1000 points if you can figure out why. ( guess I'm watching too much 'Whose Line Is It Anyway?" ) Jared Alex <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 04/24/2002 10:07 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Re: Cronjob crontab -e On Wed, 24 Apr 2002, bill thater wrote: > [EMAIL PROTECTED] wrote: > > > Anyone whom can tell me how to delete a job that is created by crontab. > > > > Thanks in advance > > > > > > Roland > > > > > > man crontab > > > -- > -- > Bill "Shrek" Thater ORACLE DBA > [EMAIL PROTECTED] > > You gotta program like you don't need the money, > You gotta compile like you'll never get hurt, > You gotta run like there's nobody watching, > It's gotta come from the heart if you want it to work. > > Your e-mail has been returned due to insufficient voltage. > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: bill thater > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Marc Cure INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cronjob
-e Edit the current crontab using the editor specified by the VISUAL or EDITOR environment variables. The specified editor must edit the file in place; any editor that unlinks the file and recreates it cannot be used. After you exit from the editor, the modified crontab will be installed automatically. He wants to delete the job. If he kills the process the job will run again next time so editing the crontab file is th eonly way. On Wed, 24 Apr 2002 [EMAIL PROTECTED] wrote: > crontab -e is bad! > > 1000 points if you can figure out why. > ( guess I'm watching too much 'Whose Line Is It Anyway?" ) > > Jared > > > > > > Alex <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 04/24/2002 10:07 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > Subject:Re: Cronjob > > > crontab -e > > On Wed, 24 Apr 2002, bill thater wrote: > > > [EMAIL PROTECTED] wrote: > > > > > Anyone whom can tell me how to delete a job that is created by > crontab. > > > > > > Thanks in advance > > > > > > > > > Roland > > > > > > > > > > man crontab > > > > > > -- > > -- > > Bill "Shrek" Thater ORACLE DBA > > [EMAIL PROTECTED] > > > > You gotta program like you don't need the money, > > You gotta compile like you'll never get hurt, > > You gotta run like there's nobody watching, > > It's gotta come from the heart if you want it to work. > > > > Your e-mail has been returned due to insufficient voltage. > > > > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: bill thater > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > 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.com > -- > Author: Alex > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cronjob
If you crontab -e and a job is scheduled to run during the time that you are editing, then the job doesn't execute while you are editing. No jobs will execute while you're in crontab -e. Even if you :w your changes. No cronjobs will execute while the editor is open so don't forget to close that editor when you finish. I learned this from experience (HP-UX) Final Answer! Just guessing though. Is that what you're lookin fer? -Original Message- Sent: Wednesday, April 24, 2002 5:19 PM To: Multiple recipients of list ORACLE-L crontab -e is bad! 1000 points if you can figure out why. ( guess I'm watching too much 'Whose Line Is It Anyway?" ) Jared Alex <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 04/24/2002 10:07 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Re: Cronjob crontab -e On Wed, 24 Apr 2002, bill thater wrote: > [EMAIL PROTECTED] wrote: > > > Anyone whom can tell me how to delete a job that is created by crontab. > > > > Thanks in advance > > > > > > Roland > > > > > > man crontab > > > -- > -- > Bill "Shrek" Thater ORACLE DBA > [EMAIL PROTECTED] > > You gotta program like you don't need the money, > You gotta compile like you'll never get hurt, > You gotta run like there's nobody watching, > It's gotta come from the heart if you want it to work. > > Your e-mail has been returned due to insufficient voltage. > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: bill thater > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). * * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552 (b) (4) and relevant judicial opinions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cronjob
Jared, You owe me 1000 points. And I know someone who did a crontab -r (so far from 'e' and yet so close!); lots of fun after that deletion. I always usecrontab -l > crontab.mmdd Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED] -Original Message- Sent: Wednesday, April 24, 2002 5:19 PM To: Multiple recipients of list ORACLE-L crontab -e is bad! 1000 points if you can figure out why. ( guess I'm watching too much 'Whose Line Is It Anyway?" ) Jared Alex <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 04/24/2002 10:07 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Re: Cronjob crontab -e On Wed, 24 Apr 2002, bill thater wrote: > [EMAIL PROTECTED] wrote: > > > Anyone whom can tell me how to delete a job that is created by crontab. > > > > Thanks in advance > > > > > > Roland > > > > > > man crontab > > > -- > -- > Bill "Shrek" Thater ORACLE DBA > [EMAIL PROTECTED] > > You gotta program like you don't need the money, > You gotta compile like you'll never get hurt, > You gotta run like there's nobody watching, > It's gotta come from the heart if you want it to work. > > Your e-mail has been returned due to insufficient voltage. > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: bill thater > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Sherman, Paul R. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cronjob
> -e Edit the current crontab using the editor specified by the >VISUAL or EDITOR environment variables. The specified editor must >edit the file in place; any editor that unlinks the file and >recreates it cannot be used. After you exit from the editor, the >modified crontab will be installed automatically. >He wants to delete the job. If he kills the process the job will run again >next time so editing the crontab file is th eonly way. >On Wed, 24 Apr 2002 [EMAIL PROTECTED] wrote: >> crontab -e is bad! >> Jared There is more than one way to edit a crontab. crontab -e is not a good one. Write the crontab to a file(crontab -l > cronfile), edit it, and reload it (crontab cronfile). Nuke the site from orbit...It's the only way to be sure Steve McClure -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve McClure INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cronjob
Come on, Jared, its more fun to: crontab < /dev/null Scott Shafer San Antonio, TX 210-581-6217 > -Original Message- > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, April 24, 2002 4:19 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Cronjob > > crontab -e is bad! > > 1000 points if you can figure out why. > ( guess I'm watching too much 'Whose Line Is It Anyway?" ) > > Jared > > > > > > Alex <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 04/24/2002 10:07 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject:Re: Cronjob > > > crontab -e > > On Wed, 24 Apr 2002, bill thater wrote: > > > [EMAIL PROTECTED] wrote: > > > > > Anyone whom can tell me how to delete a job that is created by > crontab. > > > > > > Thanks in advance > > > > > > > > > Roland > > > > > > > > > > man crontab > > > > > > -- > > -- > > Bill "Shrek" Thater ORACLE DBA > > [EMAIL PROTECTED] > > > > You gotta program like you don't need the money, > > You gotta compile like you'll never get hurt, > > You gotta run like there's nobody watching, > > It's gotta come from the heart if you want it to work. > > > > Your e-mail has been returned due to insufficient voltage. > > > > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: bill thater > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > 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.com > -- > Author: Alex > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cronjob
Let's see, I do recall that changes made with crontab -e aren't always applied (think this was Solaris 2.5). [EMAIL PROTECTED] wrote: > > crontab -e is bad! > > 1000 points if you can figure out why. > ( guess I'm watching too much 'Whose Line Is It Anyway?" ) > > Jared > > Alex <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 04/24/2002 10:07 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > Subject:Re: Cronjob > > crontab -e > > On Wed, 24 Apr 2002, bill thater wrote: > > > [EMAIL PROTECTED] wrote: > > > > > Anyone whom can tell me how to delete a job that is created by > crontab. > > > > > > Thanks in advance > > > > > > > > > Roland > > > > > > > > > > man crontab > > > > > > -- > > -- > > Bill "Shrek" Thater ORACLE DBA > > [EMAIL PROTECTED] > > > > You gotta program like you don't need the money, > > You gotta compile like you'll never get hurt, > > You gotta run like there's nobody watching, > > It's gotta come from the heart if you want it to work. > > > > Your e-mail has been returned due to insufficient voltage. > > > > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: bill thater > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > 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.com > -- > Author: Alex > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: Suzy Vordos INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cronjob
been there done that. crontab -l > /tmp/c.c vi /tmp/c.c crontab /tmp/c.c joe Marc Cure wrote: >You'll lose your entire crontab if you do a crontab -e when /var is full? > >(I've had this happen to me on HP-UX...) > >Marc Cure >Oracle DBA, OCP 8i > > >-Original Message- >[EMAIL PROTECTED] >Sent: Wednesday, April 24, 2002 5:19 PM >To: Multiple recipients of list ORACLE-L > > >crontab -e is bad! > >1000 points if you can figure out why. >( guess I'm watching too much 'Whose Line Is It Anyway?" ) > >Jared > > > > > >Alex <[EMAIL PROTECTED]> >Sent by: [EMAIL PROTECTED] >04/24/2002 10:07 AM >Please respond to ORACLE-L > > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >cc: >Subject:Re: Cronjob > > >crontab -e > >On Wed, 24 Apr 2002, bill thater wrote: > >>[EMAIL PROTECTED] wrote: >> >>>Anyone whom can tell me how to delete a job that is created by >>> >crontab. > >>>Thanks in advance >>> >>> >>>Roland >>> >>> >>man crontab >> >> >>-- >>-- >>Bill "Shrek" Thater ORACLE DBA >> [EMAIL PROTECTED] >> >>You gotta program like you don't need the money, >>You gotta compile like you'll never get hurt, >>You gotta run like there's nobody watching, >>It's gotta come from the heart if you want it to work. >> >>Your e-mail has been returned due to insufficient voltage. >> >> >> >> >>-- >>Please see the official ORACLE-L FAQ: http://www.orafaq.com >>-- >>Author: bill thater >> INET: [EMAIL PROTECTED] >> >>Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >>San Diego, California-- Public Internet access / Mailing Lists >> >>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.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cronjob
SORRY crontab -e "Ivan Llamoca" lud.com.pe> cc: (cco: Ivan Llamoca/NOVASALUD) Enviado por: Asunto: RE: Cronjob [EMAIL PROTECTED] 24/04/2002 22:33 Por favor, responda a ORACLE-L crontab -r ... [EMAIL PROTECTED] pms.osd.mil Para:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Enviado por: cc: (cco: Ivan Llamoca/NOVASALUD) [EMAIL PROTECTED] Asunto: RE: Cronjob 24/04/2002 21:19 Por favor, responda a ORACLE-L "man kill" Scott Shafer San Antonio, TX 210-581-6217 > -Original Message- > From:[EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > Sent:Wednesday, April 24, 2002 9:29 AM > To:Multiple recipients of list ORACLE-L > Subject: Cronjob > > Anyone whom can tell me how to delete a job that is created by crontab. > > Thanks in advance > > > Roland > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Ivan Llamoca INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Ivan Llamoca INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 Sa
Re: Cronjob
hm, I wonder if someone will do a "top 20 Unix mistakes" presentation :) --- Joe Testa <[EMAIL PROTECTED]> wrote: > been there done that. > > > crontab -l > /tmp/c.c > vi /tmp/c.c > > crontab /tmp/c.c > > joe > > > Marc Cure wrote: > > >You'll lose your entire crontab if you do a crontab -e when /var is > full? > > > >(I've had this happen to me on HP-UX...) > > > >Marc Cure > >Oracle DBA, OCP 8i > > > > > >-Original Message- > >[EMAIL PROTECTED] > >Sent: Wednesday, April 24, 2002 5:19 PM > >To: Multiple recipients of list ORACLE-L > > > > > >crontab -e is bad! > > > >1000 points if you can figure out why. > >( guess I'm watching too much 'Whose Line Is It Anyway?" ) > > > >Jared > > > > > > > > > > > >Alex <[EMAIL PROTECTED]> > >Sent by: [EMAIL PROTECTED] > >04/24/2002 10:07 AM > >Please respond to ORACLE-L > > > > > >To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > >cc: > >Subject:Re: Cronjob > > > > > >crontab -e > > > >On Wed, 24 Apr 2002, bill thater wrote: > > > >>[EMAIL PROTECTED] wrote: > >> > >>>Anyone whom can tell me how to delete a job that is created by > >>> > >crontab. > > > >>>Thanks in advance > >>> > >>> > >>>Roland > >>> > >>> > >>man crontab > >> > >> > >>-- > >>-- > >>Bill "Shrek" Thater ORACLE DBA > >> [EMAIL PROTECTED] > >> > >>You gotta program like you don't need the money, > >>You gotta compile like you'll never get hurt, > >>You gotta run like there's nobody watching, > >>It's gotta come from the heart if you want it to work. > >> > >>Your e-mail has been returned due to insufficient voltage. > >> > >> > >> > >> > >>-- > >>Please see the official ORACLE-L FAQ: http://www.orafaq.com > >>-- > >>Author: bill thater > >> INET: [EMAIL PROTECTED] > >> > >>Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > >>San Diego, California-- Public Internet access / Mailing > Lists > >> > >>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.com > -- > Author: Joe Testa > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > 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). __ Do You Yahoo!? Yahoo! Games - play chess, backgammon, pool and more http://games.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cronjob
Rachel, I will be doing some of that on the 'big boat' next week ;) but from the DBA's viewpoint. Sounds like a good idea for the next IOUGA (or UKOUG, or both)... :) Thanks. - Kirti -Original Message- Sent: Wednesday, April 24, 2002 9:18 PM To: Multiple recipients of list ORACLE-L hm, I wonder if someone will do a "top 20 Unix mistakes" presentation :) --- Joe Testa <[EMAIL PROTECTED]> wrote: > been there done that. > > > crontab -l > /tmp/c.c > vi /tmp/c.c > > crontab /tmp/c.c > > joe > > > Marc Cure wrote: > > >You'll lose your entire crontab if you do a crontab -e when /var is > full? > > > >(I've had this happen to me on HP-UX...) > > > >Marc Cure > >Oracle DBA, OCP 8i > > > > > >-Original Message- > >[EMAIL PROTECTED] > >Sent: Wednesday, April 24, 2002 5:19 PM > >To: Multiple recipients of list ORACLE-L > > > > > >crontab -e is bad! > > > >1000 points if you can figure out why. > >( guess I'm watching too much 'Whose Line Is It Anyway?" ) > > > >Jared > > > > > > > > > > > >Alex <[EMAIL PROTECTED]> > >Sent by: [EMAIL PROTECTED] > >04/24/2002 10:07 AM > >Please respond to ORACLE-L > > > > > >To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > >cc: > >Subject:Re: Cronjob > > > > > >crontab -e > > > >On Wed, 24 Apr 2002, bill thater wrote: > > > >>[EMAIL PROTECTED] wrote: > >> > >>>Anyone whom can tell me how to delete a job that is created by > >>> > >crontab. > > > >>>Thanks in advance > >>> > >>> > >>>Roland > >>> > >>> > >>man crontab > >> > >> > >>-- > >>-- > >>Bill "Shrek" Thater ORACLE DBA > >> [EMAIL PROTECTED] > >> > >>You gotta program like you don't need the money, > >>You gotta compile like you'll never get hurt, > >>You gotta run like there's nobody watching, > >>It's gotta come from the heart if you want it to work. > >> > >>Your e-mail has been returned due to insufficient voltage. > >> > >> > >> > >> > >>-- > >>Please see the official ORACLE-L FAQ: http://www.orafaq.com > >>-- > >>Author: bill thater > >> INET: [EMAIL PROTECTED] > >> > >>Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > >>San Diego, California-- Public Internet access / Mailing > Lists > >> > >>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.com > -- > Author: Joe Testa > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > 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). __ Do You Yahoo!? Yahoo! Games - play chess, backgammon, pool and more http://games.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cronjob
That's what the SA's are for. Restore please. They should have never let /var get full:-) -Original Message- Sent: Wednesday, April 24, 2002 3:09 PM To: Multiple recipients of list ORACLE-L You'll lose your entire crontab if you do a crontab -e when /var is full? (I've had this happen to me on HP-UX...) Marc Cure Oracle DBA, OCP 8i -Original Message- [EMAIL PROTECTED] Sent: Wednesday, April 24, 2002 5:19 PM To: Multiple recipients of list ORACLE-L crontab -e is bad! 1000 points if you can figure out why. ( guess I'm watching too much 'Whose Line Is It Anyway?" ) Jared Alex <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 04/24/2002 10:07 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Re: Cronjob crontab -e On Wed, 24 Apr 2002, bill thater wrote: > [EMAIL PROTECTED] wrote: > > > Anyone whom can tell me how to delete a job that is created by crontab. > > > > Thanks in advance > > > > > > Roland > > > > > > man crontab > > > -- > -- > Bill "Shrek" Thater ORACLE DBA > [EMAIL PROTECTED] > > You gotta program like you don't need the money, > You gotta compile like you'll never get hurt, > You gotta run like there's nobody watching, > It's gotta come from the heart if you want it to work. > > Your e-mail has been returned due to insufficient voltage. > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: bill thater > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Marc Cure INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cronjob
Yeah, logged in as root from someone else's workstation, and no one is watching. Jared On Wednesday 24 April 2002 15:08, [EMAIL PROTECTED] wrote: > Come on, Jared, its more fun to: > > crontab < /dev/null > > Scott Shafer > San Antonio, TX > 210-581-6217 > > > -Original Message- > > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > > Sent: Wednesday, April 24, 2002 4:19 PM > > To: Multiple recipients of list ORACLE-L > > Subject:Re: Cronjob > > > > crontab -e is bad! > > > > 1000 points if you can figure out why. > > ( guess I'm watching too much 'Whose Line Is It Anyway?" ) > > > > Jared > > > > > > > > > > > > Alex <[EMAIL PROTECTED]> > > Sent by: [EMAIL PROTECTED] > > 04/24/2002 10:07 AM > > Please respond to ORACLE-L > > > > > > To: Multiple recipients of list ORACLE-L > > <[EMAIL PROTECTED]> > > cc: > > Subject:Re: Cronjob > > > > > > crontab -e > > > > On Wed, 24 Apr 2002, bill thater wrote: > > > [EMAIL PROTECTED] wrote: > > > > Anyone whom can tell me how to delete a job that is created by > > > > crontab. > > > > > > Thanks in advance > > > > > > > > > > > > Roland > > > > > > man crontab > > > > > > > > > -- > > > -- > > > Bill "Shrek" Thater ORACLE DBA > > > [EMAIL PROTECTED] > > > --- > > >- You gotta program like you don't need the money, > > > You gotta compile like you'll never get hurt, > > > You gotta run like there's nobody watching, > > > It's gotta come from the heart if you want it to work. > > > --- > > >- Your e-mail has been returned due to insufficient voltage. > > > > > > > > > > > > > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: bill thater > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > > San Diego, California-- Public Internet access / Mailing Lists > > > > > > 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.com > > -- > > Author: Alex > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > 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.com > > -- > > Author: > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > 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.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cronjob
Well, no, it isn't. I didn't realize that particular peculiarity of -e. The problem with crontab -e is that it's too easy to remove jobs accidentally, with no record of it. Myself, I use: co -l crontab.txt crontab -l > test.txt diff crontab.txt test.txt # proceed if there are no differences vi crontab.txt crontab crontab.txt ci -u crontab.txt # only if previous command was successful Jared On Wednesday 24 April 2002 15:23, Sherman, Edward wrote: > If you crontab -e and a job is scheduled to run during the time that you > are editing, then the job doesn't execute while you are editing. No jobs > will execute while you're in crontab -e. Even if you :w your changes. No > cronjobs will execute while the editor is open so don't forget to close > that editor when you finish. > > I learned this from experience (HP-UX) > > Final Answer! > > Just guessing though. > Is that what you're lookin fer? > > -Original Message- > Sent: Wednesday, April 24, 2002 5:19 PM > To: Multiple recipients of list ORACLE-L > > > crontab -e is bad! > > 1000 points if you can figure out why. > ( guess I'm watching too much 'Whose Line Is It Anyway?" ) > > Jared > > > > > > Alex <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 04/24/2002 10:07 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > Subject:Re: Cronjob > > > crontab -e > > On Wed, 24 Apr 2002, bill thater wrote: > > [EMAIL PROTECTED] wrote: > > > Anyone whom can tell me how to delete a job that is created by > > crontab. > > > > Thanks in advance > > > > > > > > > Roland > > > > man crontab > > > > > > -- > > -- > > Bill "Shrek" Thater ORACLE DBA > > [EMAIL PROTECTED] > > > > You gotta program like you don't need the money, > > You gotta compile like you'll never get hurt, > > You gotta run like there's nobody watching, > > It's gotta come from the heart if you want it to work. > > > > Your e-mail has been returned due to insufficient voltage. > > > > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: bill thater > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > 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.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cronjob
This is not the only way. See my next post on this. Jared On Wednesday 24 April 2002 15:08, Alex wrote: > -e Edit the current crontab using the editor specified by the > VISUAL or EDITOR environment variables. The specified editor must > edit the file in place; any editor that unlinks the file and > recreates it cannot be used. After you exit from the editor, the > modified crontab will be installed automatically. > > He wants to delete the job. If he kills the process the job will run again > next time so editing the crontab file is th eonly way. > > On Wed, 24 Apr 2002 [EMAIL PROTECTED] wrote: > > crontab -e is bad! > > > > 1000 points if you can figure out why. > > ( guess I'm watching too much 'Whose Line Is It Anyway?" ) > > > > Jared > > > > > > > > > > > > Alex <[EMAIL PROTECTED]> > > Sent by: [EMAIL PROTECTED] > > 04/24/2002 10:07 AM > > Please respond to ORACLE-L > > > > > > To: Multiple recipients of list ORACLE-L > > <[EMAIL PROTECTED]> cc: > > Subject:Re: Cronjob > > > > > > crontab -e > > > > On Wed, 24 Apr 2002, bill thater wrote: > > > [EMAIL PROTECTED] wrote: > > > > Anyone whom can tell me how to delete a job that is created by > > > > crontab. > > > > > > Thanks in advance > > > > > > > > > > > > Roland > > > > > > man crontab > > > > > > > > > -- > > > -- > > > Bill "Shrek" Thater ORACLE DBA > > > [EMAIL PROTECTED] > > > --- > > >- You gotta program like you don't need the money, > > > You gotta compile like you'll never get hurt, > > > You gotta run like there's nobody watching, > > > It's gotta come from the heart if you want it to work. > > > --- > > >- Your e-mail has been returned due to insufficient voltage. > > > > > > > > > > > > > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: bill thater > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > > San Diego, California-- Public Internet access / Mailing Lists > > > > > > 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.com > > -- > > Author: Alex > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > 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.com > > -- > > Author: > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > 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.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cronjob
0 06 * * 6 d31/appl/konto/bat/laddabilbo.sh >/d31/appl/konto/log/laddabilbo.log 2>&1 Samir Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 25 April 2002 12:43 To: Multiple recipients of list ORACLE-L Hallo, I would like to have this cronjob run only in saturday mornings at 6 am. How could I easy change this script? 0 18 * * * /d31/appl/konto/bat/laddabilbo.sh >/d31/appl/konto/log/laddabilbo.log 2>&1 Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cronjob
0 6 * * 6 /d31/app . Look at man for crontab (on my linux it's man 5 crontab); The time and date fields are: field allowed values - -- minute 0-59 hour 0-23 day of month 0-31 month 0-12 (or names, see below) day of week0-7 (0 or 7 is Sun, or use names) A field may be an asterisk (*), which always stands for ``first-last''. *** JP On Thu 25. April 2002 13:43, you wrote: > Hallo, > > I would like to have this cronjob run only in saturday mornings at 6 am. > How could I easy change this script? > > 0 18 * * * /d31/appl/konto/bat/laddabilbo.sh > >/d31/appl/konto/log/laddabilbo.log 2>&1 > > Thanks in advance > > Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cronjob
man cron man crontab you really need to do some research on your questions before posting --- [EMAIL PROTECTED] wrote: > Hallo, > > I would like to have this cronjob run only in saturday mornings at 6 > am. How could I easy change this script? > > 0 18 * * * /d31/appl/konto/bat/laddabilbo.sh > >/d31/appl/konto/log/laddabilbo.log > 2>&1 > > Thanks in advance > > Roland > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > 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). __ Do You Yahoo!? Yahoo! Games - play chess, backgammon, pool and more http://games.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cronjob
Use vi. -Original Message- Sent: 25 April 2002 12:43 To: Multiple recipients of list ORACLE-L Hallo, I would like to have this cronjob run only in saturday mornings at 6 am. How could I easy change this script? 0 18 * * * /d31/appl/konto/bat/laddabilbo.sh >/d31/appl/konto/log/laddabilbo.log 2>&1 Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cronjob
0 6 * * 6 /d31/appl/konto/bat/laddabilbo.sh >/d31/appl/konto/log/laddabilbo.log 2>&1 __ www.cichomitiko.cjb.net __ - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, April 25, 2002 1:43 PM > Hallo, > > I would like to have this cronjob run only in saturday mornings at 6 am. How could I easy change this script? > > 0 18 * * * /d31/appl/konto/bat/laddabilbo.sh >/d31/appl/konto/log/laddabilbo.log > 2>&1 > > Thanks in advance > > Roland > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: cichomitiko INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cronjob
Roland, Use the following command from the unix prompt: man crontab It'll tell you everything you need to know about changing the times of jobs scheduled via cron. If you look it up and figure it out yourself, you'll never need to ask about it again. However, if you just cut and paste someone's response with the answer in it, you'll have to keep coming back here to ask every time you want to reschedule a job. Cherie Machler Oracle DBA Gelco Information Network Roland.Skoldbl [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: Cronjob om 04/25/02 06:43 AM Please respond to ORACLE-L Hallo, I would like to have this cronjob run only in saturday mornings at 6 am. How could I easy change this script? 0 18 * * * /d31/appl/konto/bat/laddabilbo.sh >/d31/appl/konto/log/laddabilbo.log 2>&1 Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cronjob
Roland, The crontab fields are defined as: 1 2 3 4 5 "program to execite" 1 = minutes after the hour 0-59 2 = hours of the day 0-23 3 = days of the month 1-31 4 = months of the year 1-12 5 = days of the week 0-6 0=Sunday * = all possible values 0 6 * * 6 job to be run is placed here. States that the job will run at 0 minutes after the hour of 6 on day 6 ,all days of the month, all months of the year. If you want to run the job only once use the "at" command. Ron ROR mª¿ªm >>> [EMAIL PROTECTED] 04/25/02 07:43AM >>> Hallo, I would like to have this cronjob run only in saturday mornings at 6 am. How could I easy change this script? 0 18 * * * /d31/appl/konto/bat/laddabilbo.sh >/d31/appl/konto/log/laddabilbo.log 2>&1 Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cronjob
I have the same problem but with our vax/vms machine.. could I submit a job queue on every week or maybe every month... $Submi/Noprin/Notif/Que=Parm_Deplan/log=[diga.digu]dige.log - _$/After = "tomorrow+06:00" - _$sys$geology:[diga.digu]dige.com I usually submit que every day.. but I want to submit every week and month or every saturday. Could I do it on our vax machine? regards, Ahmadsyah Alghozi Nugroho Certified Oracle DBA - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, April 25, 2002 7:38 PM > 0 06 * * 6 d31/appl/konto/bat/laddabilbo.sh > >/d31/appl/konto/log/laddabilbo.log 2>&1 > > Samir > > Samir Sarkar > Oracle DBA > SchlumbergerSema > Email : [EMAIL PROTECTED] > [EMAIL PROTECTED] > Phone : +44 (0) 115 - 957 6028 > EPABX : +44 (0) 115 - 957 6418 Ext. 76028 > Fax : +44 (0) 115 - 957 6018 > > > -Original Message- > Sent: 25 April 2002 12:43 > To: Multiple recipients of list ORACLE-L > > > Hallo, > > I would like to have this cronjob run only in saturday mornings at 6 am. How > could I easy change this script? > > 0 18 * * * /d31/appl/konto/bat/laddabilbo.sh > >/d31/appl/konto/log/laddabilbo.log > 2>&1 > > Thanks in advance > > Roland > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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 email is confidential and intended solely for the use of the > individual to whom it is addressed. Any views or opinions presented are > solely those of the author and do not necessarily represent those of > SchlumbergerSema. > If you are not the intended recipient, be advised that you have received this > email in error and that any use, dissemination, forwarding, printing, or > copying of this email is strictly prohibited. > > If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. > ___ > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: SARKAR, Samir > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cronjob
I wrote a DCL script called crontab that re-submits itself every day. In the script, it checks what day it is and submits those jobs. A lot easier than running multiple submit jobs. I need to change something, I goto the crontab, just like Unix. Gene PS. Each OS has its advantages, still looking on Wintel. >>> [EMAIL PROTECTED] 04/25/02 10:33AM >>> I have the same problem but with our vax/vms machine.. could I submit a job queue on every week or maybe every month... $Submi/Noprin/Notif/Que=Parm_Deplan/log=[diga.digu]dige.log - _$/After = "tomorrow+06:00" - _$sys$geology:[diga.digu]dige.com I usually submit que every day.. but I want to submit every week and month or every saturday. Could I do it on our vax machine? regards, Ahmadsyah Alghozi Nugroho Certified Oracle DBA - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, April 25, 2002 7:38 PM > 0 06 * * 6 d31/appl/konto/bat/laddabilbo.sh > >/d31/appl/konto/log/laddabilbo.log 2>&1 > > Samir > > Samir Sarkar > Oracle DBA > SchlumbergerSema > Email : [EMAIL PROTECTED] > [EMAIL PROTECTED] > Phone : +44 (0) 115 - 957 6028 > EPABX : +44 (0) 115 - 957 6418 Ext. 76028 > Fax : +44 (0) 115 - 957 6018 > > > -Original Message- > Sent: 25 April 2002 12:43 > To: Multiple recipients of list ORACLE-L > > > Hallo, > > I would like to have this cronjob run only in saturday mornings at 6 am. How > could I easy change this script? > > 0 18 * * * /d31/appl/konto/bat/laddabilbo.sh > >/d31/appl/konto/log/laddabilbo.log > 2>&1 > > Thanks in advance > > Roland > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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 email is confidential and intended solely for the use of the > individual to whom it is addressed. Any views or opinions presented are > solely those of the author and do not necessarily represent those of > SchlumbergerSema. > If you are not the intended recipient, be advised that you have received this > email in error and that any use, dissemination, forwarding, printing, or > copying of this email is strictly prohibited. > > If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. > ___ > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: SARKAR, Samir > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cronjob
If I recall correctly, the reason I was editing the crontab in the first place was to unschedule whatever it was that was filling up /var. Oops. And this happened back when I was doubling as the sysadmin, so I didn't really have anyone else to blame. :-) On the other hand, I didn't have to wait for someone else to restore the crontab from the previous night's backup; I just went and restored it myself. Ups and downs to everything, I suppose. Marc Cure Oracle DBA, OCP 8i -Original Message- Smith Sent: Thursday, April 25, 2002 12:13 AM To: Multiple recipients of list ORACLE-L That's what the SA's are for. Restore please. They should have never let /var get full:-) -Original Message- Sent: Wednesday, April 24, 2002 3:09 PM To: Multiple recipients of list ORACLE-L You'll lose your entire crontab if you do a crontab -e when /var is full? (I've had this happen to me on HP-UX...) Marc Cure Oracle DBA, OCP 8i -Original Message- [EMAIL PROTECTED] Sent: Wednesday, April 24, 2002 5:19 PM To: Multiple recipients of list ORACLE-L crontab -e is bad! 1000 points if you can figure out why. ( guess I'm watching too much 'Whose Line Is It Anyway?" ) Jared Alex <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 04/24/2002 10:07 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Re: Cronjob crontab -e On Wed, 24 Apr 2002, bill thater wrote: > [EMAIL PROTECTED] wrote: > > > Anyone whom can tell me how to delete a job that is created by crontab. > > > > Thanks in advance > > > > > > Roland > > > > > > man crontab > > > -- > -- > Bill "Shrek" Thater ORACLE DBA > [EMAIL PROTECTED] > > You gotta program like you don't need the money, > You gotta compile like you'll never get hurt, > You gotta run like there's nobody watching, > It's gotta come from the heart if you want it to work. > > Your e-mail has been returned due to insufficient voltage. > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: bill thater > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Marc Cure INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 fr
RE: Cronjob
Ahmadsyah, If I remember correctly (my Vax is a couple of years old), we set up two jobs to accomplish this. One job ran every day. All this job did was to start the real job schedule job. the job schedule job interrogated what day of the week it was and ran other jobs. For example, if today is Thursday, it would start all jobs that were supposed to run on a thursday. the final thing that this job did was to re-schedule the first job for tommorrow at the same time. Kind of a circular job scheduling process. hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, April 25, 2002 10:34 AM To: Multiple recipients of list ORACLE-L I have the same problem but with our vax/vms machine.. could I submit a job queue on every week or maybe every month... $Submi/Noprin/Notif/Que=Parm_Deplan/log=[diga.digu]dige.log - _$/After = "tomorrow+06:00" - _$sys$geology:[diga.digu]dige.com I usually submit que every day.. but I want to submit every week and month or every saturday. Could I do it on our vax machine? regards, Ahmadsyah Alghozi Nugroho Certified Oracle DBA - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, April 25, 2002 7:38 PM > 0 06 * * 6 d31/appl/konto/bat/laddabilbo.sh > >/d31/appl/konto/log/laddabilbo.log 2>&1 > > Samir > > Samir Sarkar > Oracle DBA > SchlumbergerSema > Email : [EMAIL PROTECTED] > [EMAIL PROTECTED] > Phone : +44 (0) 115 - 957 6028 > EPABX : +44 (0) 115 - 957 6418 Ext. 76028 > Fax : +44 (0) 115 - 957 6018 > > > -Original Message- > Sent: 25 April 2002 12:43 > To: Multiple recipients of list ORACLE-L > > > Hallo, > > I would like to have this cronjob run only in saturday mornings at 6 am. How > could I easy change this script? > > 0 18 * * * /d31/appl/konto/bat/laddabilbo.sh > >/d31/appl/konto/log/laddabilbo.log > 2>&1 > > Thanks in advance > > Roland > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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 email is confidential and intended solely for the use of the > individual to whom it is addressed. Any views or opinions presented are > solely those of the author and do not necessarily represent those of > SchlumbergerSema. > If you are not the intended recipient, be advised that you have received this > email in error and that any use, dissemination, forwarding, printing, or > copying of this email is strictly prohibited. > > If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. > ___ > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: SARKAR, Samir > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yo
Re: Cronjob
Dear Tom, Would you send me example of the script. Because I'm new with VMS environment. thanks in advance, Ahmadsyah - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, April 25, 2002 11:43 PM > Ahmadsyah, > > If I remember correctly (my Vax is a couple of years old), we set up two > jobs to accomplish this. One job ran every day. All this job did was to > start the real job schedule job. the job schedule job interrogated what day > of the week it was and ran other jobs. For example, if today is Thursday, > it would start all jobs that were supposed to run on a thursday. > > the final thing that this job did was to re-schedule the first job for > tommorrow at the same time. Kind of a circular job scheduling process. > > hope this helps. > > Tom Mercadante > Oracle Certified Professional > > > -Original Message- > Sent: Thursday, April 25, 2002 10:34 AM > To: Multiple recipients of list ORACLE-L > > > I have the same problem but with our vax/vms machine.. > could I submit a job queue on every week or maybe every month... > > $Submi/Noprin/Notif/Que=Parm_Deplan/log=[diga.digu]dige.log - > _$/After = "tomorrow+06:00" - > _$sys$geology:[diga.digu]dige.com > > I usually submit que every day.. but I want to submit every week and month > or every saturday. > Could I do it on our vax machine? > > regards, > > Ahmadsyah Alghozi Nugroho > Certified Oracle DBA > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Thursday, April 25, 2002 7:38 PM > > > > 0 06 * * 6 d31/appl/konto/bat/laddabilbo.sh > > >/d31/appl/konto/log/laddabilbo.log 2>&1 > > > > Samir > > > > Samir Sarkar > > Oracle DBA > > SchlumbergerSema > > Email : [EMAIL PROTECTED] > > [EMAIL PROTECTED] > > Phone : +44 (0) 115 - 957 6028 > > EPABX : +44 (0) 115 - 957 6418 Ext. 76028 > > Fax : +44 (0) 115 - 957 6018 > > > > > > -Original Message- > > Sent: 25 April 2002 12:43 > > To: Multiple recipients of list ORACLE-L > > > > > > Hallo, > > > > I would like to have this cronjob run only in saturday mornings at 6 am. > How > > could I easy change this script? > > > > 0 18 * * * /d31/appl/konto/bat/laddabilbo.sh > > >/d31/appl/konto/log/laddabilbo.log > > 2>&1 > > > > Thanks in advance > > > > Roland > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > 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 email is confidential and intended solely for the use of the > > individual to whom it is addressed. Any views or opinions presented are > > solely those of the author and do not necessarily represent those of > > SchlumbergerSema. > > If you are not the intended recipient, be advised that you have received > this > > email in error and that any use, dissemination, forwarding, printing, or > > copying of this email is strictly prohibited. > > > > If you have received this email in error please notify the > SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. > > > ___ > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: SARKAR, Samir > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > 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.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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
Re: Cronjob
-- [EMAIL PROTECTED] > Dear Tom, > Would you send me example of the script. Because I'm new with VMS > environment. > > thanks in advance, This is gonna be living hell to deal with in DCL. Suggestion: grab a copy of perl5 and use Schedule::Cron to cycle the jobs with the vms-ish file system to handle lookups. Main advantage is giving you a single point to track the results -- instead of having to deal with all of the /after options and separate jobs. With Schedule::Cron you can feed in a "crontab" file or use $cron->add( $schedule ) to generate the jobs w/in your code. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cronjob
Hello, Has anyone ever tried setting dml_locks to zero or disabling table locks on an OPS (2-node, 8.1.7.2.1, 32-bit; HP 11.0, 64-bit) as a way of reducing contention and freeing up resources ? We currently use 7,250 dml_locks/instance. Oracle's OPS Admin manual (8i) had the following to say: Obtaining table locks, such as DML locks, for inserts, deletes, and updates can diminish performance in Oracle Parallel Server. Locking a table in Oracle Parallel Server is undesirable because all instances holding locks on the table must release those locks. Consider disabling these locks entirely using one of the two methods described under the following headings: Disabling Table Locks Setting DML_LOCKS to Zero We found, of our 200MB shared pool, that 108MB was taken up by State objects, gc_*, and dlm shared memory (100,000 gc_releasable_locks), frequently leaving us with just 3-6MB of shared pool free and getting occasional 4031's, so next week, plan on reducing the granularity considerably by setting gc_files_to_locks as 1=500R:2-600=100REACH, and gc_releasable_locks to roughly 30,000 (doing the math, you get 22,600 for the 1 system datafile and 221 other datafiles; we added 7,400 locks for 74 datafiles future growth). Adding up non-PCM and PCM locks would result in needing 120,123 for lm_ress and 180,185 for lm_locks. Any assistance would be both informative and appreciated. Thank you, Paul Sherman DBAElcom, Inc. voice - 781-501-4143 (direct #) fax- 781-278-8341 (secure) email - [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Paul R. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cronjob misbehaving
Your CRON script should also define the ORACLE_HOME, ORACLE_SID and PATH. Why do you need a CRON job to recompile database objects every day ? Why are the being invalidated every day ? Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd "Simon Waibale" <[EMAIL PROTECTED]> 22/03/2002 04:18 PM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: Cronjob misbehaving Hi all, Thanx for all the good work U R doing for Oracle. I have a misbehaving cronjob -Cron Entry 0 5 * * * /usr/scripts/recompile.sh > /ops/scripts/recompile.log 2>&1 -recompile.sh #!/bin/ksh ## Program name : recompile.sh ## Purpose : Recompile Invalid Database Objects for specified Shema in FLAG ## Author : C.S Waibale Simon ## Date written : 2002-03-19 #for i in FLAGPASS CALLSPASS FLAGPASS CH1PASS CH2PASS CH3PASS ; do #j:=1 #$i=${i:-$(crypt flag < passwds |awk '{print $j}') #done SQLPLUS=/ops/product/817/bin/sqlplus #Do not export the password variables ! FLAGPASS=${FLAGPASS:-$(crypt flag < /usr/scripts/passwds |awk '{print $1}')} CALLS_PASS=${CALLS_PASS:-$(crypt flag < /usr/scripts/passwds |awk '{print $2}')} WHPASS=${WHPASS:-$(crypt flag < /usr/scripts/passwds |awk '{print $3}')} echo "Recompiling Invalid Database Objects in the FLAG instance" #This can be sustitued with generic code $SQLPLUS flag_calls/$[EMAIL PROTECTED] @/ops/rom/recompile.sql $SQLPLUS flag/$[EMAIL PROTECTED] @/ops/rom/recompile.sql $SQLPLUS flag_wh/$[EMAIL PROTECTED] @/ops/rom/recompile.sql -recompile.log Recompiling Invalid Database Objects in the FLAG instance Message file sp1.msb not found Error 6 initializing SQL*Plus Message file sp1.msb not found Error 6 initializing SQL*Plus Message file sp1.msb not found Error 6 initializing SQL*Plus What could be broken ?? The script runs correctly from comand prompt. --- +---+ C.S Waibale Simon MTN-Uganda, 8th Floor UDB Building Cell: +256 77-212655,http://mtn.co.ug +---+ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Simon Waibale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cronjob misbehaving
Title: RE: Cronjob misbehaving It looks as if your ORACLE_HOME is not being set up. Try either or both of the following 1) Amend your cron job to look like the following (I assume you are running this as user oracle) 0 5 * * * su - oracle 'usr/scripts/recompile.sh' > /ops/scripts/recompile.log 2>&1 Otherwise set the environment up in the script #!/bin/ksh export ORACLE_SID= export ORACLE_BASE= export ORACLE_TERM=vt100 export ORACLE_HOME= export PATH=$PATH:$ORACLE_HOME/bin Then the script HTH John -Original Message- From: Simon Waibale [mailto:[EMAIL PROTECTED]] Sent: 22 March 2002 08:18 To: Multiple recipients of list ORACLE-L Subject: Cronjob misbehaving Hi all, Thanx for all the good work U R doing for Oracle. I have a misbehaving cronjob -Cron Entry 0 5 * * * /usr/scripts/recompile.sh > /ops/scripts/recompile.log 2>&1 -recompile.sh #!/bin/ksh ## Program name : recompile.sh ## Purpose : Recompile Invalid Database Objects for specified Shema in FLAG ## Author : C.S Waibale Simon ## Date written : 2002-03-19 #for i in FLAGPASS CALLSPASS FLAGPASS CH1PASS CH2PASS CH3PASS ; do #j:=1 #$i=${i:-$(crypt flag < passwds |awk '{print $j}') #done SQLPLUS=/ops/product/817/bin/sqlplus #Do not export the password variables ! FLAGPASS=${FLAGPASS:-$(crypt flag < /usr/scripts/passwds |awk '{print $1}')} CALLS_PASS=${CALLS_PASS:-$(crypt flag < /usr/scripts/passwds |awk '{print $2}')} WHPASS=${WHPASS:-$(crypt flag < /usr/scripts/passwds |awk '{print $3}')} echo "Recompiling Invalid Database Objects in the FLAG instance" #This can be sustitued with generic code $SQLPLUS flag_calls/$[EMAIL PROTECTED] @/ops/rom/recompile.sql $SQLPLUS flag/$[EMAIL PROTECTED] @/ops/rom/recompile.sql $SQLPLUS flag_wh/$[EMAIL PROTECTED] @/ops/rom/recompile.sql -recompile.log Recompiling Invalid Database Objects in the FLAG instance Message file sp1.msb not found Error 6 initializing SQL*Plus Message file sp1.msb not found Error 6 initializing SQL*Plus Message file sp1.msb not found Error 6 initializing SQL*Plus What could be broken ?? The script runs correctly from comand prompt. --- +---+ C.S Waibale Simon MTN-Uganda, 8th Floor UDB Building Cell: +256 77-212655,http://mtn.co.ug +---+ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Simon Waibale INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists 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 electronic message contains information from the mmO2 plc Group which may be privileged or confidential. The information is intended to be for the use of the individual(s) or entity named above. If you are not the intended recipient be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. If you have received this electronic message in error, please notify us by telephone or email (to the numbers or address above) immediately. =
Re: Cronjob misbehaving
Set your Oracle environment as the first thing in the cron job (typically by setting ORACLE_SID and calling oraenv) hth connor --- Simon Waibale <[EMAIL PROTECTED]> wrote: > Hi all, > Thanx for all the good work U R doing for Oracle. > I have a misbehaving cronjob > > -Cron Entry > 0 5 * * * /usr/scripts/recompile.sh > > /ops/scripts/recompile.log 2>&1 > > > -recompile.sh > #!/bin/ksh > > ## Program name : recompile.sh > ## Purpose : Recompile Invalid Database Objects > for specified Shema in > FLAG > ## Author : C.S Waibale Simon > ## Date written : 2002-03-19 > > #for i in FLAGPASS CALLSPASS FLAGPASS CH1PASS > CH2PASS CH3PASS ; do > #j:=1 > #$i=${i:-$(crypt flag < passwds |awk '{print $j}') > #done > > SQLPLUS=/ops/product/817/bin/sqlplus > #Do not export the password variables ! > FLAGPASS=${FLAGPASS:-$(crypt flag < > /usr/scripts/passwds |awk '{print $1}')} > CALLS_PASS=${CALLS_PASS:-$(crypt flag < > /usr/scripts/passwds |awk '{print > $2}')} > WHPASS=${WHPASS:-$(crypt flag < /usr/scripts/passwds > |awk '{print $3}')} > echo "Recompiling Invalid Database Objects in the > FLAG instance" > #This can be sustitued with generic code > $SQLPLUS flag_calls/$[EMAIL PROTECTED] > @/ops/rom/recompile.sql > $SQLPLUS flag/$[EMAIL PROTECTED] > @/ops/rom/recompile.sql > $SQLPLUS flag_wh/$[EMAIL PROTECTED] > @/ops/rom/recompile.sql > > -recompile.log > Recompiling Invalid Database Objects in the FLAG > instance > Message file sp1.msb not found > Error 6 initializing SQL*Plus > Message file sp1.msb not found > Error 6 initializing SQL*Plus > Message file sp1.msb not found > Error 6 initializing SQL*Plus > > > What could be broken ?? > The script runs correctly from comand prompt. > > --- > > +---+ > C.S Waibale Simon > MTN-Uganda, 8th Floor UDB Building > Cell: +256 77-212655,http://mtn.co.ug > +---+ > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Simon Waibale > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > 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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cronjob misbehaving
Thanx. A lot of development work is going on and I need a daily report on the changes made in the packages. Recompiled Invalid objects suppliment my report. Ciao, CSW -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Friday, March 22, 2002 11:58 AM To: Multiple recipients of list ORACLE-L Your CRON script should also define the ORACLE_HOME, ORACLE_SID and PATH. Why do you need a CRON job to recompile database objects every day ? Why are the being invalidated every day ? Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd "Simon Waibale" <[EMAIL PROTECTED]> 22/03/2002 04:18 PM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: Cronjob misbehaving Hi all, Thanx for all the good work U R doing for Oracle. I have a misbehaving cronjob -Cron Entry 0 5 * * * /usr/scripts/recompile.sh > /ops/scripts/recompile.log 2>&1 -recompile.sh #!/bin/ksh ## Program name : recompile.sh ## Purpose : Recompile Invalid Database Objects for specified Shema in FLAG ## Author : C.S Waibale Simon ## Date written : 2002-03-19 #for i in FLAGPASS CALLSPASS FLAGPASS CH1PASS CH2PASS CH3PASS ; do #j:=1 #$i=${i:-$(crypt flag < passwds |awk '{print $j}') #done SQLPLUS=/ops/product/817/bin/sqlplus #Do not export the password variables ! FLAGPASS=${FLAGPASS:-$(crypt flag < /usr/scripts/passwds |awk '{print $1}')} CALLS_PASS=${CALLS_PASS:-$(crypt flag < /usr/scripts/passwds |awk '{print $2}')} WHPASS=${WHPASS:-$(crypt flag < /usr/scripts/passwds |awk '{print $3}')} echo "Recompiling Invalid Database Objects in the FLAG instance" #This can be sustitued with generic code $SQLPLUS flag_calls/$[EMAIL PROTECTED] @/ops/rom/recompile.sql $SQLPLUS flag/$[EMAIL PROTECTED] @/ops/rom/recompile.sql $SQLPLUS flag_wh/$[EMAIL PROTECTED] @/ops/rom/recompile.sql -recompile.log Recompiling Invalid Database Objects in the FLAG instance Message file sp1.msb not found Error 6 initializing SQL*Plus Message file sp1.msb not found Error 6 initializing SQL*Plus Message file sp1.msb not found Error 6 initializing SQL*Plus What could be broken ?? The script runs correctly from comand prompt. --- +---+ C.S Waibale Simon MTN-Uganda, 8th Floor UDB Building Cell: +256 77-212655,http://mtn.co.ug +---+ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Simon Waibale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Simon Waibale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cronjob misbehaving
Simon -- One of the things that many people (even some of the more experienced unix types) tend to forget is that cron doesn't source the user's profile. This is why a script might work just fine from the prompt, but fail when submitted through cron. So, the solution would be either: a) Make sure your script sources the user's .profile or, better yet: b) Adopt a standard by which any script you may want to possibly submit through cron defines the important environment settings ($ORACLE_SID, $ORACLE_HOME, $PATH, etc.) -- James Simon Waibale wrote: > > Hi all, > Thanx for all the good work U R doing for Oracle. > I have a misbehaving cronjob > > -Cron Entry > 0 5 * * * /usr/scripts/recompile.sh > /ops/scripts/recompile.log 2>&1 > > -recompile.sh > #!/bin/ksh > > ## Program name : recompile.sh > ## Purpose : Recompile Invalid Database Objects for specified Shema in > FLAG > ## Author : C.S Waibale Simon > ## Date written : 2002-03-19 > > #for i in FLAGPASS CALLSPASS FLAGPASS CH1PASS CH2PASS CH3PASS ; do > #j:=1 > #$i=${i:-$(crypt flag < passwds |awk '{print $j}') > #done > > SQLPLUS=/ops/product/817/bin/sqlplus > #Do not export the password variables ! > FLAGPASS=${FLAGPASS:-$(crypt flag < /usr/scripts/passwds |awk '{print $1}')} > CALLS_PASS=${CALLS_PASS:-$(crypt flag < /usr/scripts/passwds |awk '{print > $2}')} > WHPASS=${WHPASS:-$(crypt flag < /usr/scripts/passwds |awk '{print $3}')} > echo "Recompiling Invalid Database Objects in the FLAG instance" > #This can be sustitued with generic code > $SQLPLUS flag_calls/$[EMAIL PROTECTED] @/ops/rom/recompile.sql > $SQLPLUS flag/$[EMAIL PROTECTED] @/ops/rom/recompile.sql > $SQLPLUS flag_wh/$[EMAIL PROTECTED] @/ops/rom/recompile.sql > > -recompile.log > Recompiling Invalid Database Objects in the FLAG instance > Message file sp1.msb not found > Error 6 initializing SQL*Plus > Message file sp1.msb not found > Error 6 initializing SQL*Plus > Message file sp1.msb not found > Error 6 initializing SQL*Plus > > What could be broken ?? > The script runs correctly from comand prompt. > > --- > > +---+ > C.S Waibale Simon > MTN-Uganda, 8th Floor UDB Building > Cell: +256 77-212655,http://mtn.co.ug > +---+ > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Simon Waibale > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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). -- James J. Morrow E-Mail: [EMAIL PROTECTED] Senior Principal Consultant Tenure Systems, Inc. Arlington, TX, USA "The reasonable man adapts himself to the world: the unreasonable man persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man." -- George Bernard Shaw -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James J. Morrow INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cronjob misbehaving
Hi James,Connor, Hallas, Hemant Receive my heartfelt and sincere vote of thanx to you all for the brotherly guidance - I solved this and promise to pay back by helping someone else out there in turn. Simon -Original Message- Sent: Saturday, March 23, 2002 7:33 AM To: Multiple recipients of list ORACLE-L Simon -- One of the things that many people (even some of the more experienced unix types) tend to forget is that cron doesn't source the user's profile. This is why a script might work just fine from the prompt, but fail when submitted through cron. So, the solution would be either: a) Make sure your script sources the user's .profile or, better yet: b) Adopt a standard by which any script you may want to possibly submit through cron defines the important environment settings ($ORACLE_SID, $ORACLE_HOME, $PATH, etc.) -- James Simon Waibale wrote: > > Hi all, > Thanx for all the good work U R doing for Oracle. > I have a misbehaving cronjob > > -Cron Entry > 0 5 * * * /usr/scripts/recompile.sh > /ops/scripts/recompile.log 2>&1 > > -recompile.sh > #!/bin/ksh > > ## Program name : recompile.sh > ## Purpose : Recompile Invalid Database Objects for specified Shema in > FLAG > ## Author : C.S Waibale Simon > ## Date written : 2002-03-19 > > #for i in FLAGPASS CALLSPASS FLAGPASS CH1PASS CH2PASS CH3PASS ; do > #j:=1 > #$i=${i:-$(crypt flag < passwds |awk '{print $j}') > #done > > SQLPLUS=/ops/product/817/bin/sqlplus > #Do not export the password variables ! > FLAGPASS=${FLAGPASS:-$(crypt flag < /usr/scripts/passwds |awk '{print $1}')} > CALLS_PASS=${CALLS_PASS:-$(crypt flag < /usr/scripts/passwds |awk '{print > $2}')} > WHPASS=${WHPASS:-$(crypt flag < /usr/scripts/passwds |awk '{print $3}')} > echo "Recompiling Invalid Database Objects in the FLAG instance" > #This can be sustitued with generic code > $SQLPLUS flag_calls/$[EMAIL PROTECTED] @/ops/rom/recompile.sql > $SQLPLUS flag/$[EMAIL PROTECTED] @/ops/rom/recompile.sql > $SQLPLUS flag_wh/$[EMAIL PROTECTED] @/ops/rom/recompile.sql > > -recompile.log > Recompiling Invalid Database Objects in the FLAG instance > Message file sp1.msb not found > Error 6 initializing SQL*Plus > Message file sp1.msb not found > Error 6 initializing SQL*Plus > Message file sp1.msb not found > Error 6 initializing SQL*Plus > > What could be broken ?? > The script runs correctly from comand prompt. > > --- > > +---+ > C.S Waibale Simon > MTN-Uganda, 8th Floor UDB Building > Cell: +256 77-212655,http://mtn.co.ug > +---+ > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Simon Waibale > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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). -- James J. Morrow E-Mail: [EMAIL PROTECTED] Senior Principal Consultant Tenure Systems, Inc. Arlington, TX, USA "The reasonable man adapts himself to the world: the unreasonable man persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man." -- George Bernard Shaw -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James J. Morrow INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Simon Waibale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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