|
|
|
Schedule a simple Access Report to export to HTML every weekday at specified times of the day. |
||||||
Schedule a number of reports as a "package" to export to HTML every Monday and Friday at specified times of the day. |
||||||
Schedule to create a specified folder on the first Monday of every month. |
||||||
| Event-Based Schedule |
Fire off and deliver reports automatically when an event occurs. Here are some examples.
|
|||||
5. |
Group a number of event-based activities and determine timing, order of execution and more |
|||||
| Dynamic Schedule |
SQL-RD will reel through a list of parameter values, generate a unique report for each value, and deliver each report to a unique destination (e.g. email address, folder, etc). Saves you from having to write and maintain multiple schedules.
|
|||||
7. |
Dynamic Package |
|||||
| Calendar |
Create your own scheduling frequencies using Custom Calendars (e.g. 4-4-3). Or use Exception Calendars to skip special days (e.g. public holidays)
|
|||||
| 9. |
Set up logon credentials for the reports. Keep copies of exported reports for x days. |
|||||
| 10. |
How to tell SQL-RD what report parameter values to use. |
|||||
| 11. |
Retry x times on failure. What to do if the report "hangs". Take some action if the report returns no data. |
|||||
| Destinations |
||||||
| 13. |
Set up a number of destinations (email, printer, fax, SMS, folder and FTP) and use them over and over again. |
|||||
| Output Formats |
Learn how to quickly set up schedules to export to pdf, tiff, xls, and many more formats. Also shown are output features e.g. custom report naming, zipping the export, zip encryption, deferred delivery, and lots more.
|
|||||
When the report has been delivered, run a batch file, update a database, send an email and more. |
||||||
Insert Constants (e.g. Yesterday's Date, CurrentScheduleName, ExportedFileName) to automate otherwise repetitive and mundane processes. |
||||||
| 17. |
User Management |
|||||
Set up SQL-RD to use MAPI to send emails. |
||||||
Set up SQL-RD to use Exchange Server to send emails. |
||||||
Set up SQL-RD to use SQL-RDMail to send emails. |
||||||
| 21. |
Set up SQL-RD to send SMS text alerts. |
|||||
Set up SQL-RD to use SMTP to send emails. |
||||||
Set up SQL-RD to use GroupWise to send emails. |
||||||
| 24. |
Automatically backup the SQL-RD system and files. |
|||||
| 25. |
Set up SQL-RD to use the Application Scheduler. |
|||||
| 26. |
Set up SQL-RD to use the Windows (NT) Service. |
|||||
| Address Book |
||||||
| 28. |
Use smart folders to group schedules and to report on schedule activity |
|||||
| 29. |
Don't type the same password, email body, signature etc over and over again. With User Defaults you can enter than once, and reuse them each time your write a schedule. |
|||||
| 30. |
Set up an audit trail showing activities that have happened in SQL-RD. |
|||||
| 31. |
Connect to and administer remote installations of SQL-RD from your PC. |
|||||
Set up folder housekeeping and other automated processes to help keep your system and pc robust and stable. |
||||||
| 33. |
Use multiple PCs to schedule hundreds of reports. The "Master" controls a bank or "cluster" of PCs ("slaves") and instructs them what to run and when. See how easy it is to set this up. |
|||||
| 34. |
The SQL-RD data (schedule info etc) is stored in a Access database locally. Migrating to a SQL, Oracle or other ODBC compliant database gives you enterprise scalability and reliability - and gives you the ability to write triggers, stored procedures and add custom functionality. Important: Click here and read this document before you begin the process. |
|||||
| 35. |
Migrate back to the local file system. Useful if you know your server is going to be down for maintenance. |

