1


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.

1 Answer 1

4

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.

6
  • hi,thank u.. i need to credit the leave balance of employees every month.there are 750 employees..and i need to do this..\
    – Sivajith
    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. Jun 18, 2012 at 12:56
  • @Sivajith Aaron is right, are you looking for query help? 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..
    – Sivajith
    Jun 18, 2012 at 16:13
  • Ok, so my answer answers your question then? Jun 18, 2012 at 16:15

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.