02-12-2004
running .sh, .sql .etc how to?
hi all
yes, I am a beginner in Unix,-sun solorais--V8...
what is the command to run files....
single and batch jobs....any help would be great...
Cheers
ps...i know running files in Sqlplus on Unix prompt, I can use the @' sign...but how does this work..
Cheers
E
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. UNIX for Dummies Questions & Answers
Hi Folks,
I have created a number of unix scripts that i can run from the scheduler on a server-side application that we use (Chordiant Marketing Director). All scripts are working except one. This last script is a user load script which first truncates a table and then loads it using a flat... (2 Replies)
Discussion started by: jibbadiah
2 Replies
3. UNIX for Dummies Questions & Answers
All,
I have a 10g PL/SQL procedure that needs to be run via a unix script. How could such a script be developed.
Thanks
Aditya. (1 Reply)
Discussion started by: kingofprussia
1 Replies
4. UNIX for Dummies Questions & Answers
Hi All
I have this sql script lets say abc.sql
How to run this script with this following conditions :
1 - The script will run everyday and mailx to me by using crontab
2 - The output of this script will be saved to someplace and attach with mailx OR can be display as email text and then send... (3 Replies)
Discussion started by: adzuanamir
3 Replies
5. Shell Programming and Scripting
Hi,
I need confirmation whether the same functionality exists when running the sql's.
For ex. let us consider there exists a sql file with name june.When running in sql mode does:
@june.sql and start june.sql does the same functionality.
Someone help me.
Thanks
Ashok. (1 Reply)
Discussion started by: Ashok_oct22
1 Replies
6. Shell Programming and Scripting
Hi,
I would be really thankful, if anyone could help me out with this,since i am very new to this shell scripting.
I have 6 sql scripts that i am trying to run in unix across db2.
i want the scripts to be executed as follows,
script_1 should be executed first.
Then... (4 Replies)
Discussion started by: jnimz
4 Replies
7. Shell Programming and Scripting
In c:/zaheer/123-456/sql/ folder i have below 7 sql files.
cv_abc_a.sql
cv_abc_b.sql
cv_abc_c.sql
vtemp_d.sql
vtemp_e.sql
cv_abc_f.sql
Exviews.sql
In Exviews.sql file i have mentioned all cv and vtemp files to run like
start ${SQLDIR}/cv_abc_a.sql
start ${SQLDIR}/cv_abc_b.sql... (1 Reply)
Discussion started by: Zaheer.mic
1 Replies
8. UNIX for Dummies Questions & Answers
Hi,
Could you please help me on this.
I have bulk of queries written in text file. I want to use those queries and want to execute from UNIX.
I don't want to run this file as a sql file as this file will change every week.
I want to run it in my environment as bulk sql statement from text... (1 Reply)
Discussion started by: abhii
1 Replies
9. Shell Programming and Scripting
RHEL 6.2/Bash shell
root user will be executing the below script. It switches to oracle user logs in using sqlplus and tries to
run the below UPDATE statement. All the commands after su -c are enclosed in a single quote delimited by semicolon.
The execution has failed because the quotes... (3 Replies)
Discussion started by: omega3
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 OSF1
queuedefs
queuedefs(4) Kernel Interfaces Manual queuedefs(4)
NAME
queuedefs - Queue description file for at, batch, and cron commands
DESCRIPTION
The queuedefs file describes the characteristics of the queues managed by cron or specifies other characteristics for cron. Each noncom-
ment line in this file describes either one queue or a cron characteristic. Each uncommented line should be in one of the following for-
mats.
q.[njobj][nicen][nwaitw] max_jobs=mjobs log=lcode
The fields in these lines are as follows: The name of the queue. Defined queues are as follows: The default queue for jobs started by at
The default queue for jobs started by batch The default queue for jobs run from a crontab file
Queues d to z are also available for local use. The maximum number of jobs that can be run simultaneously in the queue; if more
than njob jobs are ready to run, only the first njob jobs will be run. The others will be initiated as currently running jobs ter-
minate. The nice(1) value to give to all jobs in the queue that are not run with a user ID of superuser. The number of seconds to
wait before rescheduling a job that was deferred because more than njob jobs were running in that queue, or because the system-wide
limit of jobs executing (max_jobs) has been reached. The maximum number of active jobs from all queues that may run at any one
time. The default is 25 jobs. Logging level of messages sent to a log file. The default is 4. Defined levels are as follows:
level-code level
0 None
1 Low
2 Medium
3 High
4 Full
Lines beginning with # are comments, and are ignored.
EXAMPLES
The following file specifies that the b queue, for batch jobs, can have up to 50 jobs running simultaneously; that those jobs will be run
with a nice value of 20. If a job cannot be run because too many other jobs are running, cron will wait 60 seconds before trying again to
run it. All other queues can have up to 100 jobs running simultaneously; they will be run with a nice value of 2. If a job cannot be run
because too many other jobs are running cron will wait 60 seconds before trying again to run it. b.50j20n60w
The following file specifies that a total of 25 active jobs will be allowed by cron over all the queues at any one time, and cron will log
all messages to the log file. The last two lines are comments that are ignored. max_jobs=25 log=4 # This is a comment # And so is this
FILES
Main cron directory The default location for the queue description file.
RELATED INFORMATION
Commands: at(1), cron(8), crontab(1), nice(1)
delim off
queuedefs(4)