0

Trying to save a new Maintenance Plan using SSMS 2008 and receiving error:

Apply to target server failed for Job 'DB Backup.createDBBackup'

The connection has been verified.

Is [dbo].[sp_add_maintenance_plan] suppose to be found under:

Databases > System Databases > msdb > Programmability > Stored Procedures

OR

Databases > System Databases > msdb > Programmability > Stored Procedures > System Stored Procedures

If you require more info, don't hesitate to ask.

Thanks, Alex

UPDATE

The maintance plan now creates .bak files but it seems I can't run MAINTENACE CLEANUP TASK. Could it be that master.dbo.xp_delete_file can't be found. Is there a way to reset that as well?

Alex
  • 103
  • 1
  • 4

1 Answers1

0

It is a system stored procedure in msdb.

Brian Knight
  • 1,175
  • 2
  • 8
  • 17
  • I use to have an issue **Deleting Jobs**, I then added dbo.sp_delete_job under **Databases > System Databases > msdb > Programmability > Stored Procedures** - Deleting now works. Could my **msdb** be missing Stored Procedures? How do you go about fixing the msdb? – Alex Mar 08 '11 at 20:39
  • 2
    There's a script in the install folder called instmsdb.sql. Running that should put the objects back. – mrdenny Mar 08 '11 at 20:45
  • The maintance plan now creates .bak files but it seems I can't run MAINTENACE CLEANUP TASK. Could it be that master.dbo.xp_delete_file can't be found. Is there a way to reset that as well? – Alex Mar 10 '11 at 16:09