Unable to View SQL Jobs
-
I have a user set up as db_owner in 'msdb' database but unable to view the jobs from Enterprise manager ? What permissions are needed?
Thanks
-
In case that it only wants to show jobs for user, it makes the following one adds to the user role: TargetServersRole, in case that it wants that the user manages jobs, execute procedures below:
USE master
GO
GRANT EXECUTE ON [dbo].[xp_readerrorlog] TO [public]
GO
USE msdb
GO
GRANT EXECUTE ON [dbo].[[sp_add_job] TO [TargetServersRole]
go
GRANT EXECUTE ON [dbo].[sp_add_jobschedule] TO [TargetServersRole]
go
GRANT EXECUTE ON [dbo].[sp_add_jobserver] TO [TargetServersRole]
go
GRANT EXECUTE ON [dbo].[sp_add_jobstep] TO [TargetServersRole]
go
GRANT EXECUTE ON [dbo].[sp_addtask] TO [TargetServersRole]
go
GRANT EXECUTE ON [dbo].[sp_delete_job] TO [TargetServersRole]
go
GRANT EXECUTE ON [dbo].[sp_delete_jobschedule] TO [TargetServersRole]
go
GRANT EXECUTE ON [dbo].[sp_delete_jobserver] TO [TargetServersRole]
go
GRANT EXECUTE ON [dbo].[sp_delete_jobstep] TO [TargetServersRole]
go
GRANT EXECUTE ON [dbo].[sp_droptask] TO [TargetServersRole]
go
GRANT EXECUTE ON [dbo].[sp_post_msx_operation] TO [TargetServersRole]
go
GRANT EXECUTE ON [dbo].[sp_purgehistory] TO [TargetServersRole]
go
GRANT EXECUTE ON [dbo].[sp_reassigntask] TO [TargetServersRole]
go
GRANT EXECUTE ON [dbo].[sp_start_job] TO [TargetServersRole]
go
GRANT EXECUTE ON [dbo].[sp_stop_job] TO [TargetServersRole]
go
GRANT EXECUTE ON [dbo].[sp_update_job] TO [TargetServersRole]
go
GRANT EXECUTE ON [dbo].[sp_update_jobschedule] TO [TargetServersRole]
go
GRANT EXECUTE ON [dbo].[sp_update_jobstep] TO [TargetServersRole]
go
GRANT EXECUTE ON [dbo].[sp_updatetask] TO [TargetServersRole]
go
or add user do sysadmin role
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply