Richard Comito
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you! That was it.
Gabicus