Job schedule - setting exceptions

• MartinIsti

  Mr or Mrs. 500

  Points: 540

  More actions

  February 5, 2008 at 1:24 am

  #183740

  Hello guys,

  I have to create an efficient processing strategy for AS2005 cubes for our client and an interesting issue came up:

  e.g. every weekend I run a package that processes the actual partition of the Cube and at the end of the month I make a full process. But when the full process takes place I don't want the weekly partition process to run. So far I haven't found a possibility for setting this directy in the scheduling interface.

  To be more simple: 😉

  w01 - partition process

  w02 - partition process

  w03 - partition process

  w04 - full cube process (and NO partition process!)

  Is it possible to do this without creating a .net script for it?

  Thanks in advance,

  MartinIsti

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  February 5, 2008 at 5:31 pm

  #775389

  How about this?

  Create 3 schedules for the partition process:

  Monthly 1st Saturday of every 1 month

  Monthly 2nd Saturday of every 1 month

  Monthly 3nd Saturday of every 1 month

  Create 1 schedule for the full process:

  Monthly 4th Saturday of every 1 month

  Greg