1.May I know whether I can run the bat in batch file?I don't want to run from outside(before/after job routine) place.I like to call it from the job control.Can I do that?
2. My DOS bat file doesn't work properly when I call it on after job routine stage.
That DOS bat file suppose to delete the output files those have been created by that job itself.
Actually I like to del all those output files generated by that job after I finished it all so that I can use the append file option box while I generate the txt files for next time.Do you have any idea pls???
My senario is all follows.......
In my DS batch file,I called 4 jobs.
In 2 jobs,there are more than 2 files I have to import.I cannot use the hash file coz there may have duplicate key.So I try to import all those data to one output txt file.
There are 2 links to txt file.So I cannot use overwrite option and I try to use append option for the output txt file.
So everytime I run the job ,I suppose to clean the txt file before I import any data to there so that I can get the right data.
Now,do u have any idea???Help me pls.
![Sad :(](./images/smilies/icon_sad.gif)
Thanks,