DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
techiexavier
Participant



Joined: 28 Feb 2012
Posts: 15
Location: Chennai
Points: 130

Post Posted: Sat Sep 15, 2012 12:37 am Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: TX
OS: Unix
Hi All,
I need to know what are the Datastage jobs (Only DS jobs not other DS processes) are running currently in the server. Is there any possibility to know the same from UNIX command. I need these details for some Admin activities. We are using DS 8x in UNIX server.
I have tried to check with the username in which we run our DS jobs, but I am not able to get exact details. Since it give all the process runs with the Id.
Please let me know how can we get the details..

TIA...
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 36605
Location: Denver, CO
Points: 186585

Post Posted: Sat Sep 15, 2012 7:41 am Reply with quote    Back to top    

What kind of 'details' are you looking for? You could certainly script something that leverages dsjob for this, looping thru projects then jobs to see which are running.

_________________
-craig

It's a scheme of devices to get at low prices all goods from cough mixtures to cables
Which tickled the sailors by treating retailers as though they were all veg-e-tables
Rate this response:  
Not yet rated
techiexavier
Participant



Joined: 28 Feb 2012
Posts: 15
Location: Chennai
Points: 130

Post Posted: Mon Sep 17, 2012 8:27 am Reply with quote    Back to top    

Hi,
I need details like Project name, Job name, User id (Optional - In which the job is running)...

Can you please tell me, how can we get the details with "dsjob"... I am not able to get details of curretly running jobs.

_________________
Thanks!
Xavi
Rate this response:  
Not yet rated
ArndW

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup

Joined: 16 Nov 2004
Posts: 15367
Location: Germany
Points: 86605

Post Posted: Mon Sep 17, 2012 9:03 am Reply with quote    Back to top    

Please go to your client PC where you have the DataStage clients installed, do a search for a program called "dsjob.exe" and execute the command "dsjob -help" in that directory. Alternatively, you could look at the documentation.
Once you have done that and experimented with simple commands such as "dsjob -lprojects" and if you still have questions, then feel free to post them. But please do not expect that others will give you a full solution when it seems that you don't feel like even trying.

_________________

Image
Rate this response:  
Not yet rated
techiexavier
Participant



Joined: 28 Feb 2012
Posts: 15
Location: Chennai
Points: 130

Post Posted: Mon Sep 17, 2012 10:00 am Reply with quote    Back to top    

Hi ,
Thanks for the inputs. i have been able to get details with dsjob like all projects in the sever, link details, stage details and job details. Only i am not able to get the details of job that are running currently in the sever, what i actually needed.

Thanks!
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 36605
Location: Denver, CO
Points: 186585

Post Posted: Mon Sep 17, 2012 11:15 am Reply with quote    Back to top    

Using dsjob with the -jobinfo option will (among other things) tell you if it is running or not.

_________________
-craig

It's a scheme of devices to get at low prices all goods from cough mixtures to cables
Which tickled the sailors by treating retailers as though they were all veg-e-tables
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours