Hi,
I have created an agent on order release, one of the actions is a direct sql with a stored procedure call. Users run the agent with an action.
My problem is the execution time. If I add the action on a domain D1, the agent took one minute to get the result, but if I create a new action and agent on other domain D2 that runs the same stored procedure it took 10 minutes or more.
Also I am not able to run the action on D2 from D1 but Domain D1 has ALL_TS grant on D2.
Does anyone know if there is any problem on direct sql with stored procedure , domains and subdomains.
Thanks you very much in advance.
I have created an agent on order release, one of the actions is a direct sql with a stored procedure call. Users run the agent with an action.
My problem is the execution time. If I add the action on a domain D1, the agent took one minute to get the result, but if I create a new action and agent on other domain D2 that runs the same stored procedure it took 10 minutes or more.
Also I am not able to run the action on D2 from D1 but Domain D1 has ALL_TS grant on D2.
Does anyone know if there is any problem on direct sql with stored procedure , domains and subdomains.
Thanks you very much in advance.
Comment