-
Stored Procedure
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
:-)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|