URGENT Stored Procedure Performance in a JOB versus DTS...

Last Post 18 Dec 2005 04:06 AM by sm8680. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
sm8680
New Member
New Member

--
18 Dec 2005 04:06 AM
URGENT Stored Procedure Performance in a JOB versus DTS (Execute SQL Task) that is then called by a Job.

I was unable to find any documents pertaining to best practices for executing SP for night Jobs.

Is there any associated overhead when running DTS package that executes a stored procedure via an Execute SQL task versus just running a job that executes a stored procedure.

I really appreciate the time you took to either read this thread and/or respond. Thanks
You are not authorized to post a reply.

Acceptable Use Policy