Did you try to set it in Enterprise Manager? SQL Server Agent -> Properties -> Job System -> Non-SysAdmin job step: remove check mark and reset the proxy account

Do you have any real time security software running in production that is not on test box? I found that it slows down backup more than 3 times...

You may check your Windows backup schedule if it doesn't collide with this job. I had something similar when file was momentarily locked for archive right before used in DTS.

I spent a good 6 month to pin the problem. It appeares this happens on SQL Server first time after Exchange server reboot. After first failure all other SQL job...

It happened some day with one of my job too. It was the only problem job on the server, all others stayed enabled. I recreated it from scratch and it...

I had same problem with double quotes in queries as described above. Also, a couple of sp's failed due to comparison of datetime values of different length.

The field was...

We have the same problem in 2 variations: one job behaves exactly how you described but another actually sends an email and then completes with a failure message. The majority...