Hi guys,
I have scheduled a Job in which i call a stored procedure. In the stored proc i am truncate two table and inserting some records(9000) into two table.
my problem when i executed the same procedure in query analyser, to execute this proc will take 30 sec, but when i schedule this job from enterprice manager, management, sql server agent, jobs - new jobs, in step 1,
exec spmyctxt it will take 1 hour to execute.
any help will be appreciated.

thanks
:-)