Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Execute Shell Script from CRONJOB
Top Forums Shell Programming and Scripting Execute Shell Script from CRONJOB Post 302481667 by reachravi70 on Sunday 19th of December 2010 12:51:23 AM
Old 12-19-2010
Execute Shell Script from CRONJOB
Hi Users,

I am Newbie to linux and cron. I have a requirement to run a job at 8 AM every Sunday.

I am using RHEL 5. Based on the hints through google search I created
crontab and added entry to call the shell script which will in turn login to Oracle user and execute a pl/sql block.

When I run the shell script seperately it works fine. But when included inside the cron it doesn't work.

Here is the crontab
------------------
[root@dstore ~]# crontab -e

0 8 * * sun /opt/media/oracle-scripts/oracle-call.sh

oracle-call.sh file has the following entries
----------------------------------------
#!/usr/bin/sh
su - oracle << EndOfFile
sqlplus -s reporter/reporter@orcl << EndOfFile
@/opt/media/oracle-scripts/create_table_interface.sql;
quit
EndOfFile

-rwxrwxrwx 1 root root 157 Dec 18 17:12 oracle-call.sh


Can someone please guide me where I am going wrong?

Thanks.
RaviShankar.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shell script not running thru Cronjob

Hi I have a shell script, it run ok if executed from the path it is located at but doesnot run when the same is tried through cron-job. can someone help me please. regards gaurav shrinivas Email address removed (8 Replies)
Discussion started by: gauravshrinivas
8 Replies

2. Shell Programming and Scripting

need to have a cronjob which will execute certain scripts every hr

Hi My question needs two answers how to write scripts to update a table in oracle db based on the result of the number of record counts for example i need to execute the following script every hour awk '{sum++;}END{for(i in sum) {print i, sum}}' filename here everyhour the... (3 Replies)
Discussion started by: aemunathan
3 Replies

3. Shell Programming and Scripting

How to execute cronjob running in a different machine?

Hi, I am developing 1 script in which I need to execute one cron job running in different server and my script is in different server. so can any one help me to execute the cronjob set in different server. Thanks in advance. (1 Reply)
Discussion started by: mridul10_crj
1 Replies

4. Shell Programming and Scripting

expect telnet script execute by cronjob

hi, please help, keep getting this bolded error and look it up and people say its your environment variable though i tried to set it manually in expect..it run fine if i run it manually but once i run it by cronjob it error below..i tried to comment out ip/login info with *.. logfile:: START... (0 Replies)
Discussion started by: cssanangeles
0 Replies

5. Shell Programming and Scripting

Shell script scheduling in cronjob

Hi, I have developed a file deletion script and scheduled it in cronjob to run daily at 5:00 AM. But the script is not running automatically any day. However when I run the script manually at any time, it runs successfully. This is how the cron looks like : 0 5 * * *... (5 Replies)
Discussion started by: jhilmil
5 Replies

6. Shell Programming and Scripting

Schedule and Run By weekly shell script in cronjob

Hi All, How to schedule a shell script(script name- byweeklyreport.sh) it should run by weekly in corn job or is there any script have to write to check week and then run the above script. example-1st run March 06 2013 2nd run March 20 2013 3rd run April 3 2013... (13 Replies)
Discussion started by: krupasindhu18
13 Replies

7. Shell Programming and Scripting

Cronjob to be execute today at 9pm

HI Folks, Sorry for this basic confusion but please help me. i want to execute one script at 9pm today. i want make this as schedule so it can execute automatically. So am doing like this. 21 10 24 4 <here what can i keep) /tmp/stemp/testcron.ksh Can you please help on this? ... (6 Replies)
Discussion started by: coolboy98699
6 Replies

8. Shell Programming and Scripting

Unable to execute glance from cronjob

Hi I am writing a script to get the CPU and memory utilization periodically from glance command. Wrote a script which consists of below two lines Script name : Utilization.sh #!/bin/sh glance -iterations 1 | sed -n '/Util/p/'| awk '!/Disk/'| awk '!/Swap/' >> file.txt I am able to run the... (5 Replies)
Discussion started by: Shravani
5 Replies

9. Shell Programming and Scripting

Shell script with cronjob

Hello All, I have a script which will cd into a directory based on current timestamp. It will then do a grep and search for a condition. It's run on a cron job that runs every 30 minutes. So if it finds a match in 00, it sends out the contents of that grep to an alert and emails out. Now... (3 Replies)
Discussion started by: liketheshell
3 Replies

10. UNIX for Beginners Questions & Answers

Execute Ubuntu 14.04 cronjob as non-root

I have created a cronjob that successfully executes and among other thing runs aria2c to download several files and save them to a folder. However, since it executes as sudo, the downloaded folder is saved with those permissions. Is there a way to execute the cronjob so that the downloaded folder... (4 Replies)
Discussion started by: cmccabe
4 Replies

LEARN ABOUT NETBSD

atrun

ATRUN(8)						    BSD System Manager's Manual 						  ATRUN(8)

NAME

     atrun -- run jobs queued for later execution

SYNOPSIS

     atrun [-l load_avg] [-d]

DESCRIPTION

     atrun runs jobs queued by at(1).  Root's crontab(5) must contain the line:

     */10     *       *       *       *       root    /usr/libexec/atrun

     so that atrun(8) gets called every ten minutes.

     At every invocation, every job in lowercase queues whose starting time has passed is started.  A maximum of one batch job (denoted by upper-
     case queues) is started each time atrun is invoked.

OPTIONS

     -l load_avg
	     Specifies a limiting load factor, over which batch jobs should not be run, instead of the compiled-in value of 1.5.

     -d      Debug; print error messages to standard error instead of using syslog(3).

WARNINGS

     For atrun to work, you have to start up a cron(8) daemon.

FILES

     /var/at/spool  Directory containing output spool files
     /var/at/jobs   Directory containing job files

SEE ALSO

     at(1), crontab(1), syslog(3), crontab(5), cron(8)

AUTHORS

     Thomas Koenig <ig25@rz.uni-karlsruhe.de>

BUGS

     The functionality of atrun should be merged into cron(8).

BSD
								  April 12, 1995							       BSD
All times are GMT -4. The time now is 08:53 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy