Execute a batch file using sql server

[kishore88]

I have a bat file which execute the Pentaho kettle job whenever my source update.

so in sql server i create a trigger whenever my source update.
I used this command,

CREATE TRIGGER dbo.job_trigger 
   ON  dbo.test 
   AFTER INSERT,DELETE,UPDATE
AS 
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	EXEC master..xp_CMDShell 'C:\testjob.bat';

    -- Insert statements for trigger here
END
GO

whenever I insert a new record it goes in infinite loop.


Please help who can I execute the batch file using trigger.

[Rabbit]

Your batch files is probably doing something to cause an infinite loop. It's probably inserting a record into the test table which triggers job_trigger. But that's a guess because you haven't told us what the batch file does.