execute job from database

execute.job.from.database.sql

Use Master
GO
EXEC master.dbo.sp_configure 'show advanced options', 1
RECONFIGURE WITH OVERRIDE
GO
EXEC master.dbo.sp_configure 'xp_cmdshell', 1
RECONFIGURE WITH OVERRIDE
GO



--EXEC sp_xp_cmdshell_proxy_account 'DOMAIN-DOM\depl-mb', 'PASSWORD';
--GRANT exec ON xp_cmdshell TO [wdmm-doMm\depl-mb];

EXEC AS User = 'wdmm-dom\depl-mb'
GO

declare @myparams as varchar(255)
declare @sql as varchar(255)
set @myparams='test'
set @sql = '\\hw-srv-job3\Services\PWTest\PANIDEnrichment.exe "sendAddressDataToIveBoard ' + @myparams + '"'
EXEC xp_cmdshell 'whoami'
EXEC xp_cmdshell @sql

REVERT; -- set back to nt service\mssqlserver