Shell Programming and Scripting

Hi,
I have a project which i need to automate some manual work. We have a 100 jobs in Linux and Unix environment. We do job monitoring daily. that is taking more that 2 to 3 hrs for us because we use autorep -j <jobname> command for each and every job. That takes more time for us to do.
We have to automate it.
We have a list of jobs in xcel/csv files. We have added this command in all jobs like below.
autorep -j job_one
autorep -j job_two
.
.
.
autorep -j job_one_hundred
If i am running this command i am getting below output.
bash-2.05$ autorep -j gxxxxxxx
Job Name Last Start Last End ST Run Pri/Xit
____________________________ ____________________ ____________________ __ _______ ___
gxxxxxxx(box job) 11/08/2012 16:00:08 11/08/2012 16:03:43 SU 18472621/1
gyyyyyy(command job) 11/08/2012 16:00:49 11/08/2012 16:01:01 SU 18472621/1
Now my requirement, i have to create shell script. It should read all autorep command from xcel/csv sheet, Run autorep command and output should store in xcel/csv, send that mail to specific group. Output Excel should have Job Name(command and box jobs), Last Start, Last End and ST of all jobs and should display.
How could i achive this?

You can write a while loop to read all autorep command, execute, write status to a file:-

Code:

print "Job Name, Last Start, Last End, ST" > job_monitor.csv
while read autorep_cmd
do
   $autorep_cmd | awk 'NR>2 { print $1, $2 " " $3, $4 " " $5, $6 } ' OFS="," >> job_monitor.csv
done < job_cmd.csv

cat job_monitor.csv | mailx -s "Job Monitor" someone@domain.com

I am new to unix.
Could you please give me exact code for this?

The code which I provided will work, just replace file name: job_cmd.csv with the CSV file name that you have with the list of autorep commands.

i am getting blank file as output.

Code:

#!/bin/sh
 
print "Job Name, Last Start, Last End, ST" > job_monitor.csv
while read autorep_cmd
do
   $autorep_cmd | awk 'NR>2 { print $1, $2 " " $3, $4 " " $5, $6 } ' OFS="," >> job_monitor.csv
done < job_cmd.csv

What do you have in job_cmd.csv file? Can you please post the output of below two commands:-

Code:

head job_cmd.csv

Code:

head job_monitor.csv

Please use code tags when posting code segments.

Code:

 
$ head job_cmd.csv
autorep -j job_name_xxxxxxx
$ head job_monitor.csv
Job Name, Last Start, Last End, ST $