|
<< Click to Display Table of Contents >> Navigation: Reports > Mill7 reports > Scheduler |
The scheduler is used to run reports that are scheduled or that need to be run directly via the server.
This option is only available in the Mill7 Trust version.
The report scheduler needs be started (for example, on the server) to execute the scheduled reports.
Select the report to be scheduled.
Set all selections and print fields and choose <Schedule>.
There is no need to save the report because the scheduler will automatically create a copy of the report.
The screen 'Schedule reports' opens.
A user can only see and delete his own tasks.
The user SUPERV can see and delete all tasks from all users.
Report
The report to be scheduled. To be able to change the report the schedule screen should be closed first and then another report can be chosen in the report module.
Date and Time
The date and time to execute the report have to be set.
Recurrence
Possible options are one-time, daily, weekly and monthly
–A report scheduled for one-time will be deleted from the list after being executed.
–After been executed a report scheduled daily will be re-scheduled automatically for the same time next day.
–After been executed a report scheduled weekly will be re-scheduled automatically for the same time/day next week.
–After been executed a report scheduled monthly will be re-scheduled automatically for the same time/day next month.
Output
There are three output options:
–printed
The report is printed on the printer which on the server is set as the default printer.
–send by e-mail
The report is sent to the e-mail address entered at the user who scheduled the report. If no e-mail address is found the report is printed
–saved as an excel file.
The output folder must be a network folder that is also accessible on the server where the report scheduler is running. For example, if the output folder is M:\reports then that folder must be accessible on the server.
Schedule
With the button <Schedule> the report will be scheduled and add to the list.
Delete task
With the button <Delete task> a selected report will be deleted from the list.
Reports can only be sent by E-mail if a SMTP server is available.
To be able to send a scheduled report the SMTP settings in the main bookkeeping must be set. These settings are used in both service companies and client bookkeepings.
When the SMTP settings in the main bookkeeping are not correct the report will be sent to the printer.
The report is sent to the e-mail address of the user that scheduled the task.
This e-mail address can be entered in menu Supervisor> Users> Maintenance.
When no e-mail address is found the report will be sent to the printer.
To actually execute the scheduled reports, the scheduler must run constantly on a workstation or server.
The scheduler can be started from the command line or with a shortcut: "reports.exe"
This command reports.exe must be executed from the Mill7\Prog20 directory.
To log in the scheduler, the password of the user SUPERV must be entered.
After logging in the screen 'Batch reports' pops up.
The scheduler is now active and will execute the scheduled reports on time.
Report scheduler shut down
Users are blocked manually through the Supervisor> user menu or when updating Miil7 and during re-indexing.
Blocking users will also block the report scheduler.
The report scheduler however is not started automatically after the users are released.
This must be done manually.
Log activities via settings button
In the scheduler a log function can be activated.
For this purpose a folder for the storage of log files needs to be appointed as well.
When the logging is activated various activities, events and characteristics involved in the process of creating a report will be registered in a log file. The logging could be activated temporarily to support tracking down errors that occur during the creation of reports.
The name of a log file consists of the scheduled date and time, a report code and the name of the report followed by the ".log" file extension.
With each execution of a report a new log file will be created.
Keep in mind that the number of log files will increase in the course of time.
Log files may be removed when they become redundant.
Reports expired will be executed right away when the scheduler is started.
–Reports planned daily are executed 1 time and re-scheduled for the next day.
–Reports planned weekly are executed 1 time and re-scheduled for 1 week later counted from the execution day.
–Reports planned monthly are executed 1 time and re-scheduled for 1 month later counted from the execution day.
Interval (sec) via settings button
By default, a check is made every 60 seconds to determine whether a report needs to be executed.
By adjusting this setting, the time can be adjusted to determine how quickly the check takes place.
Executing reports in batch
It also possible to start the report tool in batch mode by using the command reports.exe 0 0 1.