How to run SQL job from Tessitura report?

Hi All,

Good day.

Does anyone have an idea how to run SQL job from Tess report?

I have a SSIS package can be run by sql job, it exports excel files and send out emails.

I am trying to let Tessitura users to run sql job by Tessitura reports.

I get this error message:

=====

Select Error: SQLSTATE=42000

Microsoft OLE DB Provider for SQL Server

The specified @job_name('MTC Performance contact list') does not exist.

=====

if I run the sp in sql management studio, it will do what it should.

execute dbo.LRP_MTC_CANCEL_PERF_CONTACT_LIST   @email = 'b.gu@mtc.com.au'

I think it is a security issue with impUsers.

Thanks in advance.

have fun

Ben