After all that, I am wondering if perhaps I can't just change the bit on the target schedule, edit the schedule, and then change the bit back.

Thanks for all the advice. I'm still trying to figure out the "best" way to go. I'm also considering creating a group of "identical" master jobs that very...

If I either remove the target or delete the master job, the job on the target gets removed - as it should. I'm curious - is it possible to...

I was thinking of a waitfor, but that would make the run time information harder to use. I want to know how long the backup takes, for example. ...

I also noticed that there is no option to run the MSX job on the master. The master can't enlist itself or another master. It appears I will...

I would like to use a master job to deploy maintenance scripts. One of the requirements is to stagger the schedule. For example, separate the DBCC a few...

I work for a local government agency that has many business functions. Many of the functions don't change that much over the years. We support many databases and...

Have you tried restarting the agent? That is what seems to be required to get it working again in some cases.

I'm torn too. Gone are the days when an application could be developed and used for many years. Vendors can force-feed product version upgrades as the only means...

Jeff Moden (12/21/2013)

---

Shifting gears a bit,...

I also did it with powershell. I created a function with a parameter that is a list of servers. It would also prompt for a restart the service...

K. Brian Kelley (12/18/2013)

---

Slevin (12/18/2013)

---

rstone (12/17/2013)

---

I think I was confusing delegation with impersonation. As a sysadmin, I sometimes use EXECUTE AS to impersonate a login to test permissions. ...

I think I was confusing delegation with impersonation. As a sysadmin, I sometimes use EXECUTE AS to impersonate a login to test permissions. In this case, once the...

When the trust for delegation is enabled, can I, as a sysadmin, use SQL Server to impersonate the domain admin account?

We have a vendor that claimed they don't...

Another issue I've seen is RBR -> RBAR. If something somplace requires processing a row at a time, then that's the way it's all done. For example, sending...