DSXchange

Hi,

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

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.

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

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

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.

Ya...got it.
Thanks Ray!

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