The 'Calculate SLA Results' scheduled job that calls the SLAResultSummarizer script include not present in New York and Orlando release

vividha
Kilo Contributor

The results of Service offering commitments is stored in table SLA Results [service_sla_result] using Script include SLAResultSummarizer. But when an SLA is breached or completed the records in this table should be updated to increase the count of the breached/completed SLAs. This should be done on periodic basis, may b using some scheduled jobs.

As per Servicenow documentation a scheduled job 'Calculate SLA Results'' is used to do the same, but it is not present in New York and Madrid release. 

Please let me know how records in table SLA Results are updated.

1 ACCEPTED SOLUTION

Sameep Kodia
ServiceNow Employee
ServiceNow Employee

Hi Vividha,

 

Is Service Owner Workspace plugin active on the instance? Calculate SLA Results and Calculate Availability jobs are deleted when this plugin gets activated and a new job is introduced called 'SPM Performance Score Computation' sys_id - 222c6326372023006289cc9fbe41f18f, which calls a script include which in turn calls the script include you mentioned.

 

P.S. - Please mark the answer helpful if it helped!

 

--

Sameep

View solution in original post

10 REPLIES 10

Hi Vividha,

I checked on my PDI instance which is on Orlando patch 0 hotfix 1.

Have you recently activated the plugin.  If so can you try logging out of your instance and back in to see if the job appears.  Here is how the Job looks on my PDI if it is of help:

find_real_file.png

Sameep Kodia
ServiceNow Employee
ServiceNow Employee

Hi Vividha,

 

Is Service Owner Workspace plugin active on the instance? Calculate SLA Results and Calculate Availability jobs are deleted when this plugin gets activated and a new job is introduced called 'SPM Performance Score Computation' sys_id - 222c6326372023006289cc9fbe41f18f, which calls a script include which in turn calls the script include you mentioned.

 

P.S. - Please mark the answer helpful if it helped!

 

--

Sameep

Hi Sameep,

Thanks for the response. I found the Schedule job that is using the mentioned script include.

But now there is one more issue. The Service Offering SLA attached to incident was breached 2 days ago i.e 8th June. After that the schedule job has executed twice but there is no update on the Breached field on SLA Results table [service_sla_result]. Data from this field is displayed on Service owner workspace for Metric Breached SLA.

Below is the screenshot.

find_real_file.png

Please let me know if you find something for it.

 

Thanks,

Vividha

Padam
Tera Contributor

Hi Vividha,

I ran the job "SPM Performance Score Computation". There are some breached sla. Those records are attached to service offering. However, breached field in SLA Result is still 0. Have you figured it out how these breached field get populated?

Thanks,

@Padam - Whether you found a solution for this? I am also facing same issue.