Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

awk output yields error: awk:can't open job_name (Autosys)

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting awk output yields error: awk:can't open job_name (Autosys)
# 15  
Old 02-07-2015
Please show us your complete current script (in CODE tags). There have been several suggestions on changes that could be made to your script and I am no longer sure that I know what your current script is doing.

Please show us the output that is being fed into the awk script (in CODE tags) from the autorep command. (Run the autorep command manually with the arguments it is given in the script and redirect the output to a file. Then show us the contents of that file.)
# 16  
Old 02-08-2015
ok Thanks a lot for your help,
Notes:
1. i dont see control characters in the scrip using cat -v
2. The input File calles MapaRep contains jobs names (arguments) that is read from autorep comamnd
3. Operating system SunOS (when use awk yileds error:
Code:
awk: syntax error near line 4
awk: illegal statement near line 4
awk: syntax error near line 5
awk: bailing out near line 5

whern using nawk:
Code:
nawk: empty regular expression
 input record number 1
 source line number 5

here you go

Code:
[#!/bin/ksh
#Validate Definition Autosys

while read i
   do   autorep -J $i -q
   done < /auto/autosys/MapaRep.txt | nawk 'BEGIN          {HD="insert_job\tcommand\tmachine"
                         print HD
                         MX=split(HD, COLHD)}
                        {gsub(/:/, "")}
         HD ~ $1        {O[$1]=$2}
         /exit/         {for (i=1; i<=MX; i++) printf "%s\t", O[COLHD[i]]
                         printf "\n"
                        }
        '
]

As an example i run autorep command manually:
Code:
[autorep -J ds_extra_nikira_usuarios -q > output1.txt]

then i show u the contents of that file:

Code:
autosys@proauto01 :PRO >more output1.txt


/* ----------------- ds_extra_nikira_usuarios ----------------- */

insert_job: ds_extra_nikira_usuarios   job_type: c
box_name: ds_rep_nikira
command: /archivos/Shells/dwhExtraNikiraUsuarios.sh
machine: proetldb01c
owner: dsadm@proetldb01c
permission: gx,wx,mx
date_conditions: 1
days_of_week: all
start_times: "13:00"
description: "Genera el plano hacia nikira USUARIOS_"
std_out_file: > /archivos/WRK_DWHEXT/ds_extra_nikira_usuarios.out
std_err_file: > /archivos/WRK_DWHEXT/ds_extra_nikira_usuarios.err
alarm_if_fail: 1
max_exit_success: 2
autosys@proauto01 :PRO >bc

Smilie
Last edited by Scrutinizer; 02-08-2015 at 02:12 PM.. Reason: CODE tags
# 17  
Old 02-08-2015
With that output from your autorep program, it is highly likely that nawk is very picky and doesn't like to match HD to the (empty) $1. Try putting /^$/ {next} into the line just above the HD match, and post the result.
# 18  
Old 02-08-2015
Thats awesome, thanks you very much, seem to be working but in the input files didnt shw up all job names for each line, what is missing ?


Code:
autosys@proauto01 :PRO >./test5_old.sh
insert_job      command machine
ds_extra_nikira_usuarios        /archivos/Shells/dwhExtraNikiraUsuarios.sh      proetldb01c
ds_extra_ordenesserv    /archivos/Shells/dwhExtraccion.sh       proetldb01c
ds_extra_recargajuste   /archivos/Shells/dwhExtraccion.sh       proetldb01c
ds_extra_score_dinamico /archivos/Shells/dwhExtraccion.sh       proetldb01c
ds_ftp_ciclo_migr_20    /archivos/Shells/PREP_CAMBIO_MIGRATORIO_PREPAGO_FTP.sh  proetldb01c
ds_ftp_ciclo_migr_23    /archivos/Shells/PREP_CAMBIO_MIGRATORIO_PREPAGO_FTP.sh  proetldb01c
ds_ftp_ciclo_migr_26    /archivos/Shells/PREP_CAMBIO_MIGRATORIO_PREPAGO_FTP.sh  proetldb01c
ds_mover_nikira_taps    /archivos/Shells/NikiraMoverTaps.sh     proetldb01c
ds_preactivados_sms     /archivos/Shells/wedoExtraccion.sh      proetldb01c
ds_prep_altasbajas_H1   /archivos/Shells/PREP_ALTASYBAJAS_H1.sh proetldb01c
autosys@proauto01 :PRO >more Mapa*
ds_extra_nikira_usuarios
ds_extra_ordenesserv
ds_extra_recargajuste
ds_extra_score_dinamico
ds_ftp_ciclo_migr_05
ds_ftp_ciclo_migr_09
ds_ftp_ciclo_migr_12
ds_ftp_ciclo_migr_16
ds_ftp_ciclo_migr_20
ds_ftp_ciclo_migr_23
ds_ftp_ciclo_migr_26
ds_mover_nikira_taps
ds_preactivados_sms
ds_prep_186_ciclo_01
ds_prep_186_ciclo_05
ds_prep_186_ciclo_09
ds_prep_186_ciclo_12
ds_prep_186_ciclo_16
ds_prep_186_ciclo_20
ds_prep_186_ciclo_23
ds_prep_186_ciclo_26
ds_prep_altasbajas_H1

