I have a job that runs for multiple regions across the globe. Depending on what region is running and what time zone it's in, the job might not run. It uses
GOTO to get to the end and reports that it was skipped due to time and completes.
This runs as expected with no issues.
The Issue: there are times when a linked server farther down the proc is under really heavy load. We know about it and cannot avoid it - so we don't query the linked server at this time.
But, we're still getting an error as if it's queried:
Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider "SQLNCLI11" for linked server returned message "Unspecified error". [SQLSTATE 01000] (Error 7412) OLE DB provider "SQLNCLI11" for linked server returned message "Query timeout expired". [SQLSTATE 01000] (Error 7412). The step failed.
Are linked servers validated when a proc starts causing this schema check that times out?