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

More than likely, it's just the load or file operations
revealing some disk subsystem issue...not likely to directly
be a DTS or SQL Agent job issue.
It could be a bad disk, problems with your controller,
firmware, etc. You'd probably want to follow the
troubleshooting steps in the following article:
Information about Event ID 51
http://support.microsoft.com/?id=244780

-Sue

On Thu, 19 Oct 2006 12:50:52 -0700, "Andrew"
<askmeforit (AT) myemail (DOT) com> wrote:

Appreciate the info, will check it out. Thanks

-- Andrew

"Sue Hoegemeier" <Sue_H (AT) nomail (DOT) please> wrote