Deletes orphaned scheduled report records in TS_NOTIFICATIONEVENTS, TS_NOTIFICATIONS, and TS_NOTIFICATIONSUBSCRIPTIONS. For example, if an entry for a scheduled report is deleted from TS_NOTIFICATIONS, but a related record exists in TS_NOTIFICATIONEVENTS, you can use this command to clean up both tables.

The command performs the following actions:

There are two ways to execute this command using the provided batch template files:

Example output:

java -Dfile.encoding=UTF-8 -jar renew.jar -cleanupScheduledReports 
-dbUsername "sa" -dbPassword "password"

WARNING: This will delete some data from TS_NOTIFICATIONS and TS_NOTIFICATIONEVENTS tables. 
Are you sure? [Y/N]:Y