Schedule SP in SQL Agent

133 Views Asked by KAN At 14 December 2019 at 12:07

I have an stored procedure which run an SSIS package.

Below is the script

CREATE PROCEDURE MRA
AS
Declare @execution_id bigint
EXEC [SSISDB].[catalog].[create_execution] @package_name=N'CNP_FORMAT.dtsx',
@execution_id= @execution_id OUTPUT,
@folder_name=N'MRA',
  @project_name=N'CNP_FORMAT',
@use32bitruntime=False,
  @reference_id=Null
EXEC [SSISDB].[catalog].[start_execution] @execution_id

The script run correctly in sql server where targeted table are uploaded correctly. I have schedule above script in SQL Agent. Schedule Job runs without errors but targeted table NOT uploaded.

Means the schedule job in SQL Agent did not run the ssis package!

I'm currently stuck with this issue and don't know how to proceed.

There are 0 best solutions below