Analysis services Database Processing

Hello Everyone.
I have a analysis services database and I want to schedule the automation of the database process. I copied the script generated by right clicking the analysis services database and  again clicking on process. I have the following script now can I  schedule this script to run everyday if so can you please provide me the steps to do that.

Script:
<Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
  <ErrorConfiguration xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:ddl200="http://schemas.microsoft.com/analysisservices/2010/engine/200" xmlns:ddl200_200="http://schemas.microsoft.com/analysisservices/2010/engine/200/200">
    <KeyErrorLimit>-1</KeyErrorLimit>
  </ErrorConfiguration>
  <Parallel>
    <Process xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:ddl200="http://schemas.microsoft.com/analysisservices/2010/engine/200" xmlns:ddl200_200="http://schemas.microsoft.com/analysisservices/2010/engine/200/200">
      <Object>
        <DatabaseID>Lab</DatabaseID>
      </Object>
      <Type>ProcessFull</Type>
      <WriteBackTableCreation>UseExisting</WriteBackTableCreation>
    </Process>
  </Parallel>
</Batch>

Thanks.
SaiRam77Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
puppydogbuddyConnect With a Mentor Commented:
Try using the MS Windows Task Scheduler.   The following links include coded examples.

http://technet.microsoft.com/en-us/library/bb726974.aspx

Task scheduler tutorial with Screenshots
http://www.iopus.com/guides/winscheduler.htm 
0
 
ValentinoVConnect With a Mentor BI ConsultantCommented:
There are several different ways to achieve this.  One of them is by using the SQL Server Agent to execute that script.

See following walkthough on MSDN for more info: http://msdn.microsoft.com/en-us/library/aa337506%28SQL.90%29.aspx
0
 
SaiRam77Author Commented:
Thanks ALL
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.