March 16, 2005 at 5:41 am
Hi all,
I'm running MSDE on a PC and have a stored procedure which is run every night at around 1am that deletes the existing data and then imports a large set of new data (around 10 million records) into the MSDE database. Normally this takes about 15-20 minutes to complete but this morning the job failed at around 9:30am and the CPU usage on the system was maxed out. Couldn't tell what processes were causing the high CPU usage because they kept changing.
Anyway, the only clue I have is the following entry in the Application Event View logs:
Event Type: Warning
Event Source: SQLSERVERAGENT
Event Category: Job Engine
Event ID: 208
Date: 16/03/2005
Time: 09:31:29
User: N/A
Computer: RS000714
Description:
SQL Server Scheduled Job 'sp_Import' (0x601C76716D4DF443BFCE8060E0471B56) - Status: Failed - Invoked on: 2005-03-16 09:29:00 - Message: The job failed. The Job was invoked by Schedule 1 (sp_Import). The last step to run was step 1 (sp_LocalImport).
I don't know whether this is what caused the high CPU usage or if the high CPU usage was the cause of this.
This job has been running fine every night for about 3 months until now, so I'm suspecting a issue with the MSDE SQL Server Agent or some other system fault that causes this. There are also 20 other PCs which run the same job and are very much identical but only this one PC has had this issue.
Any ideas on what the problem may be?
Many thanks,
Chiu.
March 21, 2005 at 8:00 am
This was removed by the editor as SPAM
March 21, 2005 at 12:40 pm
how are you deleting the data from the tables; using delete or truncate.
Yash
March 22, 2005 at 12:19 am
Check to see if your transaction log is full and it has enough disk space to accomadate the changes.
--Kishore
February 6, 2008 at 7:43 am
i am having the same problem,
i suspect SAN ...
September 17, 2008 at 12:27 am
im getting the below error message for the same event ID:208
DTSRun: Loading... Error: -2147024629 (8007010B); Provider Error: 0 (0) Error string: The directory name is invalid. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 713. Process Exit Code 1. The step failed.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply