Home » RDBMS Server » Server Administration » crontab failure
crontab failure [message #206208] Wed, 29 November 2006 03:37 Go to next message
prashanth_gs
Messages: 67
Registered: November 2005
Location: chennai
Member
Hi all,

I scheduled my weekly backup in crontab but it doesnot get executed.

More over, while checking I was unable to find any details while issuing command
in crontab -l

I scheduled the job by issuing

crontab -e /u04/gdbprd/scripts/dailyexp10g.sh and saved it properly.

What would be the reason and how to resolve this?

Please explain.

Prashanth


Re: crontab failure [message #206244 is a reply to message #206208] Wed, 29 November 2006 04:56 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You mean to say,
crontab -l is not showing the appropriate entries?
Then you may not have made the entries at all.
Not sure what you are talking about.
Re: crontab failure [message #206283 is a reply to message #206208] Wed, 29 November 2006 07:43 Go to previous messageGo to next message
rtjk
Messages: 33
Registered: February 2005
Member
Hello prasanth,


crontab should be scheduled as follows.

crontab -e

The crontab file contains six fields:

Field No Field Values Description
1 Minute 0-59 Minute of the hour
2 Hour 0-23 Hour of the day
3 Day 1-31 Day of the month
4 Month 1-12 Month of the year
5 Weekday 0-6 Day of the week(0=Sunday)
6 Command NA The command to execute


00 04 * * * /utils/cronkickoff/startjobonactivehost.sh "ksh /loc/kai/sri.sh"

for example the above cron will execute on 4 clock morning everyday


* indicated that it has to execute all the time.

Hope it helps.

Jayakumar
Re: crontab failure [message #206336 is a reply to message #206283] Wed, 29 November 2006 11:32 Go to previous messageGo to next message
prashanth_gs
Messages: 67
Registered: November 2005
Location: chennai
Member
No, Still its not working.

I gave all the privileges (777) to the script.

What would be the other reasons for that not get implemented?

Please advice.

Prashanth.
Re: crontab failure [message #206341 is a reply to message #206336] Wed, 29 November 2006 12:13 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
Why would changing the permissions on a shell script have any effect on whether a job runs if it's not in the crontab?
Like Mahesh said, if you don't have anything returned from crontab -l, then you didn't create a cronjob. crontab -e shellscript.sh is not how you create a cronjob. Look at Jaya's response.
Re: crontab failure [message #206978 is a reply to message #206336] Sat, 02 December 2006 22:47 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi

if you schudule ur job through crontab and ur job is not run then check mail sended by crontab what is exacly problem.

login super user.
and check
etc/profile file ( location of ur mail) and check ur mail.

and when you type

$crontab -l
what message you got...

1. no crontab for "username"

2. any specific job sehudule entry.


post here.

hope this helps
Taj
Previous Topic: Issue with the ALTER SYSTEM command
Next Topic: what is diff between "Create pfile from spfile and Create spfile from pfile"
Goto Forum:
  


Current Time: Fri Sep 20 15:28:54 CDT 2024