Orchestration Automation Level Indicator
This topic contains information about the logic used to calculate the automation level indicator of orchestration scripts including:
AutoSys
Automation level indicator provides the automation conversion coverage of the AutoSys conversion. It is calculated based on the average of automation level indicator of boxes and jobs.
Automation Level Indicator = (sumtotalBoxPercentage + sumtotaljobPercentage) / (numberParentJob) + numberParentBox)
For instance, if you have two boxes – BX1 and BX2 with 95% automation level indicator for each, and a job (Other_Jobs) with 90% automation level indicator. Then the overall automation level indicator is calculated as (sumtotalBoxPercentage + sumtotaljobPercentage) / (numberParentJob) + numberParentBox); i.e., ((95+95) +90)/ (1+2) = 93.33%.
Next, let’s see how to calculate the automation level indicator of each job and box.
The automation level indicator of each job is calculated based on:
- Successfully converted job: Automation level indicator of a successfully converted job is 100%.
- Failed job: Automation level indicator of a job that is failed to convert is 0%.
- Partially supported job (successfully converted job with ToDo message): Automation level indicator of a partially supported job or successfully converted job with ToDo message is 90% by default (configurable).
The automation level indicator of each box is calculated based on:
- Successfully converted box: Automation level indicator of a successfully converted box is 100%.
- Failed box: Automation level indicator of a box that is failed to convert is 0%.
- Box contains jobs: If a box has ‘n’ number of jobs, then the automation level indicator for that box is average of automation level indicator of the jobs present in it.
For instance, if a BX1 box has two jobs – BX1-J1 and BX1-J2, then the Automation level indicator for:
- BX1-J1 is 100% as the job is successfully auto-converted.
- BX1-J2 is 90% as the job is partially supported (auto-converted with ToDo message).
Therefore, the automation level indicator of BX1 box is average of automation level indicator of the jobs; i.e, (100+90)/2 = 95%
File Name |
Box Name |
Job Name |
Job Type |
DAG Name |
Target Job Name |
Target Job Type |
Status |
Automation Level Indicator |
AutoSys |
|
BX1 |
BOX |
BX1_dag |
BX1 |
task_group |
success |
95 |
AutoSys |
BX1 |
BX1-J1 |
FW |
BX1_dag |
BX1_J1 |
RemoteFileSensor |
success |
100 |
AutoSys |
BX1 |
BX1-J2 |
CMD |
BX1_dag |
BX1_J2 |
SSHOperator |
success |
90 |
AutoSys |
|
BX2 |
BOX |
BX2_dag |
BX2 |
task_group |
success |
95 |
AutoSys |
|
BX1_external_task |
ExternalTaskSensor |
BX2_dag |
BX1_external_task |
task |
success |
|
AutoSys |
BX2 |
BX2-J3 |
FW |
BX2_dag |
BX2_J3 |
RemoteFileSensor |
success |
100 |
AutoSys |
BX2 |
BX2-J4 |
CMD |
BX2_dag |
BX2_J4 |
SSHOperator |
success |
90 |
AutoSys |
|
BX-J5 |
CMD |
BX2_dag |
BX_J5 |
SSHOperator |
success |
90 |
Control-M
Automation level indicator provides the automation conversion coverage of the Control-M conversion. It is calculated based on the average of automation level indicator of folders and jobs.
Folder/SubFolder = (Sum of % of all jobs present in folder + Subfolder % (if present))/ (Number of jobs present in folder + Number of subfolders (if present))
Next, let’s see how to calculate the automation level indicator of each folder and job.
The automation level indicator of each job is calculated based on:
- Successfully converted job: Automation level indicator of a successfully converted job is 100%.
- Failed job: Automation level indicator of a job that is failed to convert is 0%.
- Partially supported job (successfully converted job with ToDo message): Automation level indicator of a partially supported job or successfully converted job with ToDo message is 90% by default.
The automation level indicator of each folder is calculated based on:
- Successfully converted folder: Automation level indicator of a successfully converted folder is 100%.
- Failed folder: Automation level indicator of a folder that is failed to convert is 0%.
- Folder contains jobs: If a folder has ‘n’ number of jobs, then the automation level indicator for that folder is average of automation level indicator of the jobs present in it.
For instance:
- If a Folder1 folder has a job (OS_job1) with 90% automation level indicator (partially supported job), then the automation level indicator for the folder is also 90%.
- If a SubFolder1 sub folder has two jobs – OS_JOB1 with 100% automation level indicator because the job is successfully auto-converted and OS_JOB2 with 90% automation level indicator because the job is partially supported (job successfully auto-converted with ToDo message), then the Automation level indicator for SubFolder1 sub-folder is calculated as average of automation level indicator of OS_JOB1 and OS_JOB2 jobs, i.e, (100+90)/2 = 95.
- If a smart folder (SmartFolder1) has a job OS_JOB1 with 100% automation level indicator because the job is successfully auto-converted and a subfolder SubFolder1 with 95% automation level indicator because the job is partially supported (job successfully auto-converted with ToDo message). Then, the automation level indicator for SmartFolder1 is average of automation level indicator of the job and subfolder; i.e, (90+95)/2 = 92.5%
File Name |
Folder Name |
Job name |
Job Type |
DAG Name |
Target Job Name |
Target Job Type |
Status |
Automated Conversion Rate |
FileName1 |
|
Folder1 |
Folder |
Folder_Dag |
Folder |
Dag |
success |
90 |
FileName1 |
Folder1 |
Os_Job1 |
OS |
Os_Job1_1_dag |
Os_Job1_01 |
DummyOperator |
success |
90 |
FileName2 |
|
SmartFolder1 |
Smart folder |
SmartFolder1_dag |
SmartFolder1 |
Dag |
success |
92.5 |
FileName2 |
SmartFolder1 |
OS_JOB1 |
OS |
OS_JOB1_dag |
OS_JOB1 |
DummyOperator |
success |
90 |
FileName2 |
|
SubFolder1 |
SubFolder |
SubFolder1_dag |
Subfolder1 |
Task group |
success |
95 |
FileName2 |
SubFolder1 |
OS_JOB1 |
OS |
OS_JOB1_dag |
OS_JOB1 |
DummyOperator |
success |
100 |
FileName2 |
SubFolder1 |
OS_JOB2 |
OS |
OS_JOB2_dag |
OS_JOB2 |
DummyOperator |
success |
90 |