Hello all,
After searching in Server forum and with no success, I'm posting my questions
1) Is there a way to find the path of a job, in Designer, using a UNIX script?
I do the following manual steps in UNIX shell
- uv
- SELECT * FROM DS_JOBS WHERE NAME = 'test1'
2) Is there a way to use the above command in a DataStage job and write the output to a text file?
Thanks in advance for your time
Find location of a job using UNIX script or DS server job
Moderators: chulett, rschirm, roy
Clarify for us exactly what you mean by "the path of a job". They all live in their respective projects, are you unsure where those are? What are you planning to use this "path" for - answering that may lead us to providing you with a better / more proper solution.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Craig,
We have around 700 jobs in more than 20 directories(with several sub-directories inside them) in a project in Designer. When a job abends I locate it using the steps mentioned in my previous post. Then open Designer, debug and restart it.
So I was wondering if there is a way to run UV commands from UNIX shell script instead of manually typing them in UV.
Hope I'm clear this time.
Thanks
We have around 700 jobs in more than 20 directories(with several sub-directories inside them) in a project in Designer. When a job abends I locate it using the steps mentioned in my previous post. Then open Designer, debug and restart it.
So I was wondering if there is a way to run UV commands from UNIX shell script instead of manually typing them in UV.
Hope I'm clear this time.
Thanks
Ah... the word you are looking for is 'Category', that must be what you are trying to dig out of the repository with your query. Sure, you can run those same commands from a script, it will actually be the same way (using TCL / UV) but you could parameterize and script it. Check this post for a discussion that should help:
viewtopic.php?t=129277
viewtopic.php?t=129277
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers