shceduling a sql query

[Lido98]

Hi friend

I have a question of 2 parts
I have to insert new entries from a file in a table once every month
Is there a way to shcedule an sql query to run once per month, and the second part is how can I only insert some of the fiields an not all the fields for instans I have the following file struktue

name;age;adress;compnay

But I want only to insert name and compnay in the table.

Thanks a lot for your help.

[punitdam]

You can create job.
Job can be scheduled as per your need.
Which MS SQL version are you using?

[Lido98]

Hi again

It is 2005 version.

Thanks

[Lido98]

Thanks, I have created the job .