oarresume(1) OAR commands oarresume(1)NAME
oarresume - resume a job in OAR batch scheduler.
SYNOPSIS
oarresume [--array][job_ids][--sql "sql syntax"][-V][-h]
DESCRIPTION
Ask OAR to change job_ids states into Waiting when it is Hold or in Running if it is Suspended.
OPTIONS --array
Resume array job(s) passed as parameter (all the sub-jobs of the given array job(s))
--sql
Resume 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), oarhold(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.
oarresume 2012-05-23 oarresume(1)
Check Out this Related Man Page
oarstat(1) OAR commands oarstat(1)NAME
oarstat - show information about jobs
SYNOPSIS
oarstat [-X|-Y|-J|-D|-f] [-j jobid|--array arrayid] [--sql SQL_properties] [-u user] [--array]
oarstat [-e|-p] [-j jobid | --array arrayid]
oarstat -s [-X|-Y|-J|-D] -j jobid
oarstat [-X|-Y|-J|-D] --gantt "YYYY-MM-DD hh:mm:ss, YYYY-MM-DD hh:mm:ss"
oarstat --accounting "YYYY-MM-DD, YYYY-MM-DD"
DESCRIPTION
This command is used to show information of jobs in OAR batch scheduler.
OPTIONS -f, --full
Very detailed display.
-j, --job job_id
Print information from a specific job.
-e, --events
Print job events only.
-p, --properties
Print job properties in the same format as in the $OAR_RESOURCE_PROPERTIES_FILE file on the nodes.
-s, --state
Print only the state of a specified job. It makes a minimal query to the database. It is optimized to allow scripting for example. Must
be used with -j.
-u, --user [login]
Print information for the current user or the one given. If used with --accounting, print a more detailed accounting report for the
user.
--array [array_id]
Toggle the visualization of array information on. If an array_id is provided, print information relative to the subjobs of the given
array job.
--sql
Restricts display with the SQL where clause on the table jobs (ex: "project = 'p1'")
-D, --DUMPER
Print result in DUMPER format.
-X, --XML
Print result in XML format.
-Y, --YAML
Print result in YAML format.
-J, --JSON
Print result in JSON format.
-g, --gantt "date_start,date_stop"
Print history of jobs and state of resources between two dates like "2006-03-30 13:49:27, 2006-04-30 13:49:27"
--accounting "date_start,date_stop"
Shows accounting information between two dates like "2006-03-30, 2006-04-30".
If --user is also used, more details are shown for this particular user.
Warning: the accounting table must be up to date. The update must be done at superuser level with the oaraccounting command.
-V, --version
Print OAR version number.
-h, --help
Print help message.
SEE ALSO oarprint(1), oarsub(1), oardel(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.
oarstat 2012-05-23 oarstat(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)
Hi,
I search all post...and no soluation about..if i would like to run a sql statement and output the result to txt file.
for example,
i usually run "sql" to logon the database and run select statement. Then I need to copy the output into the result.txt. Can I run the script to do this... (7 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,
Currently i have a .sql file 1.sql.
I need to pass that as a parameter through a shell script to the sqlplus inside the same shell script.
How I should I do.can anyone help me pls.
I have an req where I need to send the .sql file and the place where the script has to create a .csv... (9 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)
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)
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)