Granting access to users to run specific SQL jobs that runs SSIS packages We need to grant a couple of users access to run only specific SQL jobs that runs SSIS packages. Is there a solution that can be used to accomplish this?
Create a stored procedure that uses sp_start_job and grant the execute permission on the stored procedure to the necessary users.  The stored procedure can use EXECUTE AS to elevate its permissions so that it can start the job even though the users don't have permission to start the job.