RockSolid Admin
posted this on August 05, 2010 06:12
Yes however with some prerequisites. As SQL Server Analysis Services does not contain a job scheduler (the SQL Agent) there are two ways in which the backup jobs can be scheduled.
The first way is to instruct RockSolid to schedule the backup commands to be executed via the Windows Scheduler. This option requires the Windows Scheduling service to be enabled and the RockSolidAgent service account to have the necessary rights on the Analysis Services server to create new scheduled jobs.
The second way is to instruct RockSolid to schedule the backup commands via the SQL Agent of a SQL Server Database Services Instance that is installed on the same physical server. This option of course requires an installation of SQL Server Database Services (SQL Server) on the same server as SQL Server Analysis Services is installed.
The scheduling method is part of the instance policy.