In the lower right corner of the Ctontrol-M EM Mgr viewpoint screen a summary of tables, sub-tables, and jobs is maintained throughout the day. Can anyone tell me how these numbers are derived? I expect that the jobs count is the number of jobs ordered into the AJF for the current day. Would it also include any jobs ordered when a user does and order/force? Could it also include any jobs ordered in the past but placed on hold as they continue to show up in the viewpoint each day even though they have very old ODATEs. Does the count include BIM service definitions? Does it include the count of tables in the jobs total?
I cannot find anything in the docs that tells me how this number is computed.
Thanks in advance for your insights...
-Cliff
How is Total Jobs Count Derrived in EM Gui?
- philmalmaison
- Nouveau
- Posts: 1148
- Joined: 08 Jun 2007 12:00
- Location: Ile de France
Hi,
For counting jobs accordingly with BMC Software, use the reporting facilty.
What is in the count are all jobs from AJF, but on average on the year.
BMC Software ask for extreme peak on the year using the reporting facility.
That is what is taken to calculate licencing in jobs and not by power/host.
Regards,
Philmalmaison
For counting jobs accordingly with BMC Software, use the reporting facilty.
What is in the count are all jobs from AJF, but on average on the year.
BMC Software ask for extreme peak on the year using the reporting facility.
That is what is taken to calculate licencing in jobs and not by power/host.
Regards,
Philmalmaison
Hi Cliff.
The count you see in the GUI is a total based on the viewpoint you have open. Therefore if you open the default view of ALL JOBS, the totals will be every job in the AJF regardless of date. When users add jobs to the AJF (order or force) the job counts will be increased. If you hold some jobs, the count will remain the same.
If you switch to Active Jobs viewpoint, this count will be different as you have previously held a few jobs, and they are no longer present in the current viewpoint.
Regards.
Graham.
The count you see in the GUI is a total based on the viewpoint you have open. Therefore if you open the default view of ALL JOBS, the totals will be every job in the AJF regardless of date. When users add jobs to the AJF (order or force) the job counts will be increased. If you hold some jobs, the count will remain the same.
If you switch to Active Jobs viewpoint, this count will be different as you have previously held a few jobs, and they are no longer present in the current viewpoint.
Regards.
Graham.
Thanks to all that replied to my post.
I am most interested in the reply from Philmalmaison as it gets to the reason for my question as it relates to historical daily totals rather than todays totals. If we are to begin using the reporting facility to determine high water mark, we need to understand what is counted as a task when computing and recording the daily totals for the past year. I only recently realized that ordering a job and placing it on hold would would cause it to be counted in each days total until it was released or deleted. In the case of ordering entire tables of jobs, this could account for large numbers of held jobs being counted each day even though they would not run. And in the case where the user had forgotten about these held jobs and they became esentially abandoned, the daily total job count could be artificially high for quite some time and put the high water mark at risk. This is why I am trying to learn what gets counted so we can educate our deveopers and operators on best practices that will not cause artificial licensing issues. I am told that some tables such as smart tables get counted as a task. Is this true and if so why?
regards,
Cliff
I am most interested in the reply from Philmalmaison as it gets to the reason for my question as it relates to historical daily totals rather than todays totals. If we are to begin using the reporting facility to determine high water mark, we need to understand what is counted as a task when computing and recording the daily totals for the past year. I only recently realized that ordering a job and placing it on hold would would cause it to be counted in each days total until it was released or deleted. In the case of ordering entire tables of jobs, this could account for large numbers of held jobs being counted each day even though they would not run. And in the case where the user had forgotten about these held jobs and they became esentially abandoned, the daily total job count could be artificially high for quite some time and put the high water mark at risk. This is why I am trying to learn what gets counted so we can educate our deveopers and operators on best practices that will not cause artificial licensing issues. I am told that some tables such as smart tables get counted as a task. Is this true and if so why?
regards,
Cliff
Hi Cliff
You can use some SQL querys to count your jobs and groups.
For example :
Number of groups in AJF:
select count(orderno) from cmr_ajf where tasktype = 'G';
Number of jobs in AJF:
select count(orderno) from cmr_ajf where tasktype != 'G';
Number of jobs ordered today in AJF:
select count(orderno) from cmr_ajf where tasktype != 'G' and ODATE = '20111128';
Number of groups ordered today in AJF:
select count(orderno) from cmr_ajf where tasktype = 'G' and ODATE = '20111128';
Use a script to edit a report, before your "new day procedure"
Regards
Christophe
You can use some SQL querys to count your jobs and groups.
For example :
Number of groups in AJF:
select count(orderno) from cmr_ajf where tasktype = 'G';
Number of jobs in AJF:
select count(orderno) from cmr_ajf where tasktype != 'G';
Number of jobs ordered today in AJF:
select count(orderno) from cmr_ajf where tasktype != 'G' and ODATE = '20111128';
Number of groups ordered today in AJF:
select count(orderno) from cmr_ajf where tasktype = 'G' and ODATE = '20111128';
Use a script to edit a report, before your "new day procedure"
Regards
Christophe
Hello All,
To provide me with a daily list of the Control-M tasks I created a BMC job that runs right before new day and executes the following command on the Control-M/Server:
ctmdbcount | grep "CMR_AJF table" | mailx -s "The count of production BMC tasks" <email_address>
The body of the email I receive has:
count of records in CMR_AJF table: 1252
To provide me with a daily list of the Control-M tasks I created a BMC job that runs right before new day and executes the following command on the Control-M/Server:
ctmdbcount | grep "CMR_AJF table" | mailx -s "The count of production BMC tasks" <email_address>
The body of the email I receive has:
count of records in CMR_AJF table: 1252