Link to home
Start Free TrialLog in
Avatar of Richard Comito
Richard ComitoFlag for United States of America

asked on

How to run sp_start_job with in a stored procedure when the user does not have access to the MSDB database.

I have created a stored procedure that I would like to run from a SSRS report being used on a 3rd party software.  However the login to the 3rd party software does not have access to the MSDB database and I do not want them to have access to that database.  This report will give the end user the way to schedule the update without contacting me.  This is what I have for the sp:

create procedure lrp_Merge_Duplicates
as

execute msdb.dbo.sp_start_job 'Merge Duplicates'

Is there a I can do this.

Thanks,

Gabicus
ASKER CERTIFIED SOLUTION
Avatar of Chris Luttrell
Chris Luttrell
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Richard Comito

ASKER

CGLuttrell,

Thank you!  That was it.

Gabicus