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 |
|
nvasuki
Starting Member
1 Post |
 Posted - 2008-08-13 : 07:28:09
|
| I have a reindex job in SQL Server 2005 and I need it to stop by 6.30 A.M because I have my schedule backup by 7 A.M. So whether the reindex completes or not I want to stop it by 6.30 A.M. Please help me on How to do it |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-08-13 : 08:13:56
|
| in scheduling options under daily frequency set it to stop at 6:30_______________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.0 out! |
 |
|
|
acollins74
Yak Posting Veteran
82 Posts |
Posted - 2008-08-13 : 08:18:34
|
| thinking out loud. wouldn't this stop force a kill on the associated spid introducing rollback. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-13 : 14:38:04
|
| Thats right. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-13 : 22:50:04
|
| You can change start time, job history will tell you took how long to run it. |
|
|
|
|
|
|
SQL Server Agent Job to schedule to end at a partr