locked
the select permission was denied on the object 'sysjobs', database 'msdb', schema 'dbo' RRS feed

  • Question

  • Hi

    In one of the scripts i need to select the jobs from msdb..sysjobs but while selecting the jobs from msdb i am getting the select permission was denied on the object.

    can you please suggest me what permissions required to select the msdb..sysjobs?

    Thanks in Advance!!

    Thanks

    Surendra
    Tuesday, May 14, 2013 5:24 AM

Answers

  • Thanks for all your support, as work around it required the TargetServerRole permission on msdb database.
    Tuesday, May 14, 2013 9:40 AM

All replies

  • I think your account need to be in admin role.

    After that go to MSDB DB to grant permission sp_start_job,sp_stop_job and execute permission.


    Regards, RSingh

    Tuesday, May 14, 2013 5:32 AM
  • You need to GRANT permission to the object.

    Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

    Tuesday, May 14, 2013 5:44 AM
  • To access these list sysadmin role must be mapped with the user.
    Tuesday, May 14, 2013 6:14 AM
  • Thanks for all your support, as work around it required the TargetServerRole permission on msdb database.
    Tuesday, May 14, 2013 9:40 AM