Wednesday, March 7, 2012

Maintenance Plans are Disappearing...

I'm not even sure where to post this, but has anyone had a problem with maintenance plans disappearing?

I mean the SSIS package and the job just disappearing....?

I have four servers. Two dev and two prod. I created a pretty simple maintenance plan to backup databases. There are four tasks in the plan. One for each of four databases. Backing each up to a separate file, all in the same folder.

The plan gets associated with a job that has it run daily, every six hours, with no end date.

The plan runs just fine. Then this morning, on one of the servers, the plan and its job are just gone.

This is the second time this has happened. And it's not the same server that it happened on the first time.

Why would a maintenance plan just disappear?

Anyone?

J

We have almost the same problem, The SSIS jobs have dissapeared two times now. In our case the Job is still there generating errors since it can't find the Maintenance plans.

Does anyone know why this happens??

/Thomas

No comments:

Post a Comment