Datastage jobs are running currently

techiexavier · Post by **techiexavier** » Sat Sep 15, 2012 12:37 am

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 · Post by **chulett** » Sat Sep 15, 2012 7:41 am

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.

techiexavier · Post by **techiexavier** » Mon Sep 17, 2012 8:27 am

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.

ArndW · Post by **ArndW** » Mon Sep 17, 2012 9:03 am

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.

techiexavier · Post by **techiexavier** » Mon Sep 17, 2012 10:00 am

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!

chulett · Post by **chulett** » Mon Sep 17, 2012 11:15 am

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