We have a Job in SQLServer Agent running various processes and stored procedures, on a monthly basis.
We would like this process to finish with a cube build. A batch is prepared for this task, which runs successfully when started on its own, but doesn't work when added to the Job (the job hangs at the cube build step). Cognos Scheduler also works, however, we need to find a way of attaching the cube build to the other data processes.
We would like this process to finish with a cube build. A batch is prepared for this task, which runs successfully when started on its own, but doesn't work when added to the Job (the job hangs at the cube build step). Cognos Scheduler also works, however, we need to find a way of attaching the cube build to the other data processes.