Good morning, I have a stored proceedure which runs a series of other
stored proceedures to process reporting data. When I run the stored
proceedure manually through query analyzer (QA) it takes about 20
minutes, but when we create a job to run the same proc it completes
successfully, but takes 5 hours.

The proceedure looks generally like:
1. autodetermine run-date range (i.e. today - a day)
2. run another proc
3. run another proc

The proc and the job are on the same server, and the job is executed
by an admin. We run other, very similar procs in this way and those
procs complete in comperable time when run via a job as when run via
QA. This proc is not using transactions, nor excessive Begin's or
GO's.

The server has significant excess capacity, and no other jobs are
running while this job runs. We have experienced this delay every
time we run the job, and never when we run the proc directly through
QA.

Thanks!