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
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 21 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 21 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:
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
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 21 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 21 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 21 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 21 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 21 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 21 __ 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 21 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, 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 21 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 21 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 21 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 21 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 21 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
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 21 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 21 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 yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT
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 ILlamoca@novasa Para:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 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 San Diego, California-- Public Internet access / Mailing Lists
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 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 21
-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 sp1lang.msb not found
Error 6 initializing SQL*Plus
Message file sp1lang.msb not found
Error 6 initializing SQL*Plus
Message file sp1lang.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 21
Otherwise set the environment up in the script
#!/bin/ksh
export ORACLE_SID=your sid
export ORACLE_BASE=your base
export ORACLE_TERM=vt100
export ORACLE_HOME=your 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 21
-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 sp1lang.msb not found
Error 6 initializing SQL*Plus
Message file sp1lang.msb not found
Error 6 initializing SQL*Plus
Message file sp1lang.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 21
-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 sp1lang.msb not found
Error 6 initializing SQL*Plus
Message file sp1lang.msb not found
Error 6 initializing SQL*Plus
Message file sp1lang.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 21
-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 sp1lang.msb not found
Error 6 initializing SQL*Plus
Message file sp1lang.msb not found
Error 6 initializing SQL*Plus
Message file sp1lang.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 21
-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 sp1lang.msb not found
Error 6 initializing SQL*Plus
Message file sp1lang.msb not found
Error 6 initializing SQL*Plus
Message file sp1lang.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 21
-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 sp1lang.msb not found
Error 6 initializing SQL*Plus
Message file sp1lang.msb not found
Error 6 initializing SQL*Plus
Message file sp1lang.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 name of mailing list you want to be removed from). You may
also
