We are using Microsoft SQL Server Agent Jobs to execute stored procedures on the other database systems (like MySQL or Oracle).
Usually we run procedures via linked servers (over OLEDB and ODBC drivers) and queries like:
EXECUTE ('CALL DB.sp_MyProcedure') AT OTHER_DBS;
(Not very good method, but I don't have access to schedule other DBS.)
Well, I observe queries with sp_whoisactive and have seen high summary CPU consumption for these jobs — i.e. 2,000,000 in 30m query duration as OLEDB waiting.
What is the reason of high CPU consumption?