Counting DataStage jobs

jjrbikes · Post by **jjrbikes** » Fri Jan 30, 2009 9:52 am

Greetings -

Basic Question: Can someone tell me if there is a relatively easy way to assess the number of DataStage jobs in any given installation?

More Info: I am working for a company going through a merger and the time has finally come to make a decision ... DataStage or "the other guy". In a meeting yesterday the question was asked, "just how many DataStage jobs do you currently have running in production?". Holy buckets - I know it's a bunch but how can I find out for sure?

Thanks!!

mk_ds09 · Post by **mk_ds09** » Fri Jan 30, 2009 10:01 am

hi..

You can use DS_JOBOBJECTS to check how many number of jobs are there.
Conenct and select number of records form the given table..that eventually gives you the number of jobs in given repository !

hope this helps

----------------

MK

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Fri Jan 30, 2009 10:37 am

dsjob -ljobs in the project

DSguru2B · Post by **DSguru2B** » Fri Jan 30, 2009 12:08 pm

Easiest way to get a count is to LOG TO each and every project individually from the UV account and run the following command

Code: Select all

COUNT DS_JOBS

ray.wurlod · Post by **ray.wurlod** » Fri Jan 30, 2009 2:42 pm

... which is what dsjob -ljobs does.

The advantage of dsjob in this case is that you can create a script to loop through the list of project names on the server.

To get a count, simply pipe the output into a wc -l command.

jjrbikes · Post by **jjrbikes** » Tue Feb 03, 2009 10:58 am

Wow! Thanks for the responses!! Just what I needed.

Thanks again and have a Great Day!!