Automator PostProcess Script to launch another process

Hi there, I've been having a bit of trouble trying to figure this issue out so figured I'd ask around here to see if anyone can help.

I've got a project in Automator that extracts data from a flat file into a SQL table for record keeping. The process will run on file monitor since multiple files get dropped throughout the day that need to be appended to the table. I have another project that exports data from the table to a spreadsheet that is then sent to other teams. The problem I'm having is, I cannot setup file monitoring with both projects on the same standard process, since the report file project is an export from a SQL table, there is no input distribution option. So, what I would like to do is setup a standard process for each project. The first runs on file monitor and picks up any files when they're dropped and when it finishes, the second is launched by a PostProcess script. I don't really know VB.NET so not even sure how to formulate a script that does this nor do I know how to setup the references and imports, or global declarations to get the script to work.

I was given this old script by a coworker but we've been unable to get it to work: 

Dim PumpAPI As DwchServer.PumpAPI

Dim strTrackingID As String

Dim strProcess(0) as string

Dim strCurrent as string

PumpAPI = New DwchServer.PumpAPI("default")

 

strProcess(0) = "PROCESS NAME"

 

for each strCurrent in strProcess

                Try

                                strTrackingID = PumpAPI.StartProcess(strCurrent)

                                Catch ex As Exception

                                Log.AddEvent("Process: " + strCurrent + "   Status: Failed to start - " + ex.Message)

                end try

next strcurrent

I tried searching around the community here, and every post I found related to my issue had links to other threads that have since been removed. I've already reached out to Altair for assistance with this issue and they offered assistance at a price so they might remove these types of posts since they're trying to profit off these types of answers but hopefully I can get the help I need!

Thanks in advance for any assistance.

-Max

------------------------------
Max Strahan
SQL Developer
------------------------------