Very new VB user here.

I would appreciate any ideas or suggestions about the following situation.

We are setting up a SQL Server routine that will run and constantly poll a directory. As soon as something is found in that directory, we need SQL Server to run a VB program and pass it at least one parameter for VB to use in running a process that will update several tables.

What needs to be done on the VB side to be able to accept a parameter passed to it, either from SQL Server or possibly just from the command line ?

I know nothing about the SQL side at this time, but I am guessing it would have a command similar to "run vbprog parameter".

Thanks a lot for any feedback.