Shell Programming and Scripting

Code:

while [ `ps axo cmd|grep "phantom DSD.RUN #JobName." 
|grep -iv -e "grep" -e "SH -c"|cut -f3 -d " "|cut -f2 -d "."
|sort -i|head -1|grep -i #instance_Name#
|wc -l` -ne 1 ];do sleep 5; done

Hi,

We do run the ETL jobs via DataStage.
We do have 30 sequences which calls 1 update query.
Most of the time when the update query is run by many countries, the ETL job gets hang.

Becuase of this we have written a above script.

We do in the script i.,e if any job is running for a particular country, the next job will wait to finish the previous one.

Some cases like FVL, gfl, scf the script works fine.
but some cases like eas, bog, cld the scripts runs all the etl job at same time.

Here instance_Name is fvl, gfl, scf, eas, bog, cld.

Any modification/suggestion would be appreciated.

thank you

Moderator's Comments:

Please take time to spell correctly, use code tags and do not double post.

In order to get a quality reply, you should provide both sample input and output data.


---------- Post updated at 07:17 ---------- Previous update was at 07:08 ----------


In addition, posters should not cut-and-paste their problems in multiple internet forums, requesting solutions, all within the same day or few hours.

This same question was posted in the HPRC forums with the same subject (as the one closed earlier for double posting) "Subject: Unix Script" at Oct 26, 2010 15:09:02 GMT here.

Moderator's Comments:

I am closing this thread because the poster has posted in another forum, double posted the same question in these forums, and does not follow posting guidelines on formatting, code tags, descriptive subject text, etc.