Issue:
SQL Job takes longer to run via SQL Agent. Very fast when run manually but takes a very long time to run via scheduled.
Stored Procedure times out when called from app. Stored Procedure runs very fast when ran manually.
Resolution:
Restart Windows and database server.
Comments