SOLO Server Database Jobs

General Information:

• The SOLO Server database installation installs all jobs as disabled, so they must be manually enabled by the user in order run. To enable the jobs if using a non Express version of SQL Server:
  • Connect to the database server using SQL Server Management Studio (SSMS).
  • In Object Explorer, expand the SQL Server Agent node, and then the Jobs node.
  • Right click on the job and click Enable.
• Express versions of SQL Server do not include SQL Agent (used to automate the running of these jobs), so an alternate method is needed to run these jobs on SQL Express:
  • You can use a 3rd party replacement for SQL Agent.
  • You can set these up to be launched as a scheduled task using Windows built in task scheduler. To configure the jobs to run through Task Scheduler:
    • In Windows Task Scheduler, choose File, Create Task.
    • On the General Tab:
      • Specify a Name and optionally a Description.
      • Click Change User or Group..., and change the user account to the account the web site is running under.
      • Select the Run whether user is logged in or not option.
    • On the Triggers tab:
      • Click New...
      • Use the default Begin the task option of On a schedule.
      • Select Daily and set a Start time (see recommendations below).
      • Click OK.
    • On the Actions tab:
      • Click New...
      • Use the default Action of Start a program.
      • Enter the Program/script to run (see file details below).
      • Click OK.
    • The defaults on the remaining tabs should be OK. Click OK to save the task.
    • Verify functionality by manually running the task.
• SOLO Server jobs are scheduled to run in the early morning. They have been scheduled with no overlap to avoid job conflicts. Any custom jobs added, including maintenance scripts, should follow the same approach. The recommended script windows are as follows:
  • Midnight - 3AM: Database maintenance jobs (backups, integrity checks, optimizations, transaction log backups).
  • 4AM - 5AM - Reserved for SOLO Server jobs. All standard SOLO Server jobs are scheduled by default to run in this time frame.
  • 5AM onward - Custom job scripts

SOLO Server Daily Processing

• Description - Runs all active Daily Processes.
• Schedule: Daily at 4:00AM.
• Executable file: %InstallDir%\SOLO\Database\Jobs\DailyProcessor\DailyProcessor.exe. The DailyProcessor.exe.config configuration file in the same directory as this must be set up with the proper values after installation. The file contains comments on each variable that needs to be configured. When configuring this job using Windows Task Scheduler, you can simply navigate to and select this file using the Browse... button.

SOLO Server Process Payment Plan Payments

• Description: Processes all payment plan payments scheduled for a given day. This job only needs to run if payment plan items are being sold through SOLO Server.
• Schedule: Daily at 4:30AM.
• Script file: This job calls a vbs script file which will need to be manually configured. The file is located at %InstallDir%\SOLO\SQLJobs\ProcessPaymentPlans.vbs on the database server. All configurable variables are located at the very top of the file as constants, and comments in the file describe each of them. When configuring the job in task scheduler this should use the 32 bit version of cscript.exe to call the script as follows (replacing %InstallDir% with the SOLO Serverinstallation directory):
  • For 32 bit operating systems, enter cscript.exe "%InstallDir%\SOLO\SQLJobs\ProcessPaymentPlans.vbs"
  • For 64 bit operating systems, enter C:\Windows\SysWOW64\cscript.exe "%InstallDir%\SOLO\SQLJobs\ProcessPaymentPlans.vbs"