Post reply

Text file import every 15 seconds to MSDE

  • October 17, 2002 at 9:20 am

    #105208

    I am migrating an Access application to MSDE that needs to import a small (19 rows, 5 columns) text file every 15 seconds. Currently planning on using bulk insert to do the updating. How can I trigger this operation every 15 seconds. In Access, this is very easy using OnTimer event coupled with VB. Thanks for the help. jrmoore

  • October 17, 2002 at 9:38 am

    #438789

    What about waitfor command in T-SQL? Sechedule job to run every one minutes. In the job, wait for 15 second and then perform the text file import.

  • October 17, 2002 at 10:15 am

    #438799

    Allen, thanks for the reply. However I have a question. Would running the scheduled job every 1 minute and using the waitfor/delay at 15 seconds run the import once every 1 minute or would it run it every 15 seconds in a recurring fashion (ie 4 times per minute)? The app requires it to run at least 4 times a minute through the business day. Thanks jr

  • October 17, 2002 at 11:53 am

    #438803

    SQL Server job can't be scheduled in seconds and that is why the job has to be scheduled in every one minutes in order to meet your request. In the job, the data import has to be run every 15 seconds (ie 4 times/minute).

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply