Link to home
Start Free TrialLog in
Avatar of Jasmine Sandlas
Jasmine SandlasFlag for Oman

asked on

Can I run the informatica workflow which happened to be in another server, from my SQL agent job which happen to be in different server?

Can I run the informatica workflow which happened to be in BI14 server, from my SQL agent job which happen to be in BI13 server?

Please help experts!

Running below code:- But got access is denied.

declare @result int;
declare @cmd as varchar(1000);

set @cmd = '\\BI14::PATH:\AB\CD\EF.bat\ Folder_Name Workflow Name';

create table #output (id int identity(1,1), output nvarchar(255) null)
insert #output (output) EXEC @result = xp_cmdshell @cmd
select @result = count(1) from #output where output like '%successfully%';
--drop table #output

IF (@result = 0) RAISERROR (50001, -1, -1);
ASKER CERTIFIED SOLUTION
Avatar of Jasmine Sandlas
Jasmine Sandlas
Flag of Oman image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Jasmine Sandlas

ASKER

I searched and got it