Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: need help with the unix script
Top Forums UNIX for Advanced & Expert Users need help with the unix script Post 302269279 by srikanths2s on Wednesday 17th of December 2008 09:07:15 AM
Old 12-17-2008
Bug need help with the unix script
Hi all,
Please help me with the issue im facing.

my client has a recquirement that unix script has to schedule the no.of jobs based on the value from the oracle table.for example if the table has a value of 20 the unix script has to schedule 20 jobs.im able to write the script to get the value frm the oracle table and from here im not able to make out how to proceed..please help me in this regard..please find the code i have written and help me in extending this script .


#!/bin/sh
var1=`sqlplus -s scott/tiger <<EOF
set head off;
select <column> from table;
exit;
EOF`
echo $var1
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

FTP script for sending a file from one unix directory to another unix server director

Hi, My local server is :/usr/abcd/ Remote server is :/Usr/host/test/ I want to send files from local unix directory(All files starting with O_999) to remote host unix directory. Can any body give me the Unix Shell script to do this. One more doubt: Shall we need to change the file... (1 Reply)
Discussion started by: raja_1234
1 Replies

2. Shell Programming and Scripting

ftp from windows to unix using a perl script on unix machine

i need to ftp a file from windows to a unix machine by executing a sript(perl/shell/php) from that unix machine.i can also use HTML and javascript to build forms. (3 Replies)
Discussion started by: raksha.s
3 Replies

3. Shell Programming and Scripting

(Urgent):Creating flat file using sql script and sqlplus from UNIX Shell Script

Hi, I need help urgently for following issue. Pls help me to resolve this issue. I am calling sql script file(file1.sql) from UNIX Shell Script(script1.ksh) using sql plus and trying to create flat file that contains all records returned from SQL query in SQL script(file1.sql) I given... (6 Replies)
Discussion started by: praka
6 Replies

4. UNIX for Advanced & Expert Users

Executing a shell script from windows;script present in unix

I need to execute a shell script kept in unix machine from windows. User id, password area available. For eg. There's a shell script wich moves all the logs kept in my home directory to a directory named LOGS. Now i need to get this done through windows; either using a batch file, or java... (4 Replies)
Discussion started by: rajneesh_kapoor
4 Replies

5. Shell Programming and Scripting

Need to write a script to reformat a file in unix but not familiar with unix

unix script must do the fiollowing open a file containing comma delimited records > each record contains 10 fields > removes the 2nd field and use that same field containing fields 2 to 10 the original record after fprocessing should containing fields 1 and 3 a new erecord must be... (10 Replies)
Discussion started by: dwightja
10 Replies

6. Shell Programming and Scripting

UNIX script to FTP file from UNIX server to windows

Hi, I am new to this subject.....Can someone please help me out with the script... unix usernm "sdhftst" unix pwd "chsd13" windows usernm "dfghtst" windows pwd "chsd13" path..../xxx/xxxxx/xxxxxx/xxxxxxx please can u get me a script...its only one file to get ftp. Thanks... (2 Replies)
Discussion started by: himakiran9
2 Replies

7. Shell Programming and Scripting

FTP from windows to unix server using unix shell script

Hi, Is it possible to ftp a huge zip file from windows to unix server using unix shell scripting? If so what command i need to use. thanks in advance. (1 Reply)
Discussion started by: Shri123
1 Replies

8. Shell Programming and Scripting

How can i run sql queries from UNIX shell script and retrieve data into text docs of UNIX?

Please share the doc asap as very urgently required. (1 Reply)
Discussion started by: 24ajay
1 Replies

9. Shell Programming and Scripting

How to pass Oracle sql script as argument to UNIX shell script?

Hi all, $ echo $SHELL /bin/bash Requirement - How to pass oracle sql script as argument to unix shell script? $ ./output.sh users.sql Below are the shell scripts and the oracle sql file in the same folder. Shell Script $ cat output.sh #!/bin/bash .... (7 Replies)
Discussion started by: a1_win
7 Replies

10. Shell Programming and Scripting

Downloading hdfs file to local UNIX through UNIX script

