Sponsored Content
Top Forums Shell Programming and Scripting Problem with Job execution using crontab Post 302572462 by krishna_gnv on Thursday 10th of November 2011 04:50:24 AM
Old 11-10-2011
Yes, i checked in log file. it states
/afs2/cdwfullacc/current/exe/myscript.sh: sqlplus: execute permission denied

Here is my script
Code:
LOGSQL=xyz\$app1
PASSWORDSQL=mypass\@applicaiton.ptt.nl

last_hour=`sqlplus -s $LOGSQL/$PASSWORDSQL << EOF
           set sqln off
           set feed off
           set head off
           select substr(file_name,70,2) from (select file_name from table1 order by file_name desc) where rownum=1;
exit;
EOF`

echo "welcome $last_hour" | mail xyz@abc.com

Now the problem is when this script is executed at command prompt, it executes. But when scheduled, it gives above error.

Query will retrieve value 17.

Kindly help me


Moderator's Comments:
Mod Comment Please use code tags <- click the link!

Last edited by zaxxon; 11-10-2011 at 05:59 AM.. Reason: code tags, see PM
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Run crontab job problem

I hv a crontab job (script) that can be run normally , now I try to run it on the shell but can't be run , can advise what is difference between run a script on crontab and run it manually ? is it the difference of system enviornment ?thx I tried to fix it by below method , I write a script... (3 Replies)
Discussion started by: ust
3 Replies

2. UNIX for Advanced & Expert Users

Job execution through Xming

Hello, Every evening I run few shell scripts on AIX Production Box, One shell script takes about one hour to complete and does some DB updation and application processing etc. The shell scripts are getting launched from prompt and not through cron or any scheduler as they require some manual... (0 Replies)
Discussion started by: panchpan
0 Replies

3. Shell Programming and Scripting

crontab execution

is it possible to soecify time overnight in 5 days for example: 0 18-7 * * 1-5 /mycode is this okay to use 18-7 because im not getting the results correctly? (4 Replies)
Discussion started by: vadharah
4 Replies

4. UNIX for Dummies Questions & Answers

Confirm job execution

Hello everybody, Can anybody tell me how do we comfirm the execution of a scheduled job ? In other words, how do I know whether my scheduled script is being executed or not ? Thanks Jitu JK (2 Replies)
Discussion started by: jitu.jk
2 Replies

5. Solaris

Solaris 10.5 perl and cron job execution problem

Hi, I want to run a crontab job on solaris 10.5. I have configured the crontab accordingly 10 * * * * /scripts/dbalter.pl >> /scripts/cronout.txt However this does not work .Then I go to /var/mail/root and find an error in the output: From root@myserver Wed Feb 4 17:02:00 2009... (1 Reply)
Discussion started by: sonu2die4
1 Replies

6. Shell Programming and Scripting

Parallel Job Execution

Hi All, At present I am using a UNIX Script which is running a set of JOBS. These JOBS are to be repeated for 20 times, means the same set of JOBS are repeated by just passing different arguments (From 1 to 20). Is there any way by which I can execute them parallel? At present its all... (4 Replies)
Discussion started by: Prashantckc
4 Replies

7. UNIX for Dummies Questions & Answers

Problem with Crontab execution

Hi I have shell script to excute the SQL script.And i have scheduled those shell script in crontab.But the Shell script is not running timely and i got the below error Crontab entry 15 05 17 7 * /export/home/vcpsapp/vcps/stat.sh Output Your "cron" job on uspxivus16... (3 Replies)
Discussion started by: mak_boop
3 Replies

8. Shell Programming and Scripting

Crontab job scheduler problem

Dear All. I have a scripts which does many task like house keeping, moving file to different location and loading the data into oracle. I run this scripts daliy manually , I decided to put it into cron. I have put the scripts into crantab but the behaviour of the scripts have changed. it... (2 Replies)
Discussion started by: guddu_12
2 Replies

9. HP-UX

Crontab Execution

Hi Guys, I need help to clear my doubt w.r.t Crontab execution. uname -a HP-UX myservername B.11.31 U ia64 1422528451 unlimited-user licenseI created a crontab entry to execute particular job on Saturday 11/15/2014 11:22 Below is the cron entry #refresh DEVDB from PRODDB 22 11 15 11 6... (6 Replies)
Discussion started by: rocky.community
6 Replies

10. Shell Programming and Scripting

Execution problem with CRON job

HI, I have written an executable file in unix and I was able to execute it successfully but when I called this file with cron job it was giving error like "permission denied" and "No such file or directory". Please help in how cron calls the file and what permission is required on the file... (2 Replies)
Discussion started by: vipin kumar rai
2 Replies
Session::Store::Informix(3)				User Contributed Perl Documentation			       Session::Store::Informix(3)

NAME
Apache::Session::Store::Informix - Store persistent data in a Informix database SYNOPSIS
use Apache::Session::Store::Informix; my $store = new Apache::Session::Store::Informix; $store->insert($ref); $store->update($ref); $store->materialize($ref); $store->remove($ref); DESCRIPTION
Apache::Session::Store::Informix fulfills the storage interface of Apache::Session. Session data is stored in a Informix database. SCHEMA
To use this module, you will need at least these columns in a table called 'sessions': id char(32) # or however long your session IDs are. a_session lvarchar To create this schema, you can execute this command using the sqlplus program: CREATE TABLE sessions ( id char(32) not null primary key, a_session lvarchar ); If you use some other command, ensure that there is a unique index on the table's id column. CONFIGURATION
The module must know what datasource, username, and password to use when connecting to the database. These values can be set using the options hash (see Apache::Session documentation). The options are DataSource, UserName, and Password. Example: tie %hash, 'Apache::Session::Informix', $id, { DataSource => 'dbi:Informix:database', UserName => 'database_user', Password => 'K00l' }; Instead, you may pass in an already-opened DBI handle to your database. tie %hash, 'Apache::Session::Informix', $id, { Handle => $dbh }; The last option is LongReadLen, which specifies the maximum size of the session object. If not supplied, the default maximum size is 8 KB. AUTHOR
This module was written by Mike Langen <mike.langen@tamedia.ch>, based on the original for Oracle. SEE ALSO
Apache::Session, Apache::Session::Store::DBI perl v5.12.1 2007-09-28 Session::Store::Informix(3)
All times are GMT -4. The time now is 11:43 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy