Nightly Backup Jobs Did Not Run

NIGHTLY BACKUP JOBS DID NOT RUN

Scenario: 

Users’ login to VohCom and a pop-up appears with the message: Nightly Jobs did not run. Do you want to run them now? Backup Job did not run. Please contact your IT person.                                         

Solution: 

1. Login to your server or the PC where your VohCom SQL database is installed.
   
   A quick way to determine where your VohCom SQL database is installed:
   
   The first section of the highlighted information will be the Computer Name of where the VohCom SQL and backups reside [ComputerName\InstanceName-DatabaseName].
2. Open services.msc and verify the following services are started and running: VSI Nightly Jobs and Email Notifier.

Right-click Start > Run > Type in services.msc > OK

If any of these services are not running, select them individually then click Start from the top, left panel menu (or right-click > all tasks > start).

Search and select the Email Notifier service > click START

Repeat actions above for the VSI Nightly Jobs service.

3. Run the backup manually. After you’ve successfully run the backup manually it should continue running automatically without any user input. Choose 1 of the options below.

OPTION 1 

Navigate to this location: C:\Program Files (x86)\VohCom Software\VohComJobs > Double-click to open VohComServiceManager

Click Run Daily Maintenance Job Now. Wait until you see the message: Finished.

Click Run Backup DB Job Now. Wait until you see the message: Finished.

OPTION 2

Right-click Start > Run the Command Prompt (or Windows Powershell) as an Administrator

Within the shell > Navigate to C:\Program Files (x86)\VohCom Software\VohComJobs

To run the backup job manually:

"C:\Program Files (x86)\VohCom Software\VohComJobs\VSIUtility.exe" /vsi=dbbackup

To run the maintenance job manually: 

"C:\Program Files (x86)\VohCom Software\VohComJobs\VSIUtility.exe" /vsi=maintenance

4. Login to VohCom > verify you no longer see the ‘Nightly Jobs did not Run’ warning.  If the warning still appears, proceed with the instructions below.

If you’re still see the warning, the user account that’s being used to run the VohCom Backups Services may not have the correct permissions to access the vohcomr1 database.

5. This script will help with assignng the correct permissions to the vohcomr1 database. Download and unzip: addselftosqlsysadmin.zip 

Important: Before you run this script everyone must close VohCom. 

Enter SQL instance name: vsinc

Do you want to continue this operation: y

Press any key to close the Command Prompt.

6. Repeat steps 3 and 4

7. Login to VohCom > Verify you no longer see the ‘Nightly Jobs did not Run’ warning. 

Additional (optional):

Change the Log on As for the Email Notifer and VSI Nightly Jobs services from ‘Local System’ to ‘the user account you just added to the vohcomr1 sysadmin’ then repeat steps 3 and 4.

8. Repeat step 2 > right-click VSI Nightly Jobs > Properties > Log On > Select ‘This Account’ > Browse and change the User Account > OK

9. Repeat step 8 for Email Notifier Service