Although I can't take credit for the code, I inherited it from a previous DBA.

Yes there is. I use a trigger on the msdb.dbo.sysjobhistory to look for non-zero return codes and e-mail from there.

USE [msdb]

GO

/****** Object: Trigger [dbo].[checkForJobFail] Script...

Thank you very much, This was exactly what I was looking for.

MVP Todd McDermid gave me the answer to my problem:

Have you tried setting DelayValidation to true for the Connection Manager and Data Flow Task?

That resolved my problem.

Thank you for all...

Showing my ignorance here, but where do I look to verify/change that?

Never mind. I had never seen the TargetServersRole in MSDB security, that seems to have resolved my issue.

Thank you,

Dep

I would agree with that, except that it persists through reboot and I have masked that CPU so SQL doesn't use it.

That's what I would love to figure out. I have masked SQL to not use that CPU. Task manager shows the system 99% idle, but the last CPU...

This may be way out of left field, but are you backing up to a different disk? If so, is the allocation unit size the same or similar on...

Did you ever resolve this issue? If so, what was the resolution?

Thanks,

Restarting the SQL agent has solved the problem.

Tried that it didn't work. Here is our latest theory. The SQL Server agent was started before the account that runs the SQL server Agent was given access...

The owner of the DTS Job or the owner of the scheduled task?

The owner of the DTS job is the user who created it. The owner of the Scheduled...

Load xpsmtp80.dll file on database server to configure smtp mail extended stored procedure. Copy xpsmtp80.dll to C:\Program Files\Microsoft SQL Server\MSSQL\Binn

Next, run the following statement in Query Analyzer on the...

I could not follow what you are wanting if the credit value is 0 but other than that I played with it for a while and came up with this:

Create...