How to schedule a stored procedure?

Question

How do I schedule a stored procedure in Sql Server 2005 that it runs once at the start of every month (and on database startup)?

Answer 1

You will need to create a job using the SQL Server Agent.

Answer 2

In SSMS, go expand the SQL Server Agent node under the DB server, right click the "Jobs" folder and select "New job...". That will take you through a wizard to schedule a sproc to run on whatever schedule you want.

In terms of how to get a sproc to run on db startup, see this article.