Hi Everyone,
I was wondering is there any possibility to automate the manual way of checking logs in Datastage Director. Hence Im now involved in finding out a way.
Wat im trying to do is... To develop some script (either Java or VB) which asks my job name so that it automatically logs in DS director and retrieves the status of Jobs in either XML or notepad etc,..
Please help me guys..
VB script needed for retrieving logs
Moderators: chulett, rschirm, roy
Welcome.
Searching will reveal a ton of questions and information on this topic already here. However... why Java or VB? The API to retrieve any information of that nature is dsjob at the command line and its use has been discussed here many, many times. A 'simple' approach would be to leverage dsjob and its options via batch (or VB or Java) to gather that information. Sounds like you may just need to use -jobstatus.
For a more formal automated approach, search here for discussions of 'ETLStats'.
Searching will reveal a ton of questions and information on this topic already here. However... why Java or VB? The API to retrieve any information of that nature is dsjob at the command line and its use has been discussed here many, many times. A 'simple' approach would be to leverage dsjob and its options via batch (or VB or Java) to gather that information. Sounds like you may just need to use -jobstatus.
For a more formal automated approach, search here for discussions of 'ETLStats'.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers