Post reply

Not able to create a schedule for a job

  • December 22, 2009 at 7:02 am

    #137750

    Hi,

    One of the users is not able to create a job schedule. When he is trying to create it, below is the error message he is receiving.

    The schedule was not attached to the specified job. The schedule owner and the job owner must be the same or the operation must be performed by a sysadmin.

    When I checked the package owner_sid it is different from the Job owner_sid. Is this the problem? If I make the package owner_sid same as ob owner_sid will he be able to make a schedule.

    I have given SQLAgentOperator role to the user and also made him the job owner.

    Please suggest

    Thanks

  • December 22, 2009 at 7:29 am

    #1095398

    I don’t think that it has to do with the package owner. The job has an owner. If you’ll right click on the job and then select properties, you’ll be able to see who the job’s owner is. According to the error message the job’s owner is not the same user that is trying to add\modify. I admit that I didn't know about this specification, because in my environment only the DBA can create/modify jobs.

    Adi

    --------------------------------------------------------------
    To know how to ask questions and increase the chances of getting asnwers:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply