Automation

SQL Server Analysis Services Data Mining automation allows you to schedule and manage the execution of data mining models, including updates and deployments. You can use SQL Server Agent to schedule automated runs, and configure model update frequency based on your requirements.

Scheduled Model Updates

You can create a SQL Server Agent job to update data mining models on a regular basis, such as daily, weekly, or monthly. This ensures that your models are always using the most recent data.


-- Create a SQL Server Agent job
CREATE JOB UpdateDataMiningModels
    ON SERVER
    WITH (
        LEVEL = NIGHTLY,
        RECOVERY = FULL
    );

-- Add a step to the job to update data mining models
ADD STEP
    @job_name = 'UpdateDataMiningModels',
    @step_name = 'Update Models',
    @statement = 'UPDATE DataMiningModels.Model WITH (UpdateFrequency = ''Daily'')'
    ;

For more detailed information, see the following topics:

Scheduling Data Mining Model Updates
Deployment