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 |
|
shaankit1
Starting Member
1 Post |
 Posted - 2005-02-21 : 00:49:18
|
| I have a job that is scheduled to run every 15 minutes. This job some times completes in 12 minutes but many times runs over 20 minutes. Am I hurting performance by scheduling it to run every 15 minutes. Thanks |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-02-21 : 09:06:06
|
| If it takes 20 mins then it will miss one 15 min interval and start again on the next one.It won't be running twice at the same time if that's what you mean.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
SQL Agent Job