Job Runtimes by AWK


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Job Runtimes by AWK
# 1  
Old 06-06-2011
Job Runtimes by AWK

Hi ,

I need to find runtime of jobs.

I have written below script to get start and end times for a list of jobs.

Code:
#!/bin/bash
 
InputFile_Name=/var/tmp/cgk/pre2_oper_status_7amcheck_jobs
if [ ! -f $InputFile_Name  ]
then
  echo "File: $InputFile_Name  doesn't exist , Pls check & run again"
  echo "Exiting the script"
  exit 1;
fi
while read Job_Name
do
  if [ ! -z $Job_Name ]
  then
        len=`echo $Job_Name | awk  '{print length }'`
          if [ $len -ge 24 ]
          then
                autorep -j $Job_Name  -w | grep -i $Job_Name |  awk '{ print $1 "\t\t\t\t   " $2 " " $3 " " $4 " " $5 " " $6 }'
          else
                autorep -j $Job_Name  -w | grep -i $Job_Name |  awk '{ print $1 "\t\t\t\t\t\t " $2 " " $3 " " $4 " " $5 " " $6 }'
          fi
  else
     echo ""
  fi
done  < $InputFile_Name
echo ""
exit 0

Output :--

Code:
jobname1        04/06/2011 09:33:37 04/06/2011 09:34:04 SU
jobname2        04/06/2011 09:51:33 04/06/2011 10:02:28 SU
jobname3        04/06/2011 09:51:37 04/06/2011 10:08:56 SU


I am trying to use script in below link

https://www.unix.com/shell-programmin...g-entries.html

But i am not able to get the run times of each job in HH:MIN:SEC

Can some one assist on this to get run times of each job.
# 2  
Old 06-06-2011
The awk you have referred uses different format, try this one,
Code:
user@tioman> (/home/user) $ cat time.awk
{
split($2,sdate,"/")
split($3,stime,":")
split($4,edate,"/")
split($5,etime,":")

s_secs=mktime(sdate[3]" "sdate[2]" "sdate[1]" "stime[1]" "stime[2]" "stime[3])

e_secs=mktime(edate[3]" "edate[2]" "edate[1]" "etime[1]" "etime[2]" "etime[3])

print $1,strftime("%T",e_secs-s_secs)


}
You have new mail in /var/spool/mail/user
user@tioman> (/home/user) $ awk -f time.awk test.txt
bname1 07:30:27
jobname2 07:40:55
jobname3 07:47:19
user@tioman> (/home/user) $

I have a different time zone set here, so my output has 7 hrs 30 mins plus in each one.

please post your output as well.
# 3  
Old 06-06-2011
Job Runtimes by AWK

Hi Kumaran,

Instead of writing awk script is there any way we can do on the command line like i am able to print other columns. ??
awk '{ print $1 "\t\t\t\t " $2 " " $3 " " $4 " " $5 " " $6 }'
# 4  
Old 06-06-2011
Taking time difference isn't easy job atleast in unix prompt, so you need few lines of code to do these, awk script isn't big thing and still you can keep it and change the below line

Code:
 autorep -j $Job_Name  -w | grep -i $Job_Name |  awk '{ print $1 "\t\t\t\t   " $2 " " $3 " " $4 " " $5 " " $6 }'

to
Code:
 autorep -j $Job_Name  -w | grep -i $Job_Name |  awk '{ print $1 "\t\t\t\t   " $2 " " $3 " " $4 " " $5 " " $6 }'|awk -f time.awk

This should work out for you
# 5  
Old 06-06-2011
Do you want the time elapsed between start and end time of each job??

regards,
Ahamed
# 6  
Old 06-06-2011
Yes Ahamed
# 7  
Old 06-06-2011
did you try using time command, I'm not sure though what you mean by job here .
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Autosys Job: Job did not start

I have submitted an autosys job and force start it. Autosys hit the job 4 times to restart but it did not start and finally I terminate the job. Any idea why the job did not start. Below is the code I executed. 1214 missun0ap /export/home/bzn97r/develop/dswi/jil$ sendevent -E FORCE_STARTJOB... (0 Replies)
Discussion started by: jnrohit2k
0 Replies

2. Shell Programming and Scripting

autosys job configuration for job failure.

We need to configure autosys that when a job fails continously for 3 times, we need to call another job. Is this possible in Autosys, or can anyone advice on the alternative. (2 Replies)
Discussion started by: sangea
2 Replies

3. Shell Programming and Scripting

Script to Start a Job after finding the Old job completed

Hi Experts, I need a script advice to schedule 12 jobs ( SAS Codes execute back ground ). Algorithem: 1. Script checks first job. 2. Finds first job is done; invoke second job. 3. finds second job is done; invoke third job. .. Request you to please assist. (3 Replies)
Discussion started by: Jerald Nathan
3 Replies

4. Advertise with Us

Looking for job

Hi, i just got laid off :D, not fun, but i have a very wierd feeling. I want to continue my cloud computing exciting work and I am looking for takers. A brief of my skills is 10 years exp in dev client server apps on unix platform using java/c++. 3 years of ruby. last one year of amazon ec2 and... (1 Reply)
Discussion started by: linuxpenguin
1 Replies

5. Shell Programming and Scripting

PL SQL Runtimes different in Shell script log

Hi, This run times recorded in UX shell script appears peculiar to me. The PL / SQL stored procedure is called through sqlplus from UNIX shell script and then a log is created with run times recorded. The first set has actually taken 6 Hrs but the recorded time indicates it is only 2 Hrs and... (1 Reply)
Discussion started by: Nanu_Manju
1 Replies

6. Shell Programming and Scripting

Need logic for check automated Job work in awk or SED.

I have a Java program which will automatically trigger some scheduled job to update Db or some other work. I am tracking the jobs with log messages and finding out it is properly run or not. I want to write a script to capture it correctly on time. Say Job1 is running on 15, 30, and 45 every... (5 Replies)
Discussion started by: senthilkumar_ak
5 Replies

7. UNIX for Dummies Questions & Answers

How to insert child job under a box job?

I have this box job and it contains only one job under it which is to load a file. I want to insert a "File Watcher", "Copy File" to it? Have no clue how to do that...any help plzzz... (4 Replies)
Discussion started by: xejatt
4 Replies

8. Shell Programming and Scripting

Job dependent on other job

Hi All I am trying to run one command ie grep but I want it should execute only after the completion of a shell script has finished. eg Following is my script : java -mx64m $JAVA_OPTS -Dant.home=$ANT_HOME -classpath $_CLASSPATH org.apache.tools.ant.Main -verbose -buildfile /opt/bea/wls... (4 Replies)
Discussion started by: pankajkrmishra
4 Replies

9. Solaris

killing a unix job after the job process gets completed

Hi, Thanks in advance. i need to kill a unix background running job after that job process completes. i can kill a job by giving the following unix command kill -9 processid how to kill the job after the current process run gets completed ? Appreciate your valuable help. Thanks... (7 Replies)
Discussion started by: dtazv
7 Replies

10. Shell Programming and Scripting

killing unix job after the job process completes

Hi, Thanks in advance. i need to kill a unix background running job after that job process completes. i can kill a job by giving the following unix command kill -9 processid how to kill the job after the current process run gets completed ? Appreciate your valuable help. ... (1 Reply)
Discussion started by: dtazv
1 Replies
Login or Register to Ask a Question