How do I count the total number of Jobs is a project?

Lotus26 · Post by **Lotus26** » Wed Oct 25, 2006 2:05 pm

Thanks All! It worked now after setting the DSHOME Variable.

ray.wurlod wrote:... but the count will be given in the status bar.

rachitha · Post by **rachitha** » Wed Oct 25, 2006 11:35 pm

ray.wurlod wrote:... but the count will be given in the status bar. ...

SELECT MAX(JOBNO) FROM DS_JOBS .

execute this query DS Admin command

Thanks
Rachitha

chulett · Post by **chulett** » Thu Oct 26, 2006 12:01 am

No... that would just select the highest job number issued so far. More than likely, that will have very little resemblance to the actual number of jobs in the project... unless you've never deleted any jobs or imported jobs into the project that already existed.