Once again, I thank everyone for their suggestions.

Scorpion's post made me think of something obvious: CPU vs IO bound

I decided to connect at night and check the server. ...

Thanks for the input!

I tried changing the setting on the Process Buffer Size and it had no impact on processing. I will see what tuning we can do on...

If I understand you properly, you are having a problem where the destination text file is cleared out prior to data being written to it. I have never tried...

The script from Greg Larsen is available from SQLServerCentral.com. The address is:

http://www.sqlservercentral.com/columnists/glarsen/failed_jobs.asp

The purpose of our monitoring server is to have 1 server that will provide the status...

I have had a similar problem on SQL 7 (sp2) running on NT 4. The xp_sendmail would stop working. Stopping and starting SQL mail does not work in...

Can you use a UNC path? I read the directory from a remote server with the following code:

create table #temp (filenam varchar(30))

insert into #temp

exec master..xp_cmdshell 'dir /b \\SERVERNAME\SHARENAME\*.*'

select *...