Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.


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.

share|improve this question
add 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.

share|improve this answer
    
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 '12 at 12:31
    
@Sivajith so are you also asking how to write the query? I think that needs to be a separate question. –  Aaron Bertrand Jun 18 '12 at 12:56
    
@Sivajith Aaron is right, are you looking for query help? –  Thomas Stringer Jun 18 '12 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 '12 at 16:13
    
Ok, so my answer answers your question then? –  Thomas Stringer Jun 18 '12 at 16:15
show 1 more comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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