How to schedule an export of data to xml

Hi gurus,

I need to be able to export a table to an xml file on the 1st of every month. How can I accomplish this using SQL.

Thanks!

SQL is structured query language, it has nothing to do with scheduling.

If your using SQL Server 2000 or later, you can schedule a "job" to run at intervals, using a utility called DTS. It also has the ability to create xml files from your database tables.