Re: [Emerald] SQL Tasks HELP ASAP
Dale E. Reed Jr. ( (no email) )
Thu, 23 Sep 1999 09:47:46 -0700
PowerNet wrote:
>
> 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.
I'm guessing that it is finally actually working, and thats what is
taking so long. If might be able to kill the process in EM. However,
be leary of just stopping/restarting SQL Server as your Emerald DB
might go into recovery mode on that big of a transaction.
--
Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com
For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart