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.