Query Datastage Repository

uegodawa · Post by **uegodawa** » Mon May 01, 2006 1:12 pm

Hi,
I've read lot of posting about the above topic and couldn't find am answers for my questions. Does anybody knows how to
1. Make a batch file to execute a TCL commands
2. Which Repository tables should I query for information like [data stage ]job creaion date, last modified date and job logs.
3. Can I dump output of the above query into a plan text file which I can open from notepad ?
If you've already faced similar situations and if you've any answers for the above question, please let me know.
many thanks !

ray.wurlod · Post by **ray.wurlod** » Mon May 01, 2006 2:34 pm

Welcome aboard. :D
1. Save one or more commands from the history stack in the Administrator client's Command window.
2. DS_AUDIT for date/time created, RT_LOGnnn for the log. Search the forum for more information - it is there.
3. Yes. Again, it's definitely been posted in the past.