We will create the SQL agent job for processing the SSAS tabular model.
Below are the steps:
1. Connect to SSAS instance using SSMS
2. Expand the databases , right click on the preferred database and click on "Process database"
3.Now select the mode from drop-down menu, select FULL.
4.Click on Script and select "Script actions to new query window" from drop down menu.
5.It will generate the XMLA script. Click on cancel button if don't want to process database.
6.Copy the script and connect to SQL Server instance where it needs to be automated. expand the SQL agent and create new Job to automate it.
7. click on new step in the Job.
In the type choose "SQL server analysis command".
Run as --> use proxy account if u have in your environment else default option.
Server : use SSAS instance where XMLA code was generated earlier.
Command : Paste the XMLA code in command pane window. and click OK.
Schedule the Job as per the business requirement.
Below are the steps:
1. Connect to SSAS instance using SSMS
2. Expand the databases , right click on the preferred database and click on "Process database"
3.Now select the mode from drop-down menu, select FULL.
4.Click on Script and select "Script actions to new query window" from drop down menu.
5.It will generate the XMLA script. Click on cancel button if don't want to process database.
6.Copy the script and connect to SQL Server instance where it needs to be automated. expand the SQL agent and create new Job to automate it.
7. click on new step in the Job.
In the type choose "SQL server analysis command".
Run as --> use proxy account if u have in your environment else default option.
Server : use SSAS instance where XMLA code was generated earlier.
Command : Paste the XMLA code in command pane window. and click OK.
Schedule the Job as per the business requirement.
0 comments: