TaskSchedule clean up

Which IIQ version are you inquiring about?

8.4p2

We are facing the problem that TaskSchedules are not displayed in the UI via TaskSchedule or Scheduled Reports tab. Instead, we get the usual error message: An unexpected error has occurred: The server response could not be evaluated. countObjects(TaskSchedule.class, new QueryOptions()) returns the number ~8500. This may be too many.

Is there a way to clean up old TaskSchedules or something that can help us analyze the number of schedules and remove unnecessary objects?

Thank you in advance

@mwoi looks like completed task Schedule also not cleanup, you can run a query to see if taskSchedule don’t have cron or next execution. you can delete it from console.

If you have database access, you can look in the IDENTITYIQ.QRTZ221_JOB_DETAILS table and IDENTITYIQ.QRTZ221_TRIGGERS table (and the other QRTZ* tables) for things related to TaskSchedules.