Skip to Content
Former Member
Jan 28, 2009 at 09:13 AM

Scheduling Full optimize in BPC 4.1



My question is related to Everest 4.1 (Hope there is still some knowledge about it).

I want to schedule a full optimize each night. I did it through the admin interface which allow user to schedule the task.

It created a job on SQL server (2000) named <<APPSET>>.

This job run the following command :

DTSRun /s <<ApplicationServer>> /u sa /e /n <<DTSPackage>>

So I opened the package in SQL Manager : it's empty beside the default properties of the packages.

Under Global Variables, there is 3 important variables :

  • FullProcess_option (integer)

  • Compress (boolean)

  • URL (string)

The "URL" variable is set to "HTTP://SJLBIFI2/oSoft/K2AdminSchedule.asp". So i presume that in this version of "BPC", it don't really use a DTS task like the newest version, but call an ASP page in order to run the Optimize.

Btw, if we run manually the optimize, it don't attack the same URL (request is sent to /OSOFT/K2AdminOptimize.asp).

So :

1. Do you know a workaround to schedule Full Optimize in Everest 4.1 ?

2. If not, was it referenced as a bug somewhere and is it corrected in a Service Pack for this version ?