Opening VB Program

[chicdog]

Currently I have a VB program that checks our database to see if data for a location has been downloaded every 10 seconds. It then creates a spreadsheet then goes back to checking every 10 seconds. Is there a way for SQL to start the process of creating the report?

 

[donutman]

You can schedule a job to run every 10 seconds. Depending on what you mean by downloaded, it could probably check for that status and execute a VB app from a command shell.
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]

 

[chicdog]

I see what you mean. Am I close on how the command shell would look? Aslo I currently have the program on a seperate machine from the SQL Server, do I need to anything to the code below?

xp_cmdshell 'programname.exe'

 

[donutman]

Yes, but that would run on the server. BTW, I believe you can have a DTS package create the Excel spreadsheet for you. You wouldn't need a VB program at all. I forget how to do it, so maybe someone else can help you. There's a thread on it sometime in the past.
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]