I have seen the error reported elsewhere. The solution for me was straightforward enough and involved setting the properties in SQL server management Studio server objects>linked servers>SQLNCLI10 to Allow inprocess (checked).

My jobs are running happily again. It may be coincidence that the error started when I was configuring database email however, I suspect there is a link. If you have any security advice regarding this, I would welcome your opinions.
ever get anything back on this? I had the same error come back after configuring dbmail, but already have allow_inprocess set for the provider.
ReplyDelete