Wednesday 29 February 2012

How to Change Maintenance plan job owner into sa


How to Change Maintenance plan job owner into sa  :

EXEC MSDB.dbo.sp_update_job
@job_name = 'DailyBackups',
@owner_login_name = 'sa'
GO

No comments:

Post a Comment