Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Opening VB Program

Status
Not open for further replies.

chicdog

Programmer
Feb 28, 2002
84
US
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?
 
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]
 
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'
 
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]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top