If I were doing this I'd probably use a signed stored procedure to allow someone to execute sp_start/stop_job without the actual permissions, then define what groups / users can start...

Hi Makis,

That's an interesting suggestion. I'll have to think about that one a bit, as it would require having a table somewhere where the indexes that the procedure initially disables...

Hi Gerald, two excellent suggestions, which I'll implement.

Edit: DOH, I didn't see this thread was quite old, for some reason it came up in my feed on the site home page. Oh well, still relevant certainly!

Hi there,...

That is an interesting requirement for sure. Anyway, what login owns the maintenance plan job(s) that failed, and is it part of one of those two groups that grants it...

I believe the dbo.systargetservers table in the msdb database has what you are looking for?

I will second the comment about keeping transaction log backup files beyond simply the last full backup. What happens if you need to do a point in time restore to...

I'm not sure why remote connections wouldn't work using an alias, I've used them many times. If you setup your alias like this it should work. (Sorry for the lack...

Which option do you mean (the include indexes or the 'truncate' vs 'drop' pre-creation one)?

I would say you should always have index maintenance and statistics update jobs in place, albeit they should be driven by actual fragmentation levels or amounts of changed data, rather...

I believe when you initialize from a snapshot by default it will drop and create the tables, hence the indexes will be gone. If your indexes are the same as...

Is there anything different about that Z: drive versus the other drives the server uses? Different configuration, etc? Local versus SAN?

At one of my previous jobs we simply alternated who watched the queue on a daily basis. That way the work got spread around fairly evenly (obviously there were days...

Sorry maybe I was confused, are you using an Execute SQL task to start the jobs, or an Execute Package task? It sounds like the latter; how are you using...

I believe that error message actually means those settings must be set ON, not OFF. I would try setting them both ON and see what happens.