AnsweredAssumed Answered

PSOS on PSOS

Question asked by aknudsen on Jul 20, 2017
Latest reply on Jul 20, 2017 by aknudsen

Here's a question I've not ben able to find an sewer to .... yet. I have several SQL wan connected servers I need to pull data from. I have a parent/child where the parent have the connection settings and the child the actual imported data. I need to loop through the parent table and spawn a subscript import data to the child table. I need to import several SQL servers at the same time. This server side schedule will execute once a day and I need to trap if there are already imports ongoing from the last time it ran.

 

So the questions are:

Will a subscript spawn a separate session or keep the same as the parent script?

Can I use PSOS to call a subscript from the server?

Is a recursive script my only option?

 

Any help is greatly appreciated.

Outcomes