Data Browser - Viewing Site  Sector 23 Code Bank Logged in as:  Guest  


Granting SQL user rights to start a SSIS Job
By default, only sa/admin users can start SSIS jobs, whether manually or by a schedule. To allow a normal SQL user to start a job, do the following:

Map the login user to the MSDB database and make sure the following roles are checked:

> db_ddladmin
> db_dtsadmin
> all SQLAgent roles.

You may also need to allow the following so your user can better see which jobs are not running and start them:

grant select on sysjobactivity to doclocator
grant select on sysjobs to doclocator
grant execute on sp_start_job to doclocator

Created By: amos 8/31/2010 11:20:13 AM
Updated: 8/31/2010 11:24:16 AM