reading jill file through datastage

[swapnilverma]

why dont you copy required info from autosys database to a static table and use that table ...

usually we do not have many changes in autosys ... if in case there is a change update the table....

need more info abt your requirement what do you want to achieve by reading jil file ?

[raji33]

Thanks swapnil for immediate response but i wanted to do this because these jobs are scheduled for next 30 days

[swapnilverma]

alternatively if only job name is required than you can use grep and cut -d:

unix commands to filter out desired input ...


autorep -j ur_autosys_server.% -q |grep insert_job |cut -d":" -f 2 >> file_name.txt

will write all job name to file_name.txt


hope this helps ...