Post reply

Execute permission denied on sp_start_job

  • August 17, 2009 at 5:07 pm

    #203853

    Hi,

    we have sql 2000 Production server. On that server one of the windows group having 4 members.

    The have the following access priviledges in the user database and MSDB also.

    User Database: DB_owner

    MSDB : db_datareader, db_datawritter, Targetserverrole.

    Whey they try to execute a job it shows the following error.

    Error " Executed permission denied "sp_start_job" in "MSDB" database owner as "dbo".

    we have giiven execute permission also for that login. Stillwe are getting the same error.

    Balavenkatesh

  • August 17, 2009 at 5:11 pm

    #1040573

    The login has to be a sysadmin otherwise, can execute only jobs created by that login.

    In SQL Server 2000, Execute permissions default to the public role in the msdb database. A user who can execute this procedure and is a member of the sysadmin fixed role can start any job. A user who is not a member of the sysadmin role can use sp_start_job to start only the jobs he/she owns.

    Here is more information on the Microsoft Site,

    http://msdn.microsoft.com/en-us/library/aa260289(SQL.80).aspx

    Hope this helps.

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

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