In some environments, the SQL Agent job o365.RebuildIndexesJob may fail even though other jobs owned by LicenseManagerUser continue to run successfully. This article explains the cause of the failure and how to resolve it.

Error details

Date: 5/5/2025 1:15:00 AM
Server: SNOWPRDSQL
Job Name: o365.RebuildIndexesJob
Step Name: RebuildIndexesForUserReadModelUsersPerSubscriptionPlanLinkedSlmUserDetails
Duration: 00:00:00
SQL Severity: 16
SQL Message ID: 297
Retries Attempted: 3

Executed as user: LicenseManagerUser.

The user does not have permission to perform this action. [SQLSTATE 42000] (Error 297).

NOTE: The step was retried the requested number of times (3) without succeeding.

The step failed.

Cause

The job runs index fragmentation checks and rebuilds/reorganizes indexes on tables in the O365 schema of the SnowLicenseManager database. This process relies on the dm_db_index_physical_stats function, which requires VIEW SERVER STATE permission when called with NULL parameters.

If LicenseManagerUser does not have this permission, the job will fail.