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 |
|
pnpsql
Posting Yak Master
246 Posts |
 Posted - 2013-04-18 : 11:51:26
|
| hi team, i have procedure "proc_daily_end " that we executed daily at night to generate bills and contains multiple procs in it. due to huge data it takes time and irretaes us. there is procedure that we used to reconfigure indexes this is taking too much of time. Now my boss command me to run the re-configure index program by sql server job. the "proc_daily_end" proc will execute the job that contains the reconfigure index proc and execute in the way that "proc_daily_end" will not wait for reconfigure index proc. Kindly suggest me the best practices in doing this and considerations. challenge everything |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2013-04-18 : 12:17:03
|
| I'm not 100% clear on what you want, but can you jsut run two jobs that execute at the same time?I admit that doesn't sound like a good idea if you are trying to update statistics and indexes at the same time as an intensive process is running,but I'mnot your boss.. :) |
 |
|
|
pnpsql
Posting Yak Master
246 Posts |
Posted - 2013-04-18 : 23:06:20
|
| Lamprey, request you to suggest what is best way that both of my task done when i run only first process.challenge everything |
|
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2013-04-19 : 02:34:47
|
| Index reconfgure job may lock the tables during the process..so, a better way would be create a job with 2 steps.step1:run your proc_daily_endstep2:run index recongigure proc.Thanks,Javeed.mohammad.javeed.ahmed@gmail.com |
|
|
|
|
|
|
sql agent job