none
User cannot create Sql Agent Job

    Question

  • I have created the windows login as a user in the msdb database and added them to the SqlAgentOperatorRole , but I get this error when they try to create a new job. Does anyone know what may be causing this to happen? SQL Server 2012

    Thanks,

    B
     
    Friday, December 20, 2013 7:30 PM

All replies

  • Hi bretd25,

    Based on your description, we need to verify if you has set windows account with appropriate rights. If you add the account to SqlAgentOperatorRole, it just have access to all SQL Server Agent proxies. We need to verify that your account has permission to execute SP or T-SQL statement in the job step.

    There is a similar issue about error 15517, you can review the following link.
    http://dbaspot.com/ms-sqlserver/230869-effective-permissions-error-domain-user.html

    Thanks,
    Sofiya Li

    If you have any feedback on our support, please click here.


    Sofiya Li
    TechNet Community Support

    Saturday, December 21, 2013 1:39 PM
  • This is the error I receive when the user wants to create a brand new job.  There are no job steps yet or code to execute.  I know they should be able to create/administer their own jobs.  Just unsure why after putting them in the role they are unable to do that.

    Thanks,

    B

    Thursday, December 26, 2013 10:47 PM