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.
| Author |
Topic |
|
san
Starting Member
26 Posts |
 Posted - 2002-08-05 : 13:23:13
|
| To all experts out there in SQL DTS jobs :-I am runnning some DTS in production and it is running fine most(99.9%) of the time. Ussualy it takes 5 to 8 seconds for the DTS to complete its job. But sometimes (very rare) it is taking more than hours (IOW, the process is getting hung). So I want to put a time out and (when it exceeds timeout mailing the administrator saying that the process is hung..) Is there any way of doing this? If yes, HOW ?Please help. |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2002-08-05 : 19:18:51
|
| All of the connections have a timeout setting in the Advanced tab.HTH--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
 |
|
|
san
Starting Member
26 Posts |
Posted - 2002-08-08 : 10:58:03
|
| Thanks rrb.For me the connection is being established with out any issues.When the actual pumping starts, some times it is taking long duration (hanging). Is there anyway of giving a timeout for pumping ?San. |
|
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-08-08 : 11:41:41
|
| There is also a GeneralTimeout in the advanced connection properties dialog - however I still don't think this is what you want as I believe if you are using the SQL OLEDB provider, this governs any timeouts EXCEPT connection (ConnectionTimeout) and command execution(CommandTimeout) - however I can't see the Command timeout even when doing a disconnected edit so maybe its not exposed - it would seem strange though.HTHJasper Smith |
|
|
|
|
|
|
How to Set timelimit for SQL DTS