SBM Orchestration Guide → Renew Utility → Renew Commands → -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:
There are two ways to execute this command using the provided batch template files:
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:
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.
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.
Copyright © 2007–2019 Micro Focus or one of its affiliates. All rights reserved.