sql server (alternate): Hi,
I have a requirement to update a table in SQL Server through a stored
procedure,
the stored procedure should run periodically, say once in a month, and
update the table.I should not use any external programs to call the
stored procedure, is there any other way to do it without using an
external programs.
Thanks in advance,

Schedule a job that calls the stored procedure:

http://msdn.microsoft.com/library/en-us/adminsql/ad_automate_4v1v.asp

--
David Portas
------------
Please reply only to the newsgroup
--

Thank you so much.

[quoted text, click to view]