 | |
Executing scheduled DTS jobs
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Executing scheduled DTS jobs -
01-03-2006
, 08:00 AM
#2
| |||
| |||
|
|
Hi, I scheduled several DTS packages for regular daily data transfer. Shall I somehow ajust time of execution of these packages? Will it be huge impact on SQL Server performance if jobs start simultaneously? |
#3
| |||
| |||
|
|
Once you have scheduled your DTS packages, you can view / modify them in EnterPrise Manager / Management / SQL Server Agent / Jobs The impact of running them simultaneously depends on how many jobs you intend running and what impact they have individually. If running them one after the other is an option it will have less impact. You are limited to how many worked threads can run by default. Have a look here if it becomes an issue Microsft KBase Q306457 -- HTH. Ryan "Elena" <Elena (AT) discussions (DOT) microsoft.com> wrote in message news:C2B7A3DB-06EA-40EC-AB5A-A75E2488F866 (AT) microsoft (DOT) com... Hi, I scheduled several DTS packages for regular daily data transfer. Shall I somehow ajust time of execution of these packages? Will it be huge impact on SQL Server performance if jobs start simultaneously? |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.