We are using OVSD 5.2 and need to delete the scheduled tasks.
I have tried the below quieries but it shows 0 records selected.
SELECT COUNT(*) FROM rep_javaobjects , ifc_entities WHERE ent_oid = jav_entity AND ENT_NAME like 'Scheduled Tasks'
DELETE FROM rep_javaobjectsWHERE jav_entity = ( SELECT ent_oid FROM ifc_entities WHERE ent_name = 'Scheduled Tasks' )
This query works on SD4.5 is there any seperate query for SD5.2.Can any one help with the query or guide to delete the scheduled tasks from SD 5.2
Go to Solution.
AFAIK, Service Desk 5.2 was never released. Perhaps you mean SD5.10?
I could be wrong, but in SD5.10 Scheduled Tasks are spread across multiple tables: rep_scheduled_rule_tasks, rep_scheduled_conditions and rep_scheduled_rule_tasks.
Have fun! Kudos for the guidance are welcome!
It helps the rest of the Service Desk community if you state it how it was resolved and not just that it was resolved.