I have a sql server stored procedure that needs to be run every month a a certain date and time. How can I schedule the stored procedure to be run automatically? I was thinking that the stored procedure could be kicked off from a batch file using sqlcmd utility.
But how can I kick off the batch file. The batch file will be on the server. not on my local machine.