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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Self-Executing Queries

Author  Topic 

juancruzhurtado
Starting Member

3 Posts

Posted - 2006-10-18 : 13:43:25
Hello everybody!
I have this question:

Is it possible to have SQL Server execute certain query automatically the first day of the month?
Or do I have to do it manually?
More specifically, I want it to save certain monthly billing charges into a table.

Hope somebody can help me.

Thank you for your time,

Juan

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-10-18 : 13:47:08
You can create a SQL Server job that runs monthly.

Tara Kizer
Go to Top of Page

juancruzhurtado
Starting Member

3 Posts

Posted - 2006-10-18 : 13:51:32
Awesome, I'll look into that.

Thanks!
Go to Top of Page
   

- Advertisement -