Hi All,
Is there anyway to get the elapsed time of each and every instance of a sequencer. I know can get it from the director but can I find it in any file or table where this information is stored.
Pls advice.
Elapsed time
Moderators: chulett, rschirm, roy
TRY this out.
u can do it by running dsjobreport as an after job routine in your parallel job this will create log information in an XML file. create an other job which reads this xml file (XML file input stage) import the metadata using xml metadata importer when u import u can see the elapsed time,instance id which u can forward to a table or a sequence file.This XML job will be included in your sequence job which will be running for each and every parallel job u will be running in the sequencer.
Sree
Another way for you to do this, especially if you have a specific table where you wish to write the data, is to write a DataStage job which, as either a Job Control basic code or a DataStage function call, use the various DSGet....() function calls to get the information you are looking for and then can write this information to a sequential, hash, or table file.