Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

share|improve this question
    
Do you have the Integration Services service installed on the server? –  mrdenny Mar 8 '11 at 20:35
    
Under Integration Services I have Data Profile Viewer and Execute Package Utility. The server is missing Microsoft Analysis Services Client Tools component. –  Alex Mar 8 '11 at 20:44
    
But do you have the service installed on the machine? –  mrdenny Mar 8 '11 at 20:46
    
I have SQL Server Integration Services 10.0 running on the machine. –  Alex Mar 8 '11 at 20:53
add comment

1 Answer

up vote 0 down vote accepted

It is a system stored procedure in msdb.

share|improve this answer
    
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 8 '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 8 '11 at 20:45
    
That worked perfectly! Thanks @mrdenny –  Alex Mar 8 '11 at 21:12
    
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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.