Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Lido
Starting Member
5 Posts |
 Posted - 2009-04-15 : 04:47:41
|
| Hi friendsI have a question of 2 partsI have to insert new entries from a file into a table then delete it , once every monthIs there a way to shcedule an sql query to run once per month and how , and the second part is how can I only insert some of the fiields and not all the fields for instans I have the following file struktuename;age;adress;compnay;titleBut I want only to insert name, adress and title in the table.Thank you |
|
|
aprichard
Yak Posting Veteran
62 Posts |
Posted - 2009-04-15 : 06:48:40
|
| We can schedule the Sql Query with Sql Server Management Studio by creating new job. |
 |
|
|
Lido
Starting Member
5 Posts |
Posted - 2009-04-17 : 13:20:50
|
| Thank you aprichardI managed to do it but do you know how I can delete the file after reading it. |
|
|
|
|
|
|
Shcdule job (file reading )