I need to schedule some queries to run at the beginning of every month (for monthly reports) and I read that creating a JOB in sql server 2008 was the way to go. Unfortunately, I don't have the rights/privileges to use SQL Server Agent at this time. Is there another way of scheduling a few queries to run the first day of every month?
I am running Sql Server 2008 R2 on Windows Server 2008 R2 Standard operating system.
Best Answer
SQL Jobs is indeed the right way about it.
If you don't have the permissions, talk to your manager/DBA in order to set up the job.
If this is not possible, you can use the task scheduler in conjunction with sqlcmd to execute queries on the SQL Server.
Another alternative is to write a windows service that will execute these queries, but in terms of scheduling I would trust the task scheduler over custom code.