Run the following script in SQL Server Management Studio to stop the Data Update Job:

--Step 1: Stop the job if necessary

USE msdb

GO

EXEC dbo.sp_stop_job

N'License Manager Data Update'


--Step 2: Update Job Status

Use SnowLicenseManager

UPDATE tblJobStatus

SET LastJobStatus = 'Job finished successfully'


--Step 3: Update the log

Use SnowLicenseManager

UPDATE tblJobLog

SET Message = 'Job finished successfully'

WHERE JobType = 'JOB_RUN'


--Step 4: Update System Info table (note this is needed to tell IIS to allow access to the SLM)

UPDATE tblSystemInfo

SET LastJobStatus = 'Job finished successfully'


--Step 5: Zeroing out the temp tables

USE SnowLicenseManager

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


--Step 6: Complete_Ruleset reset

USE SnowLicenseManager

UPDATE dbo.tblSystemInfo SET LastJobResetRulesDate = LastJobDate

NOTE: The Snow Management and Configuration Center (SMACC) windows may continue to display running items after the script completes. Restart SMACC to refresh the display. The window should then appear empty as expected.

If you are stopping the Data Update Job because it is taking an unusually long time to complete, see Data Update Job execution time increases due to the size of the dbo.tblSoftware table for additional steps to take after the DUJ is stopped.