Not really. When I used the GUI to enable/disable the jobs, it cleared up the problem. I am pretty sure that the GUI uses the stored proc. ...

CirquedeSQLeil (4/20/2010)

---

haha - better...

I think it has something to do with a Gremlin!

CirquedeSQLeil (4/20/2010)

---

dma-669038 (4/20/2010)

---

Very well summarized Jason!! I will pass it around to my team today.

1 On the naming - using 'sql server' is much unlikely to be as difficult...

First thing that comes to mind, a start up stored procedure that checks for any backups that failed/cancelled and restarts the job(s). Not sure how you would implement that...

Regarding your blog post, Notification Services. Are...

Shabba (4/20/2010)

---

Well I guess i'm one of the lucky (or unlucky) ones! On-call, overtime & 46 days leave a year here in the UK. Though I would gladly...

The reason I was asking is i had a similar problem when I would failover our mirror databases. The code that was enabling/disabling the database specific jobs wasn't "working"....

The backup will fail, however (and you will need to test this), I believe that it may not SHOW as having failed when you check the job status after the...

Okay, downer feeling. I feel like a jack of all trades master of none again. But I'm okay with that, actually. Back up again!!

Awesome! That means...

bteraberry (4/20/2010)

---

If you have any servers open to the Internet be prepared to spend a lot of time and effort on security. If you don't know what to do...

We could also use someone like Gail, need someone strong on the database corruption side as well. Think she'd join us also?

And yes. I realize she is busy with...

Do we have anyone onboard yet that is fairly strong with SSIS/SSAS/SSRS?

Up to 6! I think 2 to 4 more and we'll set!