Skip to main content

Maintenance jobs

This section describes the maintenance jobs of the Adobe Creative Cloud functionality in Snow License Manager.

SQL Server Agent Job​

A non-clustered index is created to enhance the query performance within the Adobe Creative Cloud environment:

  • Index name: XI_UserId

  • Table: [adobecc].[LinkedSlmUserDetails]

  • Column: UserId

  • Included columns: TenantId, AdobeCCEmail, OrgCheckSum

How it operates​

The SQL Server Agent Job adobecc.RebuildIndexesJob maintains index performance based on the level of fragmentation. The job is scheduled to run nightly at 02:30:00, and it performs maintenance as follows:

  • For fragmentation < 10%: No action, the index is skipped.

  • For fragmentation between 10% and 30%: The index is reorganized.

  • For fragmentation > 30%: The index is rebuilt.

This schedule can be adjusted to meet specific client requirements.

If you want to modify the schedule, do the following:

  1. Open SQL Server Management Studio.

  2. In the SQL Server Agent section, find the adobecc.RebuildIndexesJob job.

  3. To open and see its properties, double-click the job name.

  4. In the left-side menu, select the Schedules tab.

  5. Adjust the execution time as needed, and then save your changes.