Number of jobs in Datastage

svga · Post by **svga** » Tue Mar 24, 2009 3:50 am

Hi,

Can anyone tell me the Command used to count the number of jobs in Datastage.

ray.wurlod · Post by **ray.wurlod** » Tue Mar 24, 2009 4:14 am

There isn't one.

From the Administrator client command window you can execute a query in the project to which you're actually connected, counting rows from DS_JOBS whose keys do not begin with "\\" and whose job type is not "sequence". But that's the count only for one project. You would need to do the same in all projects and sum the counts for "number of jobs in DataStage.

And that's just on your server. What about your other servers? What about every other DataStage installation on the planet and elsewhere? To get "number of jobs in DataStage" you'd have to count all the jobs in them too.

dh_Madhu · Post by **dh_Madhu** » Tue Mar 24, 2009 4:17 am

try this "SELECT COUNT(*) FROM DS_JOBS" in the Datastage administrator...

ray.wurlod · Post by **ray.wurlod** » Tue Mar 24, 2009 4:20 am

That will not give the correct answer, Madhu. Refer to my earlier post for reasons why not.

svga · Post by **svga** » Tue Mar 24, 2009 4:30 am

Hi,

Thanks for your answers.The above query gives the count of both jobs and sequences.Please help me to get the count of jobs alone.

dh_Madhu · Post by **dh_Madhu** » Tue Mar 24, 2009 4:42 am

Ya...got it.
Thanks Ray!

ray.wurlod · Post by **ray.wurlod** » Tue Mar 24, 2009 2:00 pm

You need to filter on NAME and JOBTYPE as discussed in my earlier answer.