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.
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)
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)
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)
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)
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)
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)
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)
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)
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)
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
LEARN ABOUT SUSE
apache::session::store::informix
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)