Step 1: Capture job history details

1. Connect to the SQL server using Remote Desktop (RDP).
2. Open SQL Server Management Studio.
3. In the object explorer, expand SQL Server Agent > Jobs.
4. Locate the job called License Manager Data Update.
5. Right-click the job and select View History.
6. Expand the bottom-right pane to see full messages (scroll as needed).
7. Take a screenshot of any error messages and save it as Attachment 1.

Step 2: Capture job status in Activity Monitor

1. Still in SSMS, open Activity Monitor.
2. Find License Manager Data Update in the list.
3. Take a screenshot of the job’s current Status and save it as Attachment 2.

NOTE: Do not stop the job or run any reset queries.

Step 3: Run diagnostic queries

1. Open a new query window in SSMS.
2. Copy and run the following seven queries:

SELECT * FROM msdb.dbo.sysjobhistory WHERE sql_severity > 0 ORDER BY run_date DESC, run_time DESC

SELECT * FROM SnowInventory.inv.DbVersionHistory

SELECT * FROM [SnowLicenseManager].[dbo].tblSystemInfo

SELECT * FROM [SnowLicenseManager].[dbo].[tbljoblog]

SELECT * FROM [SnowLicenseManager].[dbo].[tblJobLogHistory]

SELECT * FROM [SnowLicenseManager].[dbo].[tblErrorLog] ORDER BY LogDate DESC

SELECT * FROM [SnowLicenseManager].[dbo].[tblJobLogMetrics] ORDER BY JobDate DESC

3. For each result:
• Use Copy with Headers.
• Paste the results into separate tabs in an Excel file.
• Save the file as Attachment 3 (.xlsx).

Step 4: Check Snow Update Service history

1. Connect to the application server (RDP).
2. Open Snow Update Service.
3. Select View Update History.

4. Sort the list to show the most recent entries at the top.
5. Check Show Resource Updates if available.

6. Take a screenshot and save it as Attachment 4.

Step 5: Submit your attachments to technical support

Attach the following files to your support case:

• Attachment 1: Screenshot of DUJ job history
• Attachment 2: Screenshot of job status
• Attachment 3: Excel file with query outputs
• Attachment 4: Screenshot of update history

This information will help the Support team troubleshoot and resolve the DUJ issue efficiently.