Unanswered: Scheduled job runs WAY SLOW compared to Query Analyzer
We have a SP that calls 14 other sp's that updates hundresd of thousands of records.
execute spUpdateMyData 'Parameter1', 'Parameter2'
Records are appended, deleted, updated. Anyhow all that is not important. The issue here is speed. When the same command is issued from a SQL Server Job it runs at least 4 times slower. so somthing that would have taken 10 hours now takes over 14 hours.
QUESTION: Is there a setting or parameter in SQL server that can be set to make up the difference in speed. Like a run priority or something.