Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Job / DTS retry

Author  Topic 

TheMasta
Starting Member

1 Post

Posted - 2008-08-01 : 15:51:33
I have 2 questions:

1. Does a Job that is waiting for its retry time to come so it can execute a DTS again consume much/any server resources.
2 If it does, what is recomended, one retry o or to add another schedule so the Job runs at another time too.

Thanks

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-08-01 : 23:15:28
Job doesn't use any resource while waiting for retry, just like run at next scheduled time.
Go to Top of Page
   

- Advertisement -