Find location of a job using UNIX script or DS server job

[mavrick21]

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

[chulett]

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.

[mavrick21]

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

[chulett]

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

[mavrick21]

Craig, Thanks a ton!

I'll give it a try tomorrow and reply if I face issues else I'll mark this thread resolved.

Thanks again.

[mavrick21]

Craig,

It worked! Thanks. I'm marking this thread as resolved.

[chulett]