After my mssql 2005 server hit the roof in disk space all my maintenance
plans dissappeared. I find them in jobs, in history i can see the jobs go
successfully but there is no history of each maintenance plan anymore.
When i try to create one with the same name, it reports it already exist.

Can anyone me to get them visible again?

did you look for them by selecting from the msdb tables related to jobs?
See BOL for those. I don't know why the GUI would fail to show them
however. You may want to do a checkdb on msdb - there could be possible
corruptions due to the disk-limit hit.

--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net


"JRS" <JRS@discussions.microsoft.com> wrote in message
news:12A8362F-D0B9-4095-B092-936BFB41FCC2@microsoft.com...
> After my mssql 2005 server hit the roof in disk space all my maintenance
> plans dissappeared. I find them in jobs, in history i can see the jobs go
> successfully but there is no history of each maintenance plan anymore.
> When i try to create one with the same name, it reports it already exist.
>
> Can anyone me to get them visible again?

Hi,

dbcc checkdb on msdb return no errors.

By running select * from dbo.sysjobs; I can see all the jobs, but they still
fails to show up in the GUI. Because of that I cannot edit them to change
them.



"TheSQLGuru" wrote:

> did you look for them by selecting from the msdb tables related to jobs?
> See BOL for those. I don't know why the GUI would fail to show them
> however. You may want to do a checkdb on msdb - there could be possible
> corruptions due to the disk-limit hit.
>
> --
> Kevin G. Boles
> Indicium Resources, Inc.
> SQL Server MVP
> kgboles a earthlink dt net
>
>
> "JRS" <JRS@discussions.microsoft.com> wrote in message
> news:12A8362F-D0B9-4095-B092-936BFB41FCC2@microsoft.com...
> > After my mssql 2005 server hit the roof in disk space all my maintenance
> > plans dissappeared. I find them in jobs, in history i can see the jobs go
> > successfully but there is no history of each maintenance plan anymore.
> > When i try to create one with the same name, it reports it already exist.
> >
> > Can anyone me to get them visible again?
>
>
>

Are you by chance on SP2 (without any additional updates)? There were job
problems with that service pack release. Outside of that, I am at a loss.
Oh, make sure your tools (as in SSMS) is patched up past SP2 as well.

--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net


"JRS" <JRS@discussions.microsoft.com> wrote in message
news:CF577965-38AD-4A2B-AF40-DB270A74CAB3@microsoft.com...
> Hi,
>
> dbcc checkdb on msdb return no errors.
>
> By running select * from dbo.sysjobs; I can see all the jobs, but they
> still
> fails to show up in the GUI. Because of that I cannot edit them to change
> them.
>
>
>
> "TheSQLGuru" wrote:
>
>> did you look for them by selecting from the msdb tables related to jobs?
>> See BOL for those. I don't know why the GUI would fail to show them
>> however. You may want to do a checkdb on msdb - there could be possible
>> corruptions due to the disk-limit hit.
>>
>> --
>> Kevin G. Boles
>> Indicium Resources, Inc.
>> SQL Server MVP
>> kgboles a earthlink dt net
>>
>>
>> "JRS" <JRS@discussions.microsoft.com> wrote in message
>> news:12A8362F-D0B9-4095-B092-936BFB41FCC2@microsoft.com...
>> > After my mssql 2005 server hit the roof in disk space all my
>> > maintenance
>> > plans dissappeared. I find them in jobs, in history i can see the jobs
>> > go
>> > successfully but there is no history of each maintenance plan anymore.
>> > When i try to create one with the same name, it reports it already
>> > exist.
>> >
>> > Can anyone me to get them visible again?
>>
>>
>>

Running 9.00.3068.00 of the sqlserver
Running 9.00.3042.00 of Microsoft SQL Server Management Studio

That should be above sp2 for server and SP2 for the managment studio.

Is there a place the maintenace plan itself with the commands are saved? I
find references to the jobs, but somewhere the commands defined in the plan
should be identified?


"TheSQLGuru" wrote:

