Tuesday, July 18, 2023

SQL Server - How to trigger a process to stop SQL Agent Job when data insertion happened in a table

To trigger a process after insertion, we need to create INSERT trigger which trigger the process once data insert into table. 
Following are step(s):
1) Create a INSERT trigger on table
2) In the trigger definition, write the logic to stop the SQL Agent Job(s) based on Insertion if it is running.
USE msdb;
GO

IF EXISTS (
		SELECT 1
		FROM INSERTED
		)
BEGIN
	EXEC dbo.sp_stop_job N'YourJobName';
END
GO

No comments:

Post a Comment