December 13, 2005 at 12:21 pm
I have a scheduled job that contains a DTS package. When I attempt to execute the job from a stored procedure under a datareader login the scheduled job fails with this message: Non-SysAdmins have been denied permission to run CmdExec job steps. The step failed.
When I login as a system admin everything is cool. However, when this rolls out the store procedure containing the sp_start_job will be called by a datareader login. Any thoughts on getting around the non-sysadmins problem? Thanks!
December 13, 2005 at 12:40 pm
Executing jobs under the context of cmdexxe is limited to users of the sysadmin role by default. This can be changed by right clicking on the SQL Server Agent and selecting properties. On the Job System Tab at the bottom you will wee where this is selected. Although it can be changed it is usually not hte best idea, however some cases require these types of modification. In addition to this you may need to change some execute permissions on some of the stored procedures you will be envoking.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply