Any ideas on how to script on mass repair SLA's

[sgoud]

Hi Guys ,

I got a requirement to design a script for mass repair of SLA's ? i couldn't find anything regarding that .. could you help me with any lead ?

Thanks in advance ,

Sanjay

[jacob_benker]

Sanjay,

Is this a one-time run or something that you need to automate?

For a one-time thing I would suggest using the list action on the task_sla table. You can open a list view of Task SLA, filter the list to the SLAs you want to repair, and then under Related Links click on 'Repair all filtered SLAs'.

If you need to automate it you could:

        1) Use a Fix Script. Would only be semi automated. You would update the script and execute manually as you needed. I would use this in the case that the criteria of which SLAs might not be consistent.

        2) Setup a Scheduled job. This is fully automated but requires that the conditions are be consistent.

Without knowing more about your specific requirements I hope this helps.

[alekhyan]

HI Jacob Benker,

Thanks for your reply,

If I want to get last 24 hours jobs then how can we get those jobs and run repair SLA's????

[Robin Hearne]

Hi Jacob,

I have a need to perform a one-off repair on about 13k records.   Would you be able to suggest a way to do this using a Background Script rather than using the 'SLA Repair' UI Action (that can only be run on one page of results at a time)?

Regards,

Robin

[jacob_benker]

Robin,

I would set it up as a Fix Script. This will allow you to run it on-demand and save it in case you ever need to run it again.