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
Databases > System Databases > msdb > Programmability > Stored Procedures > System Stored Procedures
If you require more info, don't hesitate to ask.
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?