SQR-RD System


Schedule Manager




This screen will display the schedules that are currently executing.


Waiting in Queue

This screen will show the schedules that are waiting in the queue to be executed. You can also group the schedules by Schedule Type.

Refreshing the Display

You can adjust the refresh interval of the schedule manager by using the Refresh Interval scroller which has a range of 2 to 60 seconds.

Managing Processes

The Schedule manager also displays the Process ID which you can use to identify matching processes in the Windows Task Manager.

Context Menus



Right clicking on a schedule presents a context menu which allows you to do the following:


  • Properties. Select the schedule, right-click and select "Open Schedule properties". This opens the schedule properties.

  • Show in Explorer. Select the schedule, right-click and select "Show the schedule in Explorer. This shows the schedule in the SQL-RD Explorer.

  • Remove From Queue. Select the schedule, right-click and select "Remove from Queue". The schedule is removed from the queue.

  • Execute Schedule. Select the schedule, right-click and select "Execute Schedule". The schedule is executed right away if it was waiting.


Email Log



This screen shows a list of all emails which have been successfully delivered.


You can double click on an email to bring it up in an email client.


You can use the search field to view only the emails which match your search terms.


Email Queue



This screen shows a list of all failed emails.  If "Resend Failed Emails" has been checked in Options, then SQL-RD will keep retrying the email until it is manually removed from the queue.  As an example , if an email address has been misspelt (.cmo instead of .com).  The queue will shows when the last attempt was, and what the result was.


Send Now:  Select a message, and click this button to attempt an immediate delivery.


Remove Selected:  Select a message and click on this button to delete it from the list.


Remove All:  Click this button to clear the queue.


Only send one email alert per email failure: This works in conjunction with the "Try resending failed emails" in Options (Tools > Options). If a message cannot be sent and SQL-RD is configured to notify you of any email failure this makes sure an alert is sent to you only once and not every time the email fails due to the configured retry.



Error Log



The error log enables you to view any errors that have been encountered by the system.


You can filter out the entries displayed by using the search field to specify the keywords to filter by.


To view the details of an entry simply select it and the details will be shown in the opposite pane.


This can be very useful for troubleshooting purposes. You can also easily copy the details of a selected error using the "Copy error" button.


Deferred Delivery



This contains a list of reports and information on which have been deferred for delivery.



Deferring your Reports


In any scheduled output, go to the miscellaneous section




Check the Deferred delivery box and indicate the length of the delay before delivery.


Scheduled Backup



Use this option to set up automated system backups.  You can enable or disable automatic system backups.


You can use the Simple backup option if you do not need the scheduling options above.





As much as is possible try to schedule backups at times when you do not have schedules running. This is important as backups may cause delays to your schedule execution.


For more details on Backing up your SQL-RD system, please see Backup System


Scheduled Refresh



Use this option to create automated Schedule Refreshes.


You can add individual schedules or whole folders to the list.



Read Receipts



Read Receipts Enable you to confirm that an email has been read by the recipient after it has been sent. Tasks can be executed once or repetitively until the read receipt has been confirmed by SQL-RD. Read Receipts can be used in most Email Destinations.


**Read Receipts can only be used Exchange email settings. MAPI and Exchange


Setting Up Read Receipts


To set up Read Receipts for an email, go to an email destination, or if you sending an email as a  custom task, go to custom tasks: send an email.




Check the box "Request a read receipt for this message." This enables read receipts for this email destination.


Clicking the triple dots box, you can review additional read receipt options.




If a read receipt has not been received within a specified amount of time, custom tasks can be executed as a result. for more info on custom tasks, see Automation Schedule.


In schedules that send multiple emails (i.e. a Dynamic Schedule), a read receipt is triggered for each of the emails sent by the schedule.



Repeat above tasks every X minutes: Any task you have created will be executed at a determined interval until a read receipt is received.



Monitoring Read Receipts


Go to the system monitor's Read Receipts tab.



All emails that are waiting for a read receipt are displayed here. Clicking on filter you can separate your read receipts by delivered, pending or received.




When the email is sent, you will receive a delivery receipt. Once confirmation that the email has been read is received, you will be notified via email as well.