oarhold(1) OAR commands oarhold(1)NAME
oarhold - hold a job in OAR batch scheduler.
SYNOPSIS
oarhold [--array][job_ids][--sql "sql syntax"][-r][-h][-V]
DESCRIPTION
Ask OAR to not schedule jobs until oarresume command will be executed.
OPTIONS -r, --running
Manage not only Waiting jobs but also Running one (can suspend the job)
--array
Hold array job(s) passed as parameter (all the sub-jobs of the given array job(s))
--sql
Hold jobs which repond to the SQL where clause on the table jobs (ex: "project = 'p1'")
-V, --version
Print OAR version number.
-h, --help
Print help command message.
oarsub(1), oardel(1)oarstat(1), oarnodes(1), oarresume(1)COPYRIGHTS
Copyright 2008 Laboratoire d'Informatique de Grenoble (http://www.liglab.fr). This software is licensed under the GNU Library General Public License. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
oarhold 2012-05-23 oarhold(1)
Check Out this Related Man Page
oardel(1) OAR commands oardel(1)NAME
oardel - delete or checkpoint job(s).
SYNOPSIS
oardel [-c|-b][--array][job_ids][-h][-V]
DESCRIPTION
This command is used to delete or checkpoint job(s). Jobs are designed by their number.
OPTIONS -c, --checkpoint
Send the checkpoint signal designed from the "--signal" oarsub command option (default is SIGUSR2) to the process launched by the job
"job_id".
-s, --signal
Send the signal given as parameter to the process launched by the job "job_id".
-b, --besteffort
Tag specified jobs as besteffort (or remove it if they are already besteffort)
--array
Delete/checkpoint array job(s) passed as parameter (all the sub-jobs of the given array job(s))
--sql
Delete/checkpoint jobs which respond to the SQL where clause on the table jobs (ex: "project = 'p1'").
-V, --version
Print OAR version number.
-h, --help
Print help command message.
SEE ALSO oarsub(1), oarstat(1), oarnodes(1), oarhold(1), oarresume(1)COPYRIGHTS
Copyright 2008 Laboratoire d'Informatique de Grenoble (http://www.liglab.fr). This software is licensed under the GNU Library General Public License. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
oardel 2012-05-23 oardel(1)
if;
sqlplus /nolog <<EOF
conn / as sysdba
spool /tmp/start.out
@/oracle/home/start.sql
spool off
exit
EOF
fi
For this code i am getting error:
Test.sh: syntax error at line 7 : `<<' unmatched (8 Replies)
I am looking to loop round a load of files and execute each in sqlplus, I have looked at the forum to see what was posted in the past, but most of the examples seem to use the sql being passed in through the script, which is not really what I am looking for, can someone tell me if the code below is... (9 Replies)
Hi,:cool:
I have several file names with .sql extension and i need to replace them with .plb extensiom.
ex:p_ebiz_vehlog.sql-->p_ebiz_vehlog.plb.
any idea pls.
cheers
RRK (7 Replies)
i am new working with hp-ux but i had to because of my job.
so i want to execute some sql scripts but
when i call sqlplus to run them it responds
/sbin/sh: sqlplus not found.
i have oracle 8.1.7 installed.
what should i do
sorry if this sounds too easy but i am now learning.
The same... (13 Replies)
Hi,
I need to get the value from the table using the sql command and store this value into the unix variable so that i can use this value for furthure use..
Please can any body help me in this regards
Thanks & Regards
Abdul Hafeez Shaik (17 Replies)
Hi -
I am looking for a replacing a string in a in multiple *.sql files in directory with a new string without using a temporary file
Normally I can use sed command as below
for W in ls `FILE*.sql`
do
sed 's/OLD/NEW/g' $W > TEMPFILE.dat
mv TEMPFILE.dat $W
done
But Here in my... (9 Replies)
My sql file xyz_abc.sql in this file there are multiple sql block in this block I need to find the following block
rem Subset Rows (&&tempName.*)
CREATE VIEW &&tempName.* AS
SELECT *
FROM &&tempName.*
WHERE f is not null
and replace with following code
rem Subset Rows... (9 Replies)
Hello Friends,
Please help me to schedule a job through crontab....
How do I schedule a job on every 1st and 3rd Thursday of the every month at 12:00 ..........:wall:
Thanks in Advance....:)
Thanks,
Ajit (12 Replies)
Hi all,
I have declared an array in unix as below.
#!/bin/ksh
arr=()
for i in {0..4}
do
arr=$i;
done.
i want to insert these array variables into the oracle table.can you guys please help me in doing this. my code is as below.
value=`sqlplus -s fos/fos << EOF
begin
for j in... (10 Replies)
i have 3 sqls , sql 1 and sql 2 shuld run in parallel , but sql 3 should run after completion f sql1 nd sql2, my code is as below, please suggest the changes
sqlplus username1/password1@DB1 @sql >> log1 &
sqlplus username2/password2@DB2 @sql2 >> log1 &
how can i execute the... (7 Replies)
hey i am using this code to connect to sql , store the value in variable and then
compare it with another variable after some time by executing the same query
but the desired result is not coming
#!/bin/bash
val=$(sqlplus -s rte/rted2@rel76d2 <<ENDOFSQL
set heading off
set feedback off... (11 Replies)
I tried executing set of queries from shell script but not able to capture the input query in the log file,but the input query is not displayed along with output. Only the outputs are being captured in the log file. Is there a way to capture the input query along with the corresponding input?? (8 Replies)
Hi Friend,
I have one file in which some number are mentioned and number of lines are vary every time
And i need to pass that number to my sql command from script.
Suppose i have file acc.txt
45456546456
45464564565
67854353454
67657612132
Number of records are vary every time.... (20 Replies)
Can anyone please assist me?
I have attached 2 input files and one output file. I need to generate the sql update statements using the above 2 input files. if inputfile2 has 5 rows, then we should generate 5 update statements because column1 is unique. inputfile1 and inputfile2 may contain more... (10 Replies)
Hi All,
We have main directory called "head"
under this we have several sub directories and under these directories we have sub directories.
My requirement is I have to find the SQL files which are having the string "procedure" under "head" directory and sub directories as well.
And create... (14 Replies)