Number of only jobs and number of only sequences in project

[SharingDS]

Hi Gurus,

I can get the total number of jobs in a project by executing the query COUNT DS_JOBS WITH @ID LIKE '1N0N' ,
but 1) I want to get the number of jobs in a particular category in my project
2) Number of only jobs and number of only sequences in project
3)Number of only jobs and number of only sequences in particular category.
Can anyone tell me how can i get this Info, i have seached this forum based on number of jobs as search word, but i did't get any already posted query .

Kind Regards

[Sreedhar]

Hi,


You can get the detail of the no of Jobs in a particular project by using the following command line interface.


dsjob -lprojects you will get all the project that are attached to a server

dsjob -ljobs <project name> will give you all the job in the project.

for further information on the same go through the serverdev.pdf page no 700 (command Line Interface)

[kduke]

You are going to have to do it at TCL like viewtopic.php?t=101044&highlight=JOBTYPE

CATEGORY and JOBTYPE are in DS_JOBS. Use SQL.

[Cr.Cezon]

Try with:


1) I want to get the number of jobs in a particular category in my project
COUNT DS_JOBS WITH F3 = 'your category'

2) Number of only jobs a
COUNT DS_JOBS WITH F6 = 0 or F6 = 3
nd number of only sequences in project
COUNT DS_JOBS WITH F6 = 2

3)Number of only jobs and number of only sequences in particular category.
add:
AND F3 = 'your category'


regards,
Crisitna

[ray.wurlod]

CATEGORY and JOBTYPE are designated column names in DS_JOBS; why not use them? For example:

Code: Select all

SELECT COUNT(NAME) FROM DS_JOBS WHERE CATEGORY = '<<Category>>';

SELECT COUNT(*) FROM DS_JOBS WHERE JOBTYPE = 3;  

[SharingDS]

Thanks a lot Kim, Cr.cezon and Ray Ji ,

I got Ans exactly what i want.

Thanks once again

Cheers