Verify that LicenseManagerUser has the required permissions in the msdb database, and add the permissions if they are missing.

1. Run the following query as LicenseManagerUser:

   EXECUTE AS USER ='LicenseManagerUser'
   
   select * from
   msdb.INFORMATION_SCHEMA.TABLES
   Where TABLE_NAME='sysjobhistory'

   If the user does not have the required read permission, the query returns no results.

2. Run the following query:

   use msdb
   select * from dbo.sysjobhistory

   If the required permission is missing, the following error is returned:

   The SELECT permission was denied on the object 'sysjobhistory', database 'msdb', schema 'dbo'.

   

3. In SQL Server Management Studio, expand msdb > Security > Users. Right-click LicenseManagerUser and select Properties.

4. Select Membership and verify whether the required role memberships shown below are assigned.

   

5. Select the required roles shown below.

   

6. Select Securables, click Search, select Specific Objects, and click OK.

   

7. Click Object Types, select Tables, and click OK.

   

8. Click Browse and select the following tables:

   • dbo.sysjobhistory
   • dbo.sysjobs
   • dbo.sysjobsteps

   Click OK.

   

9. Click OK in the Select Objects window.

10. Under Securables, select sysjobhistory, sysjobs, and sysjobsteps one at a time and grant SELECT permission for each object. Click OK when finished.

    

11. Verify that the required permissions are now available:

    1. Run the following query again:

       EXECUTE AS USER ='LicenseManagerUser'
       
       select * from
       msdb.INFORMATION_SCHEMA.TABLES
       Where TABLE_NAME='sysjobhistory'

       The query should now return a result:

       

    2. Run the following query:

       use msdb
       select * from dbo.sysjobhistory

    3. Verify that the query returns rows from sysjobhistory without a permission error.

If the Data Update Job failed

If the DUJ failed, reset the applicable job tables before running the job again.

1. Stop the job if necessary:

   USE msdb
   GO
   EXEC dbo.sp_stop_job
   N'License Manager Data Update'

2. Update the job status:

   UPDATE tblJobStatus
   SET LastJobStatus = 'Job finished successfully'

3. Update the log:

   UPDATE tblJobLog
   SET Message = 'Job finished successfully'
   WHERE JobType = 'JOB_RUN'

4. New Step for SLM 9: Reset the DUJ 2.0 temporary tables

   USE SnowLicenseManager
   update inv.tblJobParallelStep set [Status] = 0 where Status = -1

5. Update the System Info table. This step is required to tell IIS to allow access to Snow License Manager.

   UPDATE tblSystemInfo
   SET LastJobStatus = 'Job finished successfully'

6. Run the Data Update Job as scheduled or manually.