Last edited by Scrutinizer; 02-08-2015 at 03:14 PM.. Reason: CODE tags for umpteenth time
# 19  
Old 02-08-2015
Look into the output files, and you'll see.
This User Gave Thanks to RudiC For This Post:
alexcol
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk runs and produces output but with error

When I run the awk below, I get an error message awk -v OFS='\t' '$(NF-1)=="Benign" || ($(NF-2) OFS $(NF-1))=="Likely Benign" {$(NF)=$(NF-2) OFS $(NF-1)} {print $0 }' input awk: cmd. line:1: (FILENAME=VUS FNR=8) fatal: attempt to access field -1 input Chr Start End Ref ... (6 Replies)
Discussion started by: cmccabe
6 Replies

2. Shell Programming and Scripting

Awk: Print Error While Redirecting output in multiple Files

Hi, I have a following code in which I am unable to redirect to multiple files. Can anybody please help with some corrections awk -F, '{ if ( substr($1,26,2)=="02" && substr($1,184,14)=="MTSCC_VALFIRST") { array1++ array2++ array3++ } else if (substr($1,26,2)=="03" &&... (4 Replies)
Discussion started by: siramitsharma
4 Replies

3. Shell Programming and Scripting

Awk: can't open error

Hi , In a directory i've the files in the following format pay:year:mon:11789604 pay:year:mon:17675644 --- and i need to get 4th part of the above file name so i used awk command in the below code #!/bin/ksh for test_data in pay* do txt_awk = awk -F':' '{print $4;}' $test_data ... (7 Replies)
Discussion started by: smile689
7 Replies

4. Shell Programming and Scripting

awk question : system output to awk variable.

Hi Experts, I am trying to get system output to capture inside awk , but not working: Please advise if this is possible : I am trying something like this but not working, the output is coming wrong: echo "" | awk '{d=system ("date") ; print "Current date is:" , d }' Thanks, (5 Replies)
Discussion started by: rveri
5 Replies

5. Shell Programming and Scripting

awk - Parsing Autosys JIL

I'm trying to modify the script given in post 7 of the following thread: 146564-need-parse-jil-file-into-excel-file.html. (Sorry, can't post the URL as I don't have enough posts.) The original script is as follows: awk -F ' *_]*: *' 'BEGIN ... (9 Replies)
Discussion started by: GnuScripter
9 Replies

6. Shell Programming and Scripting

Using awk with autosys autorep

Hi, How to get correct field/column from autosys autorep command. I'm using GNU/Linux I'm trying to get the difference of last end and last start and the status (ST). In awk, i get the following excluding the heading part $1 - jobname $2 - Last Start date $3 - Last Start time $4 - Last... (1 Reply)
Discussion started by: bobbygsk
1 Replies

7. Shell Programming and Scripting

awk output error while loop through array

Have built this script, the output is what I needed, but NR 6 is omitted. Why? Is it an error? I am using Gawk. '{nr=$2;f = $1} END{for (i=1;i<=f;i++) if (nr != i) print i, nr }' input1.csv >output1.csvinput1.csv 1 9 3 5 4 1 7 6 8 5 10 6 output1.csv > with the missing line number 6. 6 is... (5 Replies)
Discussion started by: sdf
5 Replies

8. Shell Programming and Scripting

help on awk---- need to assign the output of awk to a variable

hi i want to find the size of a folder and assign it to a variable and then compare if it is greater than 1 gb. i am doin this script, but it is throwing error.... #!/bin/ksh cd . | du -s | size = awk '{print $1}' if size >= 112000 then echo size high fi ERROR : (4 Replies)
Discussion started by: Nithz
4 Replies

9. Shell Programming and Scripting

Parse file using awk and work in awk output

hi guys, i want to parse a file using public function, the file contain raw data in the below format i want to get the output like this to load it to Oracle DB MARWA1,BSS:26,1,3,0,0,0,0,0.00,22,22,22.00 MARWA2,BSS:26,1,3,0,0,0,0,0.00,22,22,22.00 this the file raw format: Number of... (6 Replies)
Discussion started by: dagigg
6 Replies

10. Shell Programming and Scripting

scripting/awk help : awk sum output is not comming in regular format. Pls advise.

Hi Experts, I am adding a column of numbers with awk , however not getting correct output: # awk '{sum+=$1} END {print sum}' datafile 2.15291e+06 How can I getthe output like : 2152910 Thank you.. # awk '{sum+=$1} END {print sum}' datafile 2.15079e+06 (3 Replies)
Discussion started by: rveri
3 Replies
Login or Register to Ask a Question