up vote 0 down vote favorite
share [g+] share [fb]

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?

link|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
feedback

1 Answer

up vote 0 down vote accepted

It is a system stored procedure in msdb.

link|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
feedback

Your Answer

 
or
required, but never shown
discard

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