Scheduled tasks

If the number of scheduled tasks are more, the SD’s performance will be poor.

Run the below query in the DB, to know what are the number of tasks, which gets loaded to RAM, when you start the server. (note : this is an SQL query)

select JAV_OID, JAV_ENTITY, LEFT(JAV_INSTANCE,30) as SEARCHCODE from rep_javaobjects
where jav_entity = (
select ent_oid
from ifc_entities
where ent_name = 'Scheduled Tasks' )

Then if the numbers are too high, delete them by running the below SQL query

  delete from rep_javaobjects
  where jav_entity = (select ent_oid
  from ifc_entities
  where ent_name = ' Scheduled Tasks')

Please note that this will erase all the scheduled task, which are created by DB and UI rules in SD.