How to Total no.of jobs in a Project

reddy · Post by **reddy** » Tue Jun 28, 2005 11:53 am

Hi Guys,

How to find total no.of jobs from my project using datastage administrator

or command line mode.

Thanks in advance.

Thanks
Narasa

ArndW · Post by **ArndW** » Tue Jun 28, 2005 11:58 am

If you mean the UniVerse/DataStage environment command line mode, you can execute COUNT DS_JOBS WITH JOBTYPEIND NE ''

If you mean Unix, you could do a "dsjob -ljobs {yourprojectname} | wc -l"

ray.wurlod · Post by **ray.wurlod** » Tue Jun 28, 2005 6:32 pm

Code: Select all

COUNT DS_JOBS WITH NAME LIKE "1A0X"

would be my preference from the Administrator client command window.

hexa · Post by **hexa** » Tue Jun 28, 2005 11:54 pm

Hi ray,

COUNT DS_JOBS WITH NAME LIKE "1A0X"

"1A0X" --> What does it mean?

could you Explain!

ArndW · Post by **ArndW** » Wed Jun 29, 2005 12:07 am

In the BASIC Programmer's Guide pages 6-248 onwards it describes the mask formats - this one denote 1 alphabetic character and then any number of any characters. The reason you cannot just do a COUNT of the file is that it contains several records that do not hold descriptions of jobs but control information and we are filtering them out.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Wed Jun 29, 2005 3:15 am

Note that the dsjob command will also return the status code.

kduke · Post by **kduke** » Wed Jun 29, 2005 9:41 am

The DS_JOBS table has categories in it as well as jobs. They start with "\". So to not count them you need to do what Ray posted or something similar. I prefer UNLIKE "\...". This is just Ray's style.