Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

oarresume(1) [debian man page]

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)
Man Page

15 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

connecting ....sql

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)
Discussion started by: dreams5617
8 Replies

2. Shell Programming and Scripting

any possible to run sql result and output to file

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)
Discussion started by: happyv
7 Replies

3. Shell Programming and Scripting

Sqlplus

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)
Discussion started by: LiquidChild
9 Replies

4. Shell Programming and Scripting

string replacemnet

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)
Discussion started by: ravi raj kumar
7 Replies

5. HP-UX

how can i call sqlplus?

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)
Discussion started by: theodore
13 Replies

6. Shell Programming and Scripting

To pass the .sql file as a paramter to sqlplus through shell programming

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)
Discussion started by: Hemamalini
9 Replies

7. Shell Programming and Scripting

How to redirect value from sql select statment to unix variable

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)
Discussion started by: abdulhafeez
17 Replies

8. Shell Programming and Scripting

find and replace a string in a file without the use of temp file

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)
Discussion started by: raghutapal
9 Replies

9. Shell Programming and Scripting

Find 5 lines and replace with 18 line in sql file where it contains multiple blocks.

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)
Discussion started by: Zaheer.mic
9 Replies

10. Shell Programming and Scripting

Using unix array in sql

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)
Discussion started by: Mukta
10 Replies

11. UNIX for Dummies Questions & Answers

How to compare to values returned from sql in shell scripting?

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)
Discussion started by: ramsavi
11 Replies

12. Shell Programming and Scripting

How to get sql command with output in files?

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)
Discussion started by: pallvi_mahajan
8 Replies

13. Shell Programming and Scripting

Passing variable from file to sql from script

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)
Discussion started by: pallvi_mahajan
20 Replies

14. Shell Programming and Scripting

Generate sql statement using shell scripting

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)
Discussion started by: vinus
10 Replies

15. Shell Programming and Scripting

How Create new directory and move files to that directory.?

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)
Discussion started by: ROCK_PLSQL
14 Replies