Page 1 of 1
Number of stages in a project
Posted: Wed Sep 20, 2006 7:16 pm
by koolnitz
Hi All,
For some reason, I need to get counts of (i) no. of jobs, (ii) no. of stages, used in my project.
I know how to get the count for (i).
Is there any way to find out the count for (ii)? Of course other than opening all the jobs to count manually.
Thanks!
Posted: Wed Sep 20, 2006 8:25 pm
by kduke
Code: Select all
Select
Count(*) As Cnt
From
DS_JOBS
Where
NAME NOT LIKE '\%'
;
Code: Select all
Select
Count(*) As Cnt
From
DS_JOBOBJECTS
Where
OLETYPE LIKE '%Stage'
;
Posted: Thu Sep 21, 2006 7:00 am
by Mike
I hope this isn't some pointy-haired manager's way of measuring productivity.
They need to be careful about what they measure. It won't take long before developers start adding dozens of useless stages to jobs if that is how their productivity will be measured.
Mike
Posted: Thu Sep 21, 2006 7:35 am
by kduke
Mike is correct. You may want to count links, columns, routines and whatever else that takes time. Columns would be very difficult.
Posted: Thu Sep 21, 2006 12:14 pm
by koolnitz
Kim, Thanks alot for providing the SQLs.
Answering to Mike, it's a policy in my organization to collect number of lines of code used in all the projects. This is basically to measure how much coding has been done. Unfortunately (or fortunately
) DS doesn't have code in lines. So we thought of providing them the no. of jobs and stages in the project.
Do you have any better idea to measure the work done on a DS project?
Thanks guys!
Posted: Thu Sep 21, 2006 12:28 pm
by kduke
Columns more closely relates to lines of code. Do a search on complexity. We have had several discussions on it.
Posted: Thu Sep 21, 2006 12:53 pm
by koolnitz
How about counting the number of lines in .dsx file? Just a thought!
Next questions that might come up are..
What components to export?
Full export or job designs only?
Are we really measuring the work done (resource spent) based on this number?
I know, it's not et al intelligent, but I need to provide the measure of work done in DS in terms of lines of code
Btw, I have currently 138 jobs and 1571 stages in my project. And there are 1432320 lines in .dsx file (exported only Job designs, Shared containers and table definitions).
Posted: Thu Sep 21, 2006 3:13 pm
by ray.wurlod
koolnitz wrote:Kim, Thanks alot for providing the SQLs.
Answering to Mike, it's a policy in my organization to collect number of lines of code used in all the projects. This is basically to measure how much coding has been done. Unfortunately (or fortunately
) DS doesn't have code in lines. So we thought of providing them the no. of jobs and stages in the project.
Do you have any better idea to measure the work done on a DS project?
Thanks guys!
Challenge them.
Report that number of lines of code = zero.
Let us know how they react.