I have a scheduled job that is causing errors in the System Event Log, and I don't know why.
The job is a DTS package that has two steps -- first step connects to our AS400 and copies down data, the second step takes that data an formats it for later use. Whether running the DTS manually, or letting it run as a scheduled job, it completes just fine, all data is there, no errors in the SQL Server error logs, all peachy. When the DTS package is run as a scheduled job, during _only_ the first step, the System Event Log starts rapid fire spitting out the following error:
Source: Disk
Type: Warning
Category: None
Event ID: 51
User: N/A
Description: An error was detected on device \Device\Harddisk1 during a paging operation.
The error shows up 20 to 30 times per second every 3 to 4 seconds for the duration of only the first step of the job. Again, this is only when the job runs as a scheduled job... no errors appear if I run the DTS package manually from the DTS designer.
And regardless - scheduled, manually - the job finishes just fine.
I literally have no idea why, what, how this is happening. Has anyone run into this behavior or issue?
Our SQL Server box:
Microsoft SQL Server 2000 (SP3)
Microsoft Windows Server 2003 Standard Edition (SP1)
Dual 3GHz Intel Xeon Procs
4GB RAM
130GB on O/S drive (100+ free)
550GB on Data drive (300+ free)
-- Andrew
My new philosophy!
Life's journey is not to arrive at the grave safely in a well preserved body, but rather to skid in sideways, totally worn out, shouting "...holy ***...what a ride!"