Hi Friends,
I have created a job with (Operating system (CmdExe)),
I have below scenario
If table TABLE_A has records then only execurte this exe. I am not in the position of hardcoding the Database Name.
could you please provide the way to perform this
Sample Psudo code in want to implement in that JOB. I am not allowed to use XP_COMMANDSHELL here. so i am not in the position of making his job as T-SQL .
If exists (SELECT * FROM table_A)
BEGIN
"c:\SomeExecutable.exe"
END
I know this is kind of confusing. Please do the needful.
Thanks in Advance
Parixitsinh