Need to create job

Question

Need to create job

jdbrown239

SSCarpal Tunnel

Points: 4393
More actions
June 19, 2012 at 3:02 pm

#262600

Need to setup a job to rebuild indexes and run against multiple databases in the instance. Know any good resources to help?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Jared SSC Guru Points: 61793 More actions · Answer 1

I tend to use the Maintenance Plan Wizard for this if it is simple. Otherwise, there are plenty of scipts out there you can find with a google search. This is the best.[/url]

Jared
CE - Microsoft

Grant Fritchey SSC Guru Points: 398886 More actions · Answer 2

Nothing wrong with Olla scripts at all. I do thing Michelle Ufford's are also worth a look[/url]. They're simpler and easier to deal with I think.

You might also want to take a look at the software from my employer, Red Gate. We make an index management utility that is pretty slick, SQL Index Manager[/url].

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning