I checked the link, and fix my script. It works properly now. Thank you for noticing
By the way, why
this script above doesn't work when executed by cron?
It doesn't work because cron doesn't know how to set up your environment like your shell does. When you log in, your shell initializes your environment with settings that allow your database commands to be found without specifying absolute pathnames for the database utilities and includes settings specifying what database to use and what access codes are needed to access that database. You have to make the script you run with cron make that same environment information available to the shell that is being run by cron.
I have a cronjob that I need to run everyday and it needs to have todays date inputed, here is what I have, but is not working as expected..........
23 02 * * * cd /path;./RequestSummaryReport.sh $(date +%Y-%m-%d)
the output from mail gives me.............
Date: Fri, 8 Feb 2008 02:12:07... (4 Replies)
I am pretty new to Unix shell scripting, but wondered if anyone could help (in layman's terms if possible!!) :)
I have a shell script which ultimately sends an alert to an email address if part of a batch of programs fails. Here's the script that sends the email:
Script: 6check.csh... (8 Replies)
cron job not running the sqlplus command in shell script but the shell script works fine from command line..
Cronjob:
5 * * * * /home/dreg/script.sh
script.sh:
#!/bin/ksh
/oracle/u000/app/oracle/product/10204/GEN/bin/sqlplus -s <user>/<pass>@<sid/home/dreg/sqlscript.sh
... (18 Replies)
Hello. I'm having trouble figuring out how to write this script. I'm supposed to have my script start up with specific arguments and if there are missing arguments or invalid arguments, return an error associated to its errorlevel number.
For example, here are a few errorlevel numbers with their... (4 Replies)
Hi, i was looking for an answer for some trouble im having runing a script in the cron, thing is, that when i run it manually it works just fine. But when cron runs it, it just doenst work. I saw a reply on a similar subject, suggesting that the . .profile worked for you, but im kind of... (0 Replies)
Hi, i was looking for an answer for some trouble im having runing a script in the cron, thing is, that when i run it manually it works just fine. But when cron runs it, it just doenst work. I saw a reply on a similar subject, suggesting that the . .profile worked for you, but im kind of... (9 Replies)
Hi Guys,
I do have a shell script that I scheduled to run via the cron but when the script don't run.
But when I run the script manually it does run perfectly...
What might be the problem?
Thanks. (1 Reply)
I'm trying to learn how to use cron for repetative tasks. I have an external disk that needs to be unmounted and remounted every hour due to some problems that a backup utility (specifically, TimeMachine) is having repeatedly accessing the device. I've created a shell script that will find the... (3 Replies)
Hi,
I have a very simple script that queries from a DB2 table. The script has 3 parts - (i) Sets the db2profile (ii) connects to db2 using credentials (iii) executes the query.This script works fine if i run it manually from the command prompt. However when scheduled in crontab, it proceeds... (2 Replies)
Discussion started by: VeePee
2 Replies
LEARN ABOUT DEBIAN
make_combined_log2
make_combined_log.pl(1) General Commands Manual make_combined_log.pl(1)NAME
make_combined_log.pl - make combined logfile from SQL database
SYNOPSIS
make_combined_log.pl <days> <virtual host>
DESCRIPTION
This perl script extracts the httpd access data from a MySQL database and formats it properly for parsing by 3rd-party log analysis tools.
The script is intended to be run out by cron. Its commandline arguments tell it how many days' worth of access records to extract, and
which virtual_host you are interested in (because many people log several virthosts to one MySQL db.) This permits you to run it daily,
weekly, every 9 days -- whatever you decide.
NOTE
By "days" I mean "chunks of 24 hours prior to the moment this script is run." So if you run it at 4:34 p.m. on the 12th, it will go back
through 4:34 p.m. on the 11th.
KNOWN ISSUES
Because GET and POST are not discriminated in the MySQL log, we'll just assume that all requests are GETs. This should have negligible
effect on any analysis software. This could be remedied IF you stored the full HTTP request in your database instead of just the URI, but
that's going to cost you a LOT of space really quickly...
Because this is somewhat of a quick hack it doesn't do the most robust error checking in the world. Run it by hand to confirm your usage
before putting it in crontab.
AUTHOR
Edward Rudd <eddie@omegaware.com>
MAN PAGE CREATED BY
Michael A. Toth <lirul.lists@gmail.com> - based on comments of script
COMMENTS
This man page was written using xml2man (1) by the same author.
Manuals User make_combined_log.pl(1)