RE:Dos Script for getting Job info

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
kris18
Charter Member
Charter Member
Posts: 46
Joined: Mon Nov 13, 2006 9:53 am
Location: United States

RE:Dos Script for getting Job info

Post by kris18 »

Guys,
How can we get Job info from dos script.
For example if I want to run a query like SELECT CATEGORY FROM DS_JOBS WHERE NAME="EXAMPLE".. what utility can I use..

For Example we have a dos script for exporting a set of jobs by using the "dsexport" utility..

Thanks.
kris
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Is this the same question as this one?

Posting the same question in multiple fora does not get you any better answers, and annoys those who have perforce to re-read the same question.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

:!: Do not post the same question in multiple forums, it disturbs the natives. And there's no need to put "RE:" in your subject line, we already know that is what the question is "regarding".

(see? disturbed before I finished composing)
-craig

"You can never have too many knives" -- Logan Nine Fingers
kris18
Charter Member
Charter Member
Posts: 46
Joined: Mon Nov 13, 2006 9:53 am
Location: United States

Post by kris18 »

Sorry my Bad..I posted it by mistake in general and was checking the post in Server and did not find it...So I re posted it..Sorry Once Again
chulett wrote::!: Do not post the same question in multiple forums, it disturbs the natives. And there's no need to put "RE:" in your subject line, we already know that is what the question is "regarding".

(see? disturbed before I finished composing)
kris
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

That, in and of itself, is not a problem - as long as you delete the accidental post. And you can do that until someone comes along and replies to it. Like us. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
kris18
Charter Member
Charter Member
Posts: 46
Joined: Mon Nov 13, 2006 9:53 am
Location: United States

Post by kris18 »

ray.wurlod wrote:Is this the same question as this one?

Posting the same question in multiple fora does not get you any better answers, and annoys those who have perforce to re-read the same question.


Ray,
can you tell me how I need to proceed in achieving this..
Thanks
kris
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

He did - in the other thread.
-craig

"You can never have too many knives" -- Logan Nine Fingers
kris18
Charter Member
Charter Member
Posts: 46
Joined: Mon Nov 13, 2006 9:53 am
Location: United States

Post by kris18 »

chulett wrote:He did - in the other thread.
chulett,
I saw that reply ..Just want to know how I can do that..

(Urgh. Given that your server is UNIX, you are in for a messy path. You need to remotely execute a dssh command with in which you can execute the SQL.)

My question is how can i remotely execute a dssh command..

Thanks
kris
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Stick to one place - ask him over there.
-craig

"You can never have too many knives" -- Logan Nine Fingers
kris18
Charter Member
Charter Member
Posts: 46
Joined: Mon Nov 13, 2006 9:53 am
Location: United States

Post by kris18 »

chulett wrote:Stick to one place - ask him over there.

Thanks For the suggestion chulutt.I Posted the note over there.
Thanks once again.
kris
Post Reply