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,

Code:
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
...