|
Home > Archive > MS SQL Server > October 2006 > SQLAgent never stop a backup job and consume CPU (SQL2000)
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQLAgent never stop a backup job and consume CPU (SQL2000)
|
|
|
| Hi,
on an SQL 2000 server I'm using the maintenance plan to manage my backups
etc...
in the last year, no problem.
but in the last weeks I see that the job never ends!!!!
the SQL Agent consume 38% of my CPU and the never stops.
the backup is done correctly, the files are created normally.
so what's appends with the agent?
I must stop the agent AND sql server himself.
if I stop the agent only, I can't restart it until I restart SQL Server.
any ideas of what's appends?
thanks.
Jerome.
| |
| John Bell 2006-10-24, 6:33 pm |
| Hi
I am not sure as to the reason for this, I suppose you could use SQL
profiler to see what commands the agent is running, or possibly drop and
re-create the job to see if that cures it.
John
"Jeje" wrote:
> Hi,
>
> on an SQL 2000 server I'm using the maintenance plan to manage my backups
> etc...
> in the last year, no problem.
>
> but in the last weeks I see that the job never ends!!!!
> the SQL Agent consume 38% of my CPU and the never stops.
>
> the backup is done correctly, the files are created normally.
>
> so what's appends with the agent?
>
> I must stop the agent AND sql server himself.
> if I stop the agent only, I can't restart it until I restart SQL Server.
>
> any ideas of what's appends?
>
> thanks.
>
> Jerome.
>
>
>
|
|
|
|
|