Service Desk Practitioners Forum
cancel

Need to delete scheduled task from OV SD 5.2

SOLVED
Go to solution
Highlighted
mamit
Trusted Contributor.

Need to delete scheduled task from OV SD 5.2

Hi,

 

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_javaobjects
WHERE  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

 

Regards

3 REPLIES
The Pike
Acclaimed Contributor.

Re: Need to delete scheduled task from OV SD 5.2

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!

 

The Pike

mamit
Trusted Contributor.
Solution

Re: Need to delete scheduled task from OV SD 5.2

Resolved...

The Pike
Acclaimed Contributor.

Re: Need to delete scheduled task from OV SD 5.2

It helps the rest of the Service Desk community if you state it how it was resolved and not just that it was resolved.