I have a command that when run thru Agent takes many times longer than the exact same command run thru QA. Observed in both SQL7 and SQL2000 SP2.

Job is a performance job that inserts 1000 8K rows and records the duration. Takes 0.500 seconds from QA, takes 12 seconds from Agent.

However: When I run the same command thru xp_cmdshell / isql and Agent, then it runs quickly, perhaps 0.650

Mark Godfrey