I think we have quite a bit of memory allocated to SQL, and until=
yesterday, the task completed in about 11 minutes when it didn't fail.
This task fails every other day.
Yesterday the task completed in 1 hr and 12 minutes
Today it was not finished after 8 hours.
Or consolidation has also taken forever in the past 2 days.
I am baffled.
Thanks,
John
*********** REPLY SEPARATOR ***********
On 9/23/99, at 11:12 AM, Josh Hillman wrote:
>John, what's the script that the task is running?
>You may be trying to process too much information at once and you don't=
have
>enough memory allocated to SQL to allow it to run efficiently (at least
>while running this script).
>
>Josh
>
>----- Original Message -----
>From: PowerNet <psc5@powersupply.net>
>To: <emerald@iea-software.com>
>Sent: Thursday, September 23, 1999 9:51 AM
>Subject: [Emerald] SQL Tasks HELP ASAP
>
>
>I need help with a scheduled task ASAP, some users are not getting logged
>on.
>
>After further review, I am looking at SQL Ent. Manager and the Emerald
>Update Calls Account task is still running at 10AM when it started at
>2:30AM.
>
>This is the task that has been failing every other day.
>When it does work, it normally takes about 11 minutes.
>Yesterday, when it was successful, it took 1hr 12 minutes. That is way
>longer than normal.
>
>Today, well it started at 2:30 am and it is now 10 AM and still running.
>
>I hope I won't hurt anything, but I would like to stop this task.
>
>Any ideas ASAP?
>
>Thanks,
>John
>
>For more information about this list (including removal) go to:
>http://www.iea-software.com/support/maillists/liststart
>
>
>
>For more information about this list (including removal) go to:
>http://www.iea-software.com/support/maillists/liststart
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart