Skip to main content

0-Create Schema Job

The 0-Create Schema job within the 0.Collection job group creates and updates the schema for the tables, views, and functions used by the rest of the File System Solution. This job needs to run prior to the other jobs in the 0.Collection job group for both new installations and upgrades. The job can be scheduled with any of the collections. Do not delete the job from the job tree.

RECOMMENDED: This job does not need to be moved. Leave it to run as part of the 0.Collection job group.

Analysis Tasks for the 0-Create Schema Job​

View the analysis task by navigating to the FileSystem > 0.Collection > 0-Create Schema > Configure node and select Analysis.

CAUTION: Do not modify or deselect the selected analysis tasks. The analysis tasks are preconfigured for this job.

Analysis Selection for the 0-Create Schema Job

The following analysis tasks are selected by default:

    1. Create Tables – Creates all tables prefaced with SAFSAA
    1. Create DFS Tables – Creates all tables prefaced with SAFSDFS
    1. Create DLP Tables – Creates all tables prefaced with SAFSDLP
    1. Create FSAC Tables – Creates all tables prefaced with SAFSAC
    1. Create Rename Targets – Creates the SA_FSAC_Rename Targets tables
    1. Create Paths View – Creates the SA_FSAA_Paths view
    1. Update data types – Access Analyzer uses custom SQL data types to render data. This analysis creates updates to those data types.
    1. Import new functions – Creates functions used in the File System Solution that only reference the .Active Directory Inventory job group data
    1. Import new functions – Creates the FSAA functions used in the File System Solution that reference the 0.Collection job group data
    1. Create exception types – Creates the SA_FSAA_ExceptionTypes table
    1. Create views – Creates the SA_FSAA_DirectPermissionsView
    1. Create Exceptions Schema – Creates the SA_FSAC_Exception table and the SA_FSAC_ExceptionTypes table
    1. Create FSAC Views – Creates all views prefaced with SAFSAC
    1. Create Functions – Creates the FSAC functions used in the File System Solution that reference the 0.Collection job group data
    1. Create FSDLP Views – Creates all views prefaced with SAFSDLP
    1. Create DFS Functions – Creates the FSDFS functions used in the File System Solution that reference the 0.Collection job group data
    1. Create Azure Tables – Creates tables for Azure Files
    1. Data Migration – Migrates data from an older schema version