Solaris

usage of "at" command instead of crontab

Hi all,

Iam facing some problem while scheduling a script job from crontab. this script is calling one sql script to extract some report information. If I mannually run this script this is working fine. But it is not working with crontab. It is failing to call sql script.
For all the command I specified full paths, set $Oracle home path etc,. but still it is not working.

But I can able to schedule this script reccursively with "at" command. Till now it is working fine. But I dont know are there any diffence b/n crontab and reccursive at commands!!!!!!!!

Suggest me please.

Your friend for ever,
Love

Hi.
Have a look at your server's logfiles (cron ones). Perhaps there you could find a reason.
It seems to me that it's a question of environment, but need more info...

Thanks a lot.
can you tell me the location for server log (cron's) files?

Regards,
Love

The cron logs can be found on Sun systems at /var/cron/log, on HP-UX at /var/adm/cron/log. On other systems, check the man page of cron. The files' listing should be at the end of the man pages.

Blowtourch,

I dont have sufficient privilage to view the log file present in /var/cron/log.
Because user is 'root' for that log file.
The problem is Shell script successfully calling the SQL script if I run mannually, same thing is not working with crontab. I've set all the path variable for all the commands including Oracle path.

Any help will be grateful for me.

When you say "manually", you mean whith the oracle user, don't you?
So, have you included ORACLE_SID, ORACLE_HOME and all those Oracle shell variables in your shell script?

Yes Grial,

I've included ORACLE_SID and ORACLE_HOME.
What all are the other Oracle shell variables?