Processing of cubes in a scheduled DTS

Hi everyone!

I created a DTS which does some data transformations before processing some cubes. It finished processing in abt 10mins when I run this DTS manually. However, when I schedule this DTS to run, it took around 3 over hours to run. Does anybody know where the problem lies? I have been looking for a solution for this for a long time and I'm hoping that somebody can help me...

Thank you!! :)

MichelleDo you have the latest SP on the server? I seem to recall something in sp3 that is supposed to help this|||My database is in a different server from the cube. The SQL server for this database is Server 2000, service pack 3a. The one for my cubes is version 7.00.623. Will the difference in version slow down the process?

Process the subscription from asp.net

I have a dot net web application that needs to, eventually, send a report by
e-mail It doesnâ't have a scheduled behavior.
Is there any way of processing subscriptions from asp.net?
Thanks!Perhaps this article can help you:
http://www.odetocode.com/Articles/114.aspx
"luczinski" wrote:
> I have a dot net web application that needs to, eventually, send a report by
> e-mail It doesnâ't have a scheduled behavior.
> Is there any way of processing subscriptions from asp.net?
> Thanks!
>

Process runnable but wait indefinitely

There's a job that is scheduled to run indefinitely. The process's status is
"runnable" but it does nothing. It has the lastwaittype = CMEMTHREAD, kpid
= 3296, and it's not blocking any other processes or being bloked.
The waitresource is blank.
Please help!
DN
On Jul 26, 3:50 am, "DN" <tie...@.hotmail.com> wrote:
> There's a job that is scheduled to run indefinitely. The process's status is
> "runnable" but it does nothing. It has the lastwaittype = CMEMTHREAD, kpid
> = 3296, and it's not blocking any other processes or being bloked.
> The waitresource is blank.
> Please help!
> DN
Hi, what is the status on profiler? Do you see the counter increase
under the reads column?
|||Do you see the physical IO and CPU columns changing in sysprocesses
for that SPID, if so, then you might have to wait for it to complete.
Keep running sysprocesses to check if you see any changes in
lastwaittype.

Process runnable but wait indefinitely

There's a job that is scheduled to run indefinitely. The process's status is
"runnable" but it does nothing. It has the lastwaittype = CMEMTHREAD, kpid
= 3296, and it's not blocking any other processes or being bloked.
The waitresource is blank.
Please help!
DNOn Jul 26, 3:50 am, "DN" <tie...@.hotmail.com> wrote:
> There's a job that is scheduled to run indefinitely. The process's status is
> "runnable" but it does nothing. It has the lastwaittype = CMEMTHREAD, kpid
> = 3296, and it's not blocking any other processes or being bloked.
> The waitresource is blank.
> Please help!
> DN
Hi, what is the status on profiler? Do you see the counter increase
under the reads column?|||Do you see the physical IO and CPU columns changing in sysprocesses
for that SPID, if so, then you might have to wait for it to complete.
Keep running sysprocesses to check if you see any changes in
lastwaittype.

Process runnable but wait indefinitely

There's a job that is scheduled to run indefinitely. The process's status is
"runnable" but it does nothing. It has the lastwaittype = CMEMTHREAD, kpid
= 3296, and it's not blocking any other processes or being bloked.
The waitresource is blank.
Please help!
DNOn Jul 26, 3:50 am, "DN" <tie...@.hotmail.com> wrote:
> There's a job that is scheduled to run indefinitely. The process's status
is
> "runnable" but it does nothing. It has the lastwaittype = CMEMTHREAD, kpi
d
> = 3296, and it's not blocking any other processes or being bloked.
> The waitresource is blank.
> Please help!
> DN
Hi, what is the status on profiler? Do you see the counter increase
under the reads column?|||Do you see the physical IO and CPU columns changing in sysprocesses
for that SPID, if so, then you might have to wait for it to complete.
Keep running sysprocesses to check if you see any changes in
lastwaittype.