Call Sql Server Agent job using SP_Start_Job Stored Procedure in SQL Server to execute SSIS package

We can all any SQL Server Agent job using SP_Start_job System SP. Here we will see how to call an SSIS package which is scheduled in the SQL Server Agent.

Let’s see this demo

I am creating a simple package. This package I so simple, in this package I am inserting a record into a table.

  

Inserting a table into this package

  

Now I am running this package

  

Package executed successfully.

See the record into the table

  

Now I am creating a job to schedule the SSIS package.

  

Now I am running this job for test

  

See records in the table

  

Writing the SQL script to call this job

USE msdb ;  GO   EXEC dbo.sp_start_job N'TestJob' ;  GO

Before running this script record in the table.

  

Now running this script

  

Job executed successfully.

See the records in the table

  

We can see the job execution details in Job History