-cleanupScheduledReports

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:

Deletes scheduled reports records (with TS_SENDTYPE=256) from the TS_NOTIFICATIONS table that reference a report that no longer exists. In other words, delete records in which TS_NOTIFICATIONS.TS_REPORTID references a TS_REPORTS.TS_ID that does not exist.
Deletes scheduled reports records (with TS_SENDTYPE=256) from the TS_NOTIFICATIONS table that do not have a related record in the TS_NOTIFICATIONEVENTS table (TS_NOTIFICATIONID column).
Deletes scheduled reports records (with TS_SENDTYPE=256) from the TS_NOTIFICATIONEVENTS table in which TS_NOTIFICATIONEVENTS.TS_NOTIFICATIONID references a TS_NOTIFICATIONS.TS_ID that does not exist.
Deletes scheduled reports records from the TS_NOTIFICATIONSUBSCRIPTIONS table in which TS_NOTIFICATIONSUBSCRIPTIONS.TS_NOTIFICATIONID references a TS_NOTIFICATIONS.TS_ID that does not exist.

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

Run cleanupSR.bat:
```
installDir\SBM\Common\Misc\renew\renew_templates\cleanupSR.bat
```
This command deletes orphaned records related to scheduled reports from TS_NOTIFICATIONEVENTS and TS_NOTIFICATIONS.

In this case, the -dbUsername and -dbPassword options are omitted. In their place, the credentials are taken from the renew.properties file located here:
```
installDir\SBM\Common\tomcat\server\default\conf
```
Run cleanupSR_dbCredentials.bat:
```
installDir\SBM\Common\Misc\renew\renew_templates\cleanupSR_dbCredentials.bat
```
This command deletes orphaned records related to scheduled reports from the TS_NOTIFICATIONEVENTS, TS_NOTIFICATIONS, and TS_NOTIFICATIONSUBSCRIPTIONS tables using the database credentials that are specified in the batch file.

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
Done.