How to start a SQL Server job programmatically/using TSQL/Scrip?

If you need to start a SQL Server job using TSQL immediately, follow below syntax:

USE msdb ;
EXEC dbo.sp_start_job N'[Give the job name which needs to start]' ;

This can be very useful if you use a stored procedure or script to start a job based on some business logic. For more options with this stored procedure, please refer to