How to create train consume and delete the SSAS mining / prediction / forecasting model using SQL server job

We have to create separate SQL server job steps each for creatingtraining, and deleting as described below.

We can manually delete by opening SSMS and connect to Analysis Server and deleting the mining structure / model.

Now if we want to automate this using SQL server job, how to go about it?

Create job step of the type SQL Server Analysis Command and the command is:

<Delete xmlns=”http://schemas.microsoft.com/analysisservices/2003/engine”&gt;

StudentRetentionModels
Decision_Tree_8_3_1_Structure

</Delete>

 

We will have to:

  1. Provide SSAS server name.
  2. Make sure the in the SQL server Job Step the Run as proxy has Analysis Services Command, Analysis Services Query, and Operating System.
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s