Conditional Scheduling of MS Analysis Jobs

Hi All,

I'm trying to understand, if there SSAS 2005 supports conditional sequencing of jobs.

I wanted to know if there is a way to schedule few critical cube refresh jobs first and then sequence other jobs.

Example: Cubes with Customer XYZ should be refreshed first and then Cubes for PQR and so on.

Appreciate, if you can throw some light on this.

Regards,

Dash

If you wanted to have particular order for processing of your partitions and dimensions (processing of cubes always results in processing of partitions and dimensions) you should simply build a processing batch consisting of commands in particular order.

For that run Processing dialog in SQL Management studio. Select the objects you like to process and then click on the Scrip button on the top of the dialog. You will see processing command generated for you. You can tweak the command any way you like.

Some additional info for you:

http://msdn2.microsoft.com/en-us/library/ms345142.aspx

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1238273&SiteID=1