In e-Synergy several functionalities are dependent on the jobs defined in MS SQL Server Agent. These jobs are scheduled and take over tasks like import financial transactions, sending mails to the mail server, calculation customer ratings. Next a explanation is given about the installation of e-Synergy as well the configurations of the applications jobs, MS SQL Server Agent, Outlook Express and Excel. The application or the SQL database server is setup from scratch when for example the server's hardware is replaced, when the operating software is re-installed or when no e-Synergy environment is been installed before.
Setting up the application server can be different for every company. When a optimal performance is required of the SQL Database server than it might be considerable to set up an application server for running the background job. Otherwise running the background jobs on the SQL Database server would be sufficient. The following list can be used to set up the application or SQL Database server.
Before the installation of e-Synergy is started it is recommended that the server meets the following minimum software requirements:
Check if the requirements and configuration of the software has been done properly by using the documents:
The installation procedure to install e-Synergy on an application server is partly the same as when an installation is performed on a web server. The document " e-Synergy installation web server " describes the installation procedures.
As mentioned in the "Introduction" the application server is used to import financial transactions in the main database. To support this import the financial replication tools must be installed after the installation of e-Synergy. The document "Installation replication components" describes three scenario's that can be used to install these tools.
Note 1
When e-Synergy is not installed on the application server the background jobs will not function.
Note 2:
Update e-Synergy on the application server after e-Synergy on the webservers are updated. Not updating e-Synergy on the application server might cause that the SQL jobs will not run properly.
In e-Synergy several functionalities are dependent on the jobs defined in MS SQL Server Agent. But in order to run all jobs properly the settings of the SQL Server Agent must be configured. The document "Configuration MS SQL Server Agent " describes which setting should be adjusted in the properties of the SQL Agent Server.
When installing MS Excel select the option 'Prerequisites' in order to copy al required components of MS Excel on the server. This will prevent that Excel will ask to the MS Office installation software when Excel is opened or used. No changes in the Excel configuration has to be made after the installation of Excel. Check if Excel can be started.
In order to work with e-Synergy mail merge the configuration of MS Outlook Express of the application server must be set. The document "Configuration Outlook Express " describes the configurations of MS Outlook Express.
The backgrounds applications should be defined on the application server. During this process the following documents can be usefull:
Note: instead of using the MS SQL Server to set up the application jobs the Windows Task Scheduler can be used: