question

Ok, seems like you are using maintenance plan wizard from SSIS. I have updated the tags accordingly. Frankly speaking, I am not a fan of maintenance plans. They sometimes behave abnormally.

Can you please share the script for that?

Hi Usman, Thanks For your response then my script is DECLARE @jobId BINARY(16) EXEC @ReturnCode = msdb.dbo.sp_add_job @job_name=N'DailyDiffBackupForTaxExcise.Subplan_1', @enabled=1, @notify_level_eventlog=2, @notify_level_email=0, @notify_level_netsend=0, @notify_level_page=0, @delete_level=0, @description=N'No description available.', @category_name=N'Database Maintenance', @owner_login_name=N'Administrator', @job_id = @jobId OUTPUT IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback /****** Object: Step [Subplan_1] Script Date: 06/01/2012 00:53:42 ******/ EXEC @ReturnCode = msdb.dbo.sp_add_jobstep @job_id=@jobId, @step_name=N'Subplan_1', @step_id=1, @cmdexec_success_code=0, @on_success_action=1, @on_success_step_id=0, @on_fail_action=2, @on_fail_step_id=0, @retry_attempts=0, @retry_interval=0, @os_run_priority=0, @subsystem=N'SSIS', @command=N'/Server "$(ESCAPE_NONE(SRVR))" /SQL "Maintenance Plans\DailyDiffBackupForTaxExcise" /set "\Package\Subplan_1.Disable;false"', @flags=0

Are you using exactly the same configuration of server version / client version that you originally used? Have you applied a service pack in the mean time in one place but not another? What version of SSMS? What exact version of SQL Server?

I am using SQL Server 2005 Standard Edition and SSMS also same version.