Re[2]: Ltrim?
Roland, By now you've seen several messages showing you the cron syntax to get you task to start at the time you want. There is characteristic of cron that seems to catch first time users -- the environment settings. As a shell users you'll be used to having your .profile or .login (or similar script depending on what shell you use) run and set up your environment. And when you run "at" or "batch" jobs your current environment is passed on to those scripts. Job's that start from your "crontab" on the other hand, have a stripped down environment. Try running a crontab command that just does a "set" and compare the email output to the environment that you have when you are at a shell prompt and the differences will be obvious. You'll probably see major differences in $PATH and $ORACLE_HOME, either of which could keep your script from executing properly. The solution is to set your own environment every time a crontab task starts. I keep a stripped down version of my .profile that I name .cron_profile that has the environment I need to run sqlplus scripts. Then my crontab entries look like: 0 6 * * 1 . $HOME/.cron_profile; script_name -rje J> 0 6 * * 1 script_name R> Hallo, R> Anyone whom could help me how to write in cron when R> scheduling the start of a unixprogram. R> I would like that the unix script will run every monday on 6 am. R> I have tried but it fails. Any suggestions, please help R> Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Ltrim?
Title: RE: Ltrim? Should be something like this 0 6 * * 1 ksh myscript.ksh -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, November 22, 2002 9:19 AM To: Multiple recipients of list ORACLE-L Subject: Ltrim? Hallo, Anyone whom could help me how to write in cron when scheduling the start of a unixprogram. I would like that the unix script will run every monday on 6 am. I have tried but it fails. Any suggestions, please help Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Ltrim?
The cron part is easy but you have to make sure your Unix script works. Next time, before you post a question ... please try looking up the answer for yourself on any of the available sources. In this case, the man function of unix tells you exactly what you need to know.You should have done a man on crontab. 00 06 * * 5 your_unix_script minute (0-59), 00 = 0 minutes hour (0-23), 06 = 6 am day of the month (1-31), month of the year (1-12), day of the week (0-6 with 0=Sunday). 5 = Friday command name -Original Message- Sent: Friday, November 22, 2002 8:19 AM To: Multiple recipients of list ORACLE-L Hallo, Anyone whom could help me how to write in cron when scheduling the start of a unixprogram. I would like that the unix script will run every monday on 6 am. I have tried but it fails. Any suggestions, please help Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Ltrim?
0 6 * * 1 script_name -Original Message- Sent: vrijdag 22 november 2002 15:19 To: Multiple recipients of list ORACLE-L Hallo, Anyone whom could help me how to write in cron when scheduling the start of a unixprogram. I would like that the unix script will run every monday on 6 am. I have tried but it fails. Any suggestions, please help Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Ltrim?
Hallo, Anyone whom could help me how to write in cron when scheduling the start of a unixprogram. I would like that the unix script will run every monday on 6 am. I have tried but it fails. Any suggestions, please help Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).