i need to run a procedure every first day of month.
And the procedure should automatically run at every month.
So with out using timer i have to use it.
So i Think Better to go for SqlServer agent and shedule it. what should i need to configure this...i am using sqlserver 2008R2 version.
If i use sqlserver agent whether it will affect the performance of the server?.
thanks in advance.
You need access to SQL Server Agent in order to do what you need to do. This is done through
You can create a job to adhere to your schedule, and then the job will execute whatever task it is that you need done.
As for the performance impact on the server, SQL Server Agent itself is negligable but whatever the job does will definitely be a consideration on when it is run, depending on how expensive the job is. To give a better estimate on server impact, please tell us exactly what you need the job to do.