Hi All , I am very new to unix script.I am aware of unix commands but never put together in unix script level.If any one can suggest me technical guidance in the below scenario that will highly beneficial. Data have been already migrated from mainframe to Hadoop file system(HDFS).HDFS server... (15 Replies)
Discussion started by: STCET22
15 Replies

LEARN ABOUT DEBIAN

ns_job

ns_job(3aolserver)					    AOLserver Built-In Commands 					ns_job(3aolserver)

__________________________________________________________________________________________________________________________________________________

NAME

       ns_job - commands

SYNOPSIS

       ns_job option ?arg arg ...?

       ns_job create ?-desc description? queueId ?maxthreads?

       ns_job queue ?-detached? queueId  script

       ns_job wait ?-timeout seconds:microseconds? queueId  jobId

       ns_job waitany ?-timeout seconds:microseconds? queueId

       ns_job cancel queueId jobId

       ns_job delete queueId

       ns_job jobs queueId

       ns_job queues

       ns_job threadlist

       ns_job queuelist

       ns_job joblist

       ns_job genid

_________________________________________________________________

DESCRIPTION

       ns_job manages a thread pool and a set of named "queues". Queues have a max number of threads and when the current number of running thread
       reaches "max" then jobs are queued.

       New threads are created when there are less than  maxthread  number of idle threads.

OPTIONS

       create

	      create ?-desc description? queueId ?maxthreads?

	      Create a new job queue called queueId. If maxthreads is not specified, then the default of 4 is used.

       queue

	      queue ?-detached? queueId script

	      Add a new job to the queue. If there are less than maxthreads current running then the job will be started. If there are	maxthreads
	      currently running then this new job will be queued.

	      If detached is true, then the job will be cleaned up when it completes; no wait will be necessary.

	      The new job's ID is returned.

       wait

	      wait ?-timeout seconds:microseconds? queueId jobId

	      Wait for the specified queued or running job to finish. wait returns the results of the script.

	      An error is thrown if the specified timeout period is reached.

       waitany

	      waitany ?-timeout seconds:microseconds? queueId

	      Wait for any job on the queue complete.

	      An error is thrown if the specified timeout period is reached.

       cancel

	      cancel queueId jobId

	      Remove  the  specified job from the queue. If the job is currently running, then the job will be removed from the queue when it com-
	      pletes.

	      1 (true)	is returned if the job is currently running and can not be cancelled.

       delete

	      delete queueId

	      Request that the specified queue be deleted. The queue will only be deleted when all jobs are removed.

       jobs

	      jobs queueId

	      Return a list of the job IDs.

       queues

	      Returns a list of the queues IDs.

       threadlist

	      Returns a list of the thread pool's fields.

	      maxthreads
		     Max number of threads for all the queues in the thread pool.

	      numthreads
		     Number of allocated threads.

	      numidle
		     Number of currently idle threads.

	      req
		     stop
			    The thread pools is being stopped. This probably means that the server is shutting down.

       queuelist

	      Returns a list of the queues. A queue has the following fields:

	      name
		     Name of the queue.

	      desc
		     Description of the queue.

	      maxthreads
		     Max number of threads to run for this queue.

	      numrunning
		     Number of currently running jobs in this queue.

	      REQ
		     delete
			    Someone requested this queue be deleted. Queue will not be deleted until all the jobs on the queue are removed.

       joblist

	      Returns a list the jobs in the specified queue. A job has the following fields:

	      id
		     Job's ID

	      state
		     scheduled
			    The job is schedule to run.
		     running
			    The job is currently running.
		     done
			    The job is has completed.

	      results
		     If the job has completed, then this field will contain the results. If the job is running or scheduled to run, then this will
		     contain the script.

	      code
		     When the job is done, this will contain the return code.
			    Codes
				    TCL_OK
				    TCL_ERROR
				    TCL_RETURN
				    TCL_BREAK
				    TCL_CONTINUE

	      TYPE
		      nondetached
		      detached

	      REQ
		      none
		      wait
		      cancel

       genid

	      Generate a new unique ID. This new ID can be used as the queue ID without conflicting with any other queue ID.

BUGS

SEE ALSO

       nsd(1), info(n)

KEYWORDS

       ns_job

AOLserver								4.0							ns_job(3aolserver)
All times are GMT -4. The time now is 09:48 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy