To configure the Scheduler Service, edit the file
eWebReportsScheduler.xml. This file can be found in the Scheduler Service's installation directory. By default, this is
C:\Program Files\Exago\ExagoScheduler on Windows and
/opt/Exago/Scheduler on Linux.
The following settings are available:
Settings that can be
falseare case sensitive and must use lower case.
<smtp_server> — The SMTP server used by the Scheduler Service to email reports.
<smtp_enable_ssl> — Set to
true to enable SSL.
<smtp_user_id> — The user id that is used to login into the SMTP server.
If the user id is set to a null or empty value or DefaultCredentials, the value automatically defaults to the user's current credentials. For anonymous emailing see the Credential-less SMTP section below.
<smtp_password> — The password that is used to login into the SMTP server. This value is only considered when using the user id as an SSL credential.
If the password is set to a null or empty value, the value automatically defaults to the user's current credentials.
<smtp_from> — The 'From' email address used in the report emails.
<smtp_from_name> — The 'From' name used in the report emails.
<error_report_to> — The email address to send error reports to.
http — must match the setting of the Remote Host in the Admin Console Scheduler Settings.
<port> — The port number of the .NET remoting object used to communicate with Exago; this should also be entered in the Admin Console Scheduler Settings.
<working_directory> — The directory where scheduled documents and temporary files are written. The default setting
[INSTALLDIR]working creates a
working folder in the Scheduler Service's installation location.
<default_job_timeout> — The maximum number of seconds any report execution is allowed. If an execution reaches a maximum number of seconds an email will be sent to the address specified under
<default_job_timeout>is outdated. Use
<max_job_execution_minutes>instead. Do not use both, as this could result in inconsistent timeout behavior.
<report_path> — A path to specify where to save reports when 'Email Scheduled Reports' is set to
false in the Admin Console. For more details see Saving Scheduled Reports to External Repository below.
<sleep_time> — The time interval (in seconds) used for polling for scheduled reports to execute.
<simultaneous_job_max> — The maximum number of report executions that can occur simultaneously. This setting is based on the resources available of the server where the Scheduler Service is installed.
<logging> — Logging is on by default. To turn logging off, set to
OFF (in all-caps). To configure logging, edit the Logging Settings in the
<flush_time> — The number of hours that a completed, deleted, or aborted job will be saved for viewing in the schedule reports manager. Set to 0 to flush jobs immediately upon completion. Set to -1 to disable automatic flushing.
<sync_flush_time> — The flush time for synchronous (non-scheduled remote) jobs.
<email_addendum> — Text that will be added at the end of email body. Use
\n to insert lines.
<external_interface> — This is optional and overrides the value set in the admin config. The advantage of setting the value here is that the existing scheduled reports that have a previous external interface value will take the new value. For more details see External Interface.
<abend_upon_report_error> — This controls how the scheduling service should proceed if an error occurs while loading or executing a report. The default
true will stop the running the schedule and set the status to Abended. Set to
false to continue running the schedule and maintain the status as 'Ready'.
<ip_address> — Binding IP address for the Scheduler Service. Most commonly used when the server has multiple Network Interface Cards (NICs).
<encrypt_schedule_files> — Set to
true to encrypt the files created by the scheduling service. All existing schedules will be encrypted the next time the service is started.
<max_temp_file_age> — The number of minutes between each flush of the temp files created by the scheduling service. The default is 1440 minutes (24 hours).
<max_temp_file_agetoo low may result in errors as temp files are used during report execution and for interactive HTML capabilities when using remote execution. It is not recommended setting this value any lower than 60 minutes. Execution cache files will not be flushed.
<email_retry_time> — In the case an email fails to send, the number of minutes to wait before retrying to send the email. After five failed attempts the schedule will set itself to 'Aborted'. The default is 10 minutes.
<max_job_execution_minutes> (v2016.2.12+) — Maximum amount of time (in minutes) to run an execution job before timing out. If the job times out, the schedule will be marked as 'Aborted'.
Do not set both this setting and
<default_job_timeout>at the same time. This could result in inconsistent timeout behavior.
<secure_channel> (v2016.3+) — Set to
true to allow receipt of encrypted data from hosts. The setting Use Secure Scheduler Remoting Channel must be
true in the Web Application config.
<security_protocol> (v2016.3.4+) — Specify which security protocol(s) the scheduler should use. Possible values:
Ssl3, Tls, Tls11, Tls12, Tls13 (.NET v4.6+). Separate multiple values with commas (,).
<service_name_tag>— For manual installation of Scheduler Services using Visual Studio installutil.exe, this field is appended to the end of the service name. Useful for installing multiple services on the same server. installutil.exe must be in the same folder as the scheduler configuration file.
<webappbaseurl> — Set to the virtual directory URL where the Exago BI Web Application is installed. In Cross-Origin Resource Sharing (CORS) environments, setting this flag ensures that images are correctly loaded.
Example XML File
<?xml version="1.0" encoding="utf-8" ?> <eWebReportScheduler> <smtp_server>smtp.office365.com:587</smtp_server> <smtp_enable_ssl>true</smtp_enable_ssl> <smtp_user_id>firstname.lastname@example.org</smtp_user_id> <smtp_password>SMTP_Password</smtp_password> <smtp_from>email@example.com</smtp_from> <smtp_from_name>Exago Scheduler</smtp_from_name> <error_report_to></error_report_to> <channel_type>tcp</channel_type> <port>2022</port> <working_directory>[INSTALLDIR]working</working_directory> <default_job_timeout>3600</default_job_timeout> <sleep_time>15</sleep_time> <simultaneous_job_max>1</simultaneous_job_max> <logging>debug</logging> <flush_time>-1</flush_time> <sync_flush_time>0</sync_flush_time> <email_addendum></email_addendum> <external_interface></external_interface> <report_path>[INSTALLDIR]</report_path> <abend_upon_report_error>true</abend_upon_report_error> <ip_address></ip_address> <security_protocol></security_protocol> <encrypt_schedule_files></encrypt_schedule_files> <max_temp_file_age>1440</max_temp_file_age> <email_retry_time>10</email_retry_time> <queue_service></queue_service> <webappbaseurl>http://server/Exago/</webappbaseurl> </eWebReportScheduler>
Starting and Changing Scheduler Services
The Windows Service will have to be manually started for new installations of the Scheduler. Starting the service will create the working directory as set in
<working_directory> described above.
To start the scheduler open Windows Services. Double click on 'ExagoScheduler' and the Properties menu will appear. Click Start.
If any changes are made to the configuration (detailed above) the service must be stopped and restarted for the changes to take effect.
Credential-less SMTP v2018.1+
Within Scheduler Configuration, the values for
<smtp_from_name>, which constitute the required SMTP credentials for non-anonymous emailing, cannot be removed or left blank. Otherwise, these values will be reset to their default or throw an error when attempting to send an email.
However, credential-less SMTP servers can now be used to send anonymous emails by making the following changes within the
eWebReportsScheduler.xml file. This file is located in the Scheduler Service's installation directory.
To set up anonymous report emailing:
<smtp_password>to any non-null value
Any scheduled report using these credentials will be sent anonymously when connected to an SMTP server that does not require credential authorization.
Saving Scheduled Reports to a Repository
Instead of sending report output as an e-mail, the output file can be saved to a file repository instead. To enable this:
- Provide a Report Path in the Scheduler Service's configuration file. This is the location where the Scheduler Service will save the report output files. Add the
<report_path>element if it does not yet exist and set the location of the repository.
This report path is the location of the scheduled report output archive, and should be different than Exago's Report Path configuration setting.
- In the Admin Console set General > Scheduler Settings > Email Scheduled Reports to False.
After applying these settings, generic scheduled reports (i.e. the schedule does not run as a batch) will be saved directly to the specified repository rather than being sent via email.
If the General > Scheduler Settings > Show Schedule Delivery Type Options setting is True, users can select whether to save a scheduled report to the specified repository or to send it via email.
Output files will be saved to the
<report_path> directory with the filename based on the Scheduler Service's working file GUID with _Download appended. For example,
Refer to the Managing Scheduled Executions with Server Events and External Interface article for more information.