How do I count the total number of Jobs is a project?
Moderators: chulett, rschirm, roy
How do I count the total number of Jobs is a project?
I know there is a command for this in datastage administrator command window. But i just can not remember what it is. any idea?
The Right One at Right Place at Right Time
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
COUNT DS_JOBS will be very close, but would include a couple of control records. COUNT DS_JOBS WITH JOBNO LIKE "1N0N" will be more accurate, or COUNT DS_JOBS WITH NAME LIKE "1A0X"
If you prefer SQL, SELECT COUNT(*) FROM DS_JOBS WHERE NAME NOT LIKE '\\%';
If you prefer SQL, SELECT COUNT(*) FROM DS_JOBS WHERE NAME NOT LIKE '\\%';
Last edited by ray.wurlod on Wed Oct 25, 2006 9:08 am, edited 1 time in total.
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.
you can also do it in the command prompt using the dsjob command
Code: Select all
dsjob -ljobs <Project Name> | wc -l
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The original question stipulated "in DataStage Administrator"
To execute a UNIX command from Administrator use the SH command. For example
To execute a DOS command from Administrator use the DOS command. For example:
Of course, if you're running 7.5x2 on Windows, you can use UNIX commands.
![Idea :idea:](./images/smilies/icon_idea.gif)
Code: Select all
SH -c "dsjob -ljobs <Project Name> | wc -l"
![Idea :idea:](./images/smilies/icon_idea.gif)
Code: Select all
DOS /C "dsjob -ljobs <Project Name>"
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.
Where in the Administrator client would you execute?:
COUNT DS_JOBS and
SELECT COUNT(*) FROM DS_JOBS WHERE NAME NOT LIKE '\\%';
I have access to the Administrator command prompt and I can execute:
SH -c "dsjob -ljobs <Project Name> | wc -l"
and it works but I would like to know where you would execute the first 2 commands.
Thanks.
COUNT DS_JOBS and
SELECT COUNT(*) FROM DS_JOBS WHERE NAME NOT LIKE '\\%';
I have access to the Administrator command prompt and I can execute:
SH -c "dsjob -ljobs <Project Name> | wc -l"
and it works but I would like to know where you would execute the first 2 commands.
Thanks.
No dearkriss. In DS Administrator's client's Projects tab, I click on Command button. In this window, I can execute:
SH -c "dsjob -ljobs <Project Name> | wc -l"
and it works fine. I want to know where I can execute:
COUNT DS_JOBS and
SELECT COUNT(*) FROM DS_JOBS WHERE NAME NOT LIKE '\\%';
They don't work in the Command window.
SH -c "dsjob -ljobs <Project Name> | wc -l"
and it works fine. I want to know where I can execute:
COUNT DS_JOBS and
SELECT COUNT(*) FROM DS_JOBS WHERE NAME NOT LIKE '\\%';
They don't work in the Command window.
Hi,
When i tried to get the Job count for my Project! I am getting the following Error Message!
The Command issued is as follows:
SH -c "dsjob -ljobs <CMK> | wc -l"
The Error i am getting is:
SH: syntax error at line1: '|' unexpected
I tried in another way:
Command Issued: SH -c "dsjob -ljobs KMC | wc -l"
Message: SH:dsjob: not found 0
But i have some jobs in the project! My User id have Developer Access! So is it problem with User Id or any thing else.
I appreciate your help! Thanks for your time!
When i tried to get the Job count for my Project! I am getting the following Error Message!
The Command issued is as follows:
SH -c "dsjob -ljobs <CMK> | wc -l"
The Error i am getting is:
SH: syntax error at line1: '|' unexpected
I tried in another way:
Command Issued: SH -c "dsjob -ljobs KMC | wc -l"
Message: SH:dsjob: not found 0
But i have some jobs in the project! My User id have Developer Access! So is it problem with User Id or any thing else.
I appreciate your help! Thanks for your time!
DSguru2B wrote:Ofcourse they do. How exactly are you typing it in ?
Regards
Lotus26
Lotus26
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Another crude way of finding the number of jobs in a project
In the Director go to
All the job entries are displayed
Beware if you have thousands of jobs, it might take a pretty long time to give you results.
In the Director go to
Code: Select all
View - > Uncheck "Show Categories"
Beware if you have thousands of jobs, it might take a pretty long time to give you results.
Narasimha Kade
Finding answers is simple, all you need to do is come up with the correct questions.
Finding answers is simple, all you need to do is come up with the correct questions.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: