hi
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.
Add a comment
|
1 Answer
You need access to SQL Server Agent in order to do what you need to do. This is done through msdb permissions: SQLAgentUserRole, SQLAgentReaderRole, and SQLAgentOperatorRole.
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.
answered Jun 18, 2012 at 12:29
-
hi,thank u.. i need to credit the leave balance of employees every month.there are 750 employees..and i need to do this..\– SivajithCommented Jun 18, 2012 at 12:31
-
@Sivajith so are you also asking how to write the query? I think that needs to be a separate question. Commented Jun 18, 2012 at 12:56
-
@Sivajith Aaron is right, are you looking for query help? Commented Jun 18, 2012 at 13:16
-
@Aaron.. no i am not asking for the query...i wrote it and executed but the problem is how to schedule it effectively..– SivajithCommented Jun 18, 2012 at 16:13
-