Re: [Emerald] SQL Tasks HELP ASAP

PowerNet ( (no email) )
Thu, 23 Sep 1999 14:57:20 -0400

But it does work some days and it has only taken 11 minutes when it says=
successful up until yesterday.

Thanks,
John

*********** REPLY SEPARATOR ***********

On 9/23/99, at 9:47 AM, Dale E. Reed Jr. wrote:

>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

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart