Can I Automate OneClick SRM Reporting Database Backups?
book
Article ID: 188832
calendar_today
Updated On:
Products
CA SpectrumDX NetOps
Issue/Introduction
Can I Automate OneClick SRM Reporting Database Backups?
Environment
Release : 10.3
Component : Spectrum Core / SpectroSERVER
Resolution
Spectrum does not currently have an automated process for backing up the SRM 'reporting' MySQL database on the OneClick server. Backups can be executed from the command line and therefore could be scripted and executed either via cron tabs on Linux or Task Scheduler on Windows.
BackupReportingDBLandscape Utility Script (This backs up reporting data for a specific landscape) ----------------------------------------------------------- $SPECROOT/bin/BackupReportingDBLandscape(.sh|.bat) <mySQL user> <MySQL Password> <LandscapeName> <Description>
example: $SPECROOT/bin/BackupReportingDBLandscape.sh root root spectrumss25 "MLS SS Report Data Backup"