Don't you need to copy the indexes as well?

Aha, I found the problem. Our tech team had cloned the server and restarted SQL AGENT on a new server. The job failures were actually coming from the new server....

Another piece of info...

Some of the jobs are set up to Page an operator when the job fails. Those pages are not happening when the job starts. So, somehow,...

Sorry, I should have clarified how the EMAIL notifications are set up.

The Checkbox next to EMAIL is checked, I've picked the Operator from the Operator drop-down (me) and the next...

It is blank...

Note that in the EMAIL that I'm getting from SQL Agent the STATUS = Failed...

JOB RUN: 'MOS Job Notification' was run on 5/28/2014 at 10:30:00 PM

DURATION: 0...

Thanks Martin, Sounds like it's not worth the trouble. I'll just go with a flashy, but static, color.

Hi Everyone,

It took us a while, but we eventually determined that there was something wrong with the disks (as Paul initially suspected) and the issue was resolved by replacing them....

Thanks Paul for the quick response!! We'll give it a try.

Thanks Nils

FYI - Never figured out what the problem was but a reboot fixed it.

Hi there,

We are getting a similar problem. Were you able to resolve this?

Thanks Jack,

I understand that I can break the inserts into batches and then I could create smaller TXN logs. But, it will still mean ~40 GB of data will have...

Just an FYI - I've included logic in my job to retry the proc if the error occurs. The job runs fine the second time it runs (although it's an...

No, just this job.

Thanks Manu,

Yes, I did have the output going to a file, but that was the only message that showed up. I also checked the SQL Server log but no information...