> Are you by chance on SP2 (without any additional updates)? There were job
> problems with that service pack release. Outside of that, I am at a loss.
> Oh, make sure your tools (as in SSMS) is patched up past SP2 as well.
>
> --
> Kevin G. Boles
> Indicium Resources, Inc.
> SQL Server MVP
> kgboles a earthlink dt net
>
>
> "JRS" <JRS@discussions.microsoft.com> wrote in message
> news:CF577965-38AD-4A2B-AF40-DB270A74CAB3@microsoft.com...
> > Hi,
> >
> > dbcc checkdb on msdb return no errors.
> >
> > By running select * from dbo.sysjobs; I can see all the jobs, but they
> > still
> > fails to show up in the GUI. Because of that I cannot edit them to change
> > them.
> >
> >
> >
> > "TheSQLGuru" wrote:
> >
> >> did you look for them by selecting from the msdb tables related to jobs?
> >> See BOL for those. I don't know why the GUI would fail to show them
> >> however. You may want to do a checkdb on msdb - there could be possible
> >> corruptions due to the disk-limit hit.
> >>
> >> --
> >> Kevin G. Boles
> >> Indicium Resources, Inc.
> >> SQL Server MVP
> >> kgboles a earthlink dt net
> >>
> >>
> >> "JRS" <JRS@discussions.microsoft.com> wrote in message
> >> news:12A8362F-D0B9-4095-B092-936BFB41FCC2@microsoft.com...
> >> > After my mssql 2005 server hit the roof in disk space all my
> >> > maintenance
> >> > plans dissappeared. I find them in jobs, in history i can see the jobs
> >> > go
> >> > successfully but there is no history of each maintenance plan anymore.
> >> > When i try to create one with the same name, it reports it already
> >> > exist.
> >> >
> >> > Can anyone me to get them visible again?
> >>
> >>
> >>
>
>
>

Problem "solved"
This server is a new installation, planning to replace another instance on
another server. So the technican/consultant involved in configuring parts of
it has linked the jobs to the maintenance plans on the old instance.

So the mystery is solved, but I should have figured this one earlier.


"JRS" wrote:

> Running 9.00.3068.00 of the sqlserver
> Running 9.00.3042.00 of Microsoft SQL Server Management Studio
>
> That should be above sp2 for server and SP2 for the managment studio.
>
> Is there a place the maintenace plan itself with the commands are saved? I
> find references to the jobs, but somewhere the commands defined in the plan
> should be identified?
>
>
> "TheSQLGuru" wrote:
>
> > Are you by chance on SP2 (without any additional updates)? There were job
> > problems with that service pack release. Outside of that, I am at a loss.
> > Oh, make sure your tools (as in SSMS) is patched up past SP2 as well.
> >
> > --
> > Kevin G. Boles
> > Indicium Resources, Inc.
> > SQL Server MVP
> > kgboles a earthlink dt net
> >
> >
> > "JRS" <JRS@discussions.microsoft.com> wrote in message
> > news:CF577965-38AD-4A2B-AF40-DB270A74CAB3@microsoft.com...
> > > Hi,
> > >
> > > dbcc checkdb on msdb return no errors.
> > >
> > > By running select * from dbo.sysjobs; I can see all the jobs, but they
> > > still
> > > fails to show up in the GUI. Because of that I cannot edit them to change
> > > them.
> > >
> > >
> > >
> > > "TheSQLGuru" wrote:
> > >
> > >> did you look for them by selecting from the msdb tables related to jobs?
> > >> See BOL for those. I don't know why the GUI would fail to show them
> > >> however. You may want to do a checkdb on msdb - there could be possible
> > >> corruptions due to the disk-limit hit.
> > >>
> > >> --
> > >> Kevin G. Boles
> > >> Indicium Resources, Inc.
> > >> SQL Server MVP
> > >> kgboles a earthlink dt net
> > >>
> > >>
> > >> "JRS" <JRS@discussions.microsoft.com> wrote in message
> > >> news:12A8362F-D0B9-4095-B092-936BFB41FCC2@microsoft.com...
> > >> > After my mssql 2005 server hit the roof in disk space all my
> > >> > maintenance
> > >> > plans dissappeared. I find them in jobs, in history i can see the jobs
> > >> > go
> > >> > successfully but there is no history of each maintenance plan anymore.
> > >> > When i try to create one with the same name, it reports it already
> > >> > exist.
> > >> >
> > >> > Can anyone me to get them visible again?
> > >>
> > >>
> > >>
> >
> >
> >