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 |
|
rwaldron
Posting Yak Master
131 Posts |
 Posted - 2008-04-30 : 06:59:56
|
| Hi all,I have 20 SQL jobs thst are scheduled to run from say every 5mins to others that run every hour.Does anyone know the best way to optimise these jobs to run.At the moment once these jobs are running I cannot browse any tables in teh DB. I get a locked timeout rquest exceeded..Do I need to stagger when the jobs run.Or make one big job where they all run one after another ?Any help ?Ray.. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-30 : 10:37:22
|
| Do they run in production time? What these jobs do ? Usually you should run jobs that lock tables in offline hours ? |
 |
|
|
rwaldron
Posting Yak Master
131 Posts |
Posted - 2008-04-30 : 11:56:19
|
| HIya,I run these jobs during production.The jobs run stored procedures that basically drop an old table and create a new table with newer data.These are then the backend of web reporting site so that have to run every 5 - 10 mins. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-30 : 22:19:50
|
| Does new table use same name as old one? App may break during drop/create table. |
|
|
|
|
|
|
Optimising SQL Jobs