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:
We will have to:
- Provide SSAS server name.
- Make sure the in the SQL server Job Step the Run as proxy has Analysis Services Command, Analysis Services Query, and Operating System.