SQL Backup Master allows you to schedule the creation of any available report type.
A scheduled report can either output a report file to a specific path, send it via email, or both. Scheduled reports are created in PDF file format for maximum platform interoperability.
Navigate to the Reporting tab of the SQL Backup Master main window, and click the calendar icon in the left-hand navigation strip. A listing of scheduled reports will appear, if any have been defined.
Click the Add toolbar button to create a new scheduled report. The Scheduled Report Editor window will appear.
Reports have the following properties:
•Report type - Specifies the type of report to generate.
•Email report to - If you want to deliver your report via email, enter the recipient email address(es) here.
•Email subject - The email subject line to use when delivering reports.
•Save report file to folder - If you want to save reports to the file system, specify a folder path here.
•Zip report file - When selected, compresses the resulting PDF report file using ZIP compression.
Note that scheduled reports must either be saved to the file system, delivered via email, or both.
IMPORTANT: To deliver reports via email, you must first configure a Mail Server in the Global Options window.
While in the scheduled report editor window, select the Schedule tab.
In addition to the execution date and time, you can also configure the creation of scheduled reports on a daily, weekly, or monthly basis.