How to change the cleanup task time in DB

By default the table cleanup task will be automatically performed by the system daily. Even though this wont affect the system performance, you can still edit this time to a custom time may be during the non-production hours.

Ensure a backup is taken before executing the queries. Connect to the Database and execute the below queries,

update task_input set schedule_time=’2013-07-24 21:00:00.123′  where schedule_id in (select schedule_id from schedule where schedule_name like ‘CleanupAuditSchedule’);

update task_input set schedule_time=’2013-07-24 21:00:00.523′  where schedule_id in (select schedule_id from schedule where schedule_name like ‘CleanupSchedule’);

If you want the clean up task to be scheduled to run from tomorrow, then in the above queries set the date as tomorrow’s date. Once this is updated then it will automatically update the date to successive days and do the clean up task daily.

Need More Help?

Are you looking for a personalized customer support? Submit your question or Call our Toll Free Number to speak with ServiceDesk Plus MSP Expert who can offer a better solution for your requirements.

Submit a Ticket
Email : sdpmsp@manageengine.com
Toll Free : 1-888-720-9500