Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Problem with SQL server Agent Jobs - Strange! :(

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-09-23 : 09:24:55
Mikael writes "Hi there,

I have run into a wall here I can not for the life of me figure this one out!
This server has been running for almost 1 and half years without ANY problems... untill now!

Spec:
MS SQL ver. 7.0 Ent Edt SP 3
Proliant 8500 CPU@700
Full SCSI Raid 5 arrays (15K SCSI Drives)
3GB Ram

Problem:
SQL Server Agent Jobs will not complete... at all!

Change to server:
Use MSDB to store history of Jobs.
MSDB became full so I expanded the database.
After this the server has been restarted and no jobs will complete... they are in execute mode for more than a day when before they took 30 sec to complete!

Very strange, just wonderd if you have heard/know anything about this sort of problems?

Thanks very much for your time
Micke"

chadmat
The Chadinator

1974 Posts

Posted - 2002-09-23 : 14:42:32
Do they email upon completion?

-Chad

Go to Top of Page
   

- Advertisement -