Eric Barro
ebarro at verizon.net
Fri Mar 14 13:11:48 CDT 2008
Mark, Create a scheduled job in SQL that has the 6 steps. Schedule the job to run every 30 minutes and you're done. Steps 1-3 would most probably be VBA scripts. Steps 4-6 would most probably be SQL stored procedures. Eric -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Mark A Matte Sent: Friday, March 14, 2008 8:10 AM To: Discussion concerning MS SQL Server Subject: [dba-SQLServer] Moving VBA to SQL Server Hello All, I currently have an MDB that does the following: 1. Checks FTP site to see if there are files.(does not know name of files) CONTINUE checking until there are files 2. Get FTP files. 3. Unzips FTP files. 4. Imports file. 5. Runs SQL stored in tables against new data. 6. Saves/emails results of SQL. 7. Cleans up and waits for 30 minutes. This works like a charm in Access...I plan on moving to SQL Server, creating a site to go with it and have it hosted. I need this thing to run every 30 minutes. Its been suggested that I use VB scripts since I am so familiar with VBA. I'm a little confused on the approach. Q1. Are these 6 different scripts...1 large script...some scripts...some SP? Q2. How do I launch/manage these tasks? They all have to run...but in order. Q3. If multiple Scripts and SP...how does 1 know the other is done? ...there are more questions...but this is more than enough for me to chew right now. I'm not really looking for code (would be nice if it landed in my inbox)...but more for suggested approaches and direction. Any thoughts/ideas/guidence? Thanks, Mark A. Matte _________________________________________________________________ Shed those extra pounds with MSN and The Biggest Loser! http://biggestloser.msn.com/ _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com