How many job are in the project?

jseclen · Post by **jseclen** » Tue Nov 18, 2003 3:28 pm

Hi forumers ....

With the next UNIX command obtain the number of jobs:

> dsjob -ljobs MyProject | wc -l

But the result is only the server jobs ...

How obtain the total number of jobs in my project (server and mainframe) ?????

ray.wurlod · Post by **ray.wurlod** » Tue Nov 18, 2003 3:37 pm

COUNT DS_JOBS WITH @ID LIKE "1N0N"

This UniVerse (DataStage Engine) command counts the integer keys in the DS_JOBS file. This is the total number of jobs that you have. It does not differentiate job type; this was not part of your original request.

To execute this from a UNIX shell, you need the uv command.
cd yourproject
$DSHOME/bin/uv "COUNT DS_JOBS WITH @ID LIKE '1N0N'"

mhester · Post by **mhester** » Tue Nov 18, 2003 5:38 pm

I do not know or use what Ray posted, but this too will work -

>SELECT DS_JOBS <> '\\NextNumber' AND F5 > 0

This will not include the Next Number record and only those objects that have a job number. Folders do not have a job number.

Regards,

Michael Hester