09-20-2002
Scipt
this is as easy as it seems:
$ more Report.sh
sqlplus user/passwd @script1.sql
sqlplus user/passwd @script2.sql
at the begining I remembered that cron does not know the binaries path so I changed the script to this one:
/oracle/ora8/bin/sqlplus user/passwd @script1.sql
.
.
and so on.
It didnt work as well.
Later on I wrote tha absolute path of the queries:
/oracle/ora8/bin/sqlplus us/pass @/home/script1.sq
.
.
and so on, every change I did every test I performed with the "at" command and it worked out pretty fine, but if I use crontab it doesnt.
and the message was related to the sp1<lang>.msb file Im using US as lenguaje, so the file to be search must be ps1us.msb it is located at
$ORACLE_HOME/sqlplus/mesg
(oracle/ora8/sqlplus/mesg)
I hope it helps.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
i have a scripts that update an SQL DATABASE using sqlplus command.
when i run it in a interactive mode its ok but when try to run it using the crontab i get an a messege :
"Must be attached to terminal for 'am I' option"
(there is no "who am i" command in the script)
and the DB... (4 Replies)
Discussion started by: dorilevy
4 Replies
2. Shell Programming and Scripting
Problem:
I have a crontab and when it kicks off, xxx.sh shell script is called. Which has a nohup sqlplus session call. Problem is sql does not get executed and a text file is not getting created. Only a empty log file is getting created. Are there any constraints for crontab to open a sql... (6 Replies)
Discussion started by: radhika
6 Replies
3. Shell Programming and Scripting
Hi,
I wrote a script shell whose function is to make a remove of directories depending on the result of a query on Oracle database.
When I execute my script shell directly from unix, it works fine. But, when I put it in a line of a crontab, it doesn't work no more, because of the sql... (1 Reply)
Discussion started by: tbeghain
1 Replies
4. Shell Programming and Scripting
Hi-
I am trying to achieve the following in a script so I can schedule it on a cron job. I am fairly new to the unix environment...
I have written a shell script that reads a flat file and loads the data into an Oracle table (Table1) via SQLLDR. This Works fine. Then, I run a nested insert... (5 Replies)
Discussion started by: rajagavini
5 Replies
5. Shell Programming and Scripting
How do I dynamically assign the below output to unix shell variables
so I can build a menu in a shell script?
Example:
var1 = 1 var2= SYSTEM
var3 = 2 var4= UNDOTBS1
and so on, then in the shell script I can use the variables to build a menu.
set serveroutput on
declare... (2 Replies)
Discussion started by: djehres
2 Replies
6. UNIX for Dummies Questions & Answers
Hi guys,
I am new on here, I have a function in oracle that returns a specific value:
create or replace
PACKAGE BODY "CTC_ASDGET_SCHED" AS
FUNCTION FN_ASDSCHEDULE_GET
RETURN VARCHAR2
AS
BEGIN
DECLARE
ASDSchedule varchar2(6);
ASDComplete... (1 Reply)
Discussion started by: reptile
1 Replies
7. Shell Programming and Scripting
Hi!
I would like to do a single connection to sqlplus and execute some querys.
Actually I do for every query one connection to database
i.e
echo 'select STATUS from v$instance;
exit' > $SQL_FILE
sqlplus user/pass@sid @$SQL_FILE > $SELECT_RESULT
echo 'select VERSION from v$instance;... (6 Replies)
Discussion started by: guif
6 Replies
8. UNIX for Advanced & Expert Users
Hi Experts:
I have a shell script that's kicked off by cron. Inside this shell script, I need to kick off two or more oracle sql scripts to process different groups of tables. And when both sql scripts are done, I will continue in the shell script to do other things like checking processing... (3 Replies)
Discussion started by: huasheng8
3 Replies
9. UNIX for Dummies Questions & Answers
Hi guys today i'll bring to you a new problem that i need to execute.
So what i need to do it's create a script that:
conect to some database
logon
run a .sql script
logoff
and close the connection
after that, put this script on the crontab
To set up the crontab it's ok for me, i think... (3 Replies)
Discussion started by: Newer
3 Replies
10. Shell Programming and Scripting
Hi All,
I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise.
Eg :
Select 'Query 1 output' from dual;
Select 'Query 2 output' from dual;
I want to... (3 Replies)
Discussion started by: Rokkesh
3 Replies
LEARN ABOUT SUSE
set::crontab
Crontab(3) User Contributed Perl Documentation Crontab(3)
NAME
Set::Crontab - Expand crontab(5)-style integer lists
SYNOPSIS
$s = Set::Crontab->new("1-9/3,>15,>30,!23", [0..30]);
if ($s->contains(3)) { ... }
DESCRIPTION
Set::Crontab parses crontab-style lists of integers and defines some utility functions to make it easier to deal with them.
Syntax
Numbers, ranges, *, and step values all work exactly as described in crontab(5). A few extensions to the standard syntax are described
below.
< and >
<N selects the elements smaller than N from the entire range, and adds them to the set. >N does likewise for elements larger than N.
! !N excludes N from the set. It applies to the other specified range; otherwise it applies to the specified ranges (i.e. "!3" with a
range of "1-10" corresponds to "1-2,4-10", but ">3,!7" in the same range means "4-6,8-10").
Functions
new($spec, [@range])
Creates a new Set::Crontab object and returns a reference to it.
contains($num)
Returns true if $num exists in the set.
list()
Returns the expanded list corresponding to the set.
The functions described above croak if they are called with incorrect arguments.
SEE ALSO
crontab(5)
AUTHOR
Abhijit Menon-Sen <ams@toroid.org>
Copyright 2001 Abhijit Menon-Sen <ams@toroid.org>
This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.12.1 2008-07-30 Crontab(3)