I have not worked on a fix as our failing jobs are non-essential at this time.

Perhaps use Windows Task Scheduler and SQLCMD instead of SQL Agent?

Good teamwork Ron!  I've been waiting for over a month for someone to post anywhere on the internet that they also have this issue.

Thanks for posting your steps to temporarily...

For us, I'm almost certain it is the ODBC 13 Driver and using sp_executesql.  The latest publicly available version of that driver appears to be 13.1 so not sure how...

• This reply was modified 3 months, 1 week ago by  TerryS. Reason: Wrong driver version

Do your proc(s) use sp_executesql?  I just realize both my failing jobs use it.  It appears to have some relation to ODBC: https://learn.microsoft.com/en-us/sql/relational-databases/native-client-odbc-queries/executing-statements/direct-execution?view=sql-server-2016

I suspect that proc and the...

I have not found a workaround yet.  Interesting you uninstalled the update and it persisted.  In my research, the error has occurred in the past and was tied to either...

I've been getting this error in SQL Agent jobs on several SQL 2016 servers intermittently since installing the latest security update (13.0.6455.2, 5046855 Security update for SQL Server 2016 SP3...

Concur with the quality over quantity comment.  It'll also make it easier to "catch up" after unplugging during extended absences.

Spark is a car by Chevy.

Walking mailman.

cparks 3541 (3/4/2016)

---

So is it fair to assume that the spouse who is insured by their spouse's employer would receive an additional amount of equal to the employer cost of...

90% virtualized presently, with more to retire/migrate on the horizon. We may need to maintain a handful of physicals, but that remains to be seen.

SSMS for the win.

An airline or a cruise line. Not some much for the data, but for the employee perks.

I agree with others about it being too narrow. In the era of widescreens, too much white space and scrolling.

2000 - 7 (includes 2 SSRS only servers)

2005 - 11 (includes 1 SSRS only server)

2008 - 8 (includes 2 SSAS only servers)

2008 R2 - 6