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
Number of only jobs and number of only sequences in project
Moderators: chulett, rschirm, roy
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)
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)
Regards,
Shree
785-816-0728
Shree
785-816-0728
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.
CATEGORY and JOBTYPE are in DS_JOBS. Use SQL.
Mamu Kim
Re: Number of only jobs and number of only sequences in proj
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
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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;
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.