08-25-2010
Crontab assistance
I have a script that runs a SQL query and then emails me the results. It runs correctly alone. I am trying to set up a cron that will run the script every day at say 5:00. When the script runs alone, the results are emailed exactly like I want the, but when I set up a cronjob, I get a blank email. with the subject indicated in the script.
The script is owned by the correct user and the cron is set in the users crontab. I accessed it my using crontab -e. Is there any reason the cron would cause the script to not email me the same results as just running the script alone??
Thanks!
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I have two questions I am struggling with...
How do the programs p1, p2, and p3 need to handle their standard files so they can work like this: p1 | p2 | p3 ?
What exactly is this command supposed to do?
$ kill -QUIT %1
& This command below?
$ sort -o emp.lst emp lst &
Any... (1 Reply)
Discussion started by: yahoo14
1 Replies
2. Shell Programming and Scripting
I have a school project to create a shell program same as calendar i must create
a txt file with celebrations with vi i know this but the problem is i don't know awk
and grep.
The object of object is to create a program who read a date an appear the celebration.
Can you help me please !!!... (1 Reply)
Discussion started by: mytilini boy
1 Replies
3. Shell Programming and Scripting
Hi.
Does any one know when the below will print hi ?
|| echo hi
Thanks in advance (5 Replies)
Discussion started by: kinny
5 Replies
4. Shell Programming and Scripting
Hello A friend of mine posted this on another site that I follow. It is to advanced for me to figure out. If solved I will give credit where credit is due:
NOTE: Does not have to be AWK. Any Language will work,
Hi. I need a little assistant to write an awk script on linux that reads a file... (12 Replies)
Discussion started by: abacus
12 Replies
5. Homework & Coursework Questions
Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted!
1. The problem statement, all variables and given/known data:
Files stored in /bin, /sbin, /usr/bin, and /usr/sbin vary in their respective sizes. In fact, there are 244... (1 Reply)
Discussion started by: alindner
1 Replies
6. UNIX for Dummies Questions & Answers
Hi,
I would like to know the awk command that gets the below o/p:
File contents:
Board1;9a;60;36;60.0;60;0;0.0
Board2;96;60;35;58.3;55;0;0.0
Board3;92;60;60;100.0;60;60;100.0
Used awk script:
#!/bin/awk -f
BEGIN {
FS = ";";
printf (" Device | ... (1 Reply)
Discussion started by: Dendany83
1 Replies
7. Shell Programming and Scripting
Hi All,
I need your assistance, I would like to replace all lines beginning with the word "begin" with the below text:
Device | IPMB0-A | IPMB0-B
Board Address |Sent SentErr %Errr |Sent SentErr ... (9 Replies)
Discussion started by: Dendany83
9 Replies
8. AIX
I am looking for any help on locating a set of install disks or downloads of AIX 3.2.5 or earlier.. We recently lost our HDD running AIX 3.2.5 and need to reinstall but have no OS disk to complete.. Any help would be appreciated.. Thanks (4 Replies)
Discussion started by: rmsdp
4 Replies
9. Shell Programming and Scripting
Hi,
I have a find command that searches for all the .properties under current directory and its subdirectories.
find . -name "*.properties"
I would like to pass the output of the above find command to my "operation.sh script as the second parameter.
for eg:
./operation.sh 775
... (2 Replies)
Discussion started by: mohtashims
2 Replies
10. Shell Programming and Scripting
Hello everyone.
I am trying to replace
sprintf(buffer, "{\"id\":1,\"method\":\"mining.update_block\",\"params\":}\n", coinid, blockhash);
with
sprintf(buffer, "{\"id\":1,\"method\":\"mining.update_block\",\"params\":}\n", coinid, blockhash);
this is the code I was trying but is... (9 Replies)
Discussion started by: crombiecrunch
9 Replies
cron(8) System Manager's Manual cron(8)
NAME
cron - The system clock daemon
SYNOPSIS
/usr/sbin/cron
DESCRIPTION
The cron daemon runs shell commands at specified dates and times. Commands that are to run according to a regular or periodic schedule are
found within the crontab files. Commands that are to run once only are found within the at files. You submit crontab and at file entries
by using the crontab and at commands. Because the cron process exits only when killed or when the system stops, only one cron daemon
should exist on the system at any given time. Normally, you start the cron daemon from within a run command file.
During process initialization and when cron detects a change, it examines the crontab and at files. This strategy reduces the overhead of
checking for new or changed files at regularly scheduled intervals. The cron command creates a log of its activities. The cron daemon
must be started from the system startup scripts because it must begin execution without a login user ID set. The cron daemon starts each
job with the following process attributes stored with the job by the invoking process: Login user ID Effective and real user IDs Effective
and real group IDs Supplementary groups
It also establishes the following attributes from the authentication profile of the account associated with the login user ID of the invok-
ing process: Audit control and disposition masks Kernel authorizations
DIAGNOSTICS
The at and batch programs will refuse to accept jobs submitted from processes whose login user ID is different from the real user ID.
FILES
Specifies the command path. Main cron directory Directory containing the crontab files. List of allowed users. List of denied users His-
tory information for cron Queue description file for at, batch, and cron
RELATED INFORMATION
Commands: at(1), crontab(1), rc0(8), rc2(8), rc3(8)
Files: queuedefs(4) delim off
cron(8)