I am trying to execute an SISS package that I have stored on the server from a stored procedure using the following ;
EXEC msdb.dbo.sp_start_job @job_name = 'AvantixImport'
but I get the message The specified @job_name ('AvantixImport') does not exist.
I can see the job listed under Integration Services / Stored Packages / MSDB but cannot run it. Any ideas please ?