Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

i want to know that how to update record in MS sql server 2012 using SharePoint 2010 Timer job.Or how to call MS Sqlserver procedure using sharePoint timer job every hours. Please help me any body,this is very urgent.

share|improve this question

1 Answer 1

There are tons of resources online about how to create timer jobs for sharepoint like this one and also from Microsoft in the MSDN here

What you would have to do is to replace the content of the Execute method with your custom code to update the SQL database.

And in the EventReceiver that installs the Timer Job you should do an new SPHourlySchedule (that schedules the timer job to be executed hourly)

For an extremly detailed guide to how you can create and deploy Timer Jobs I would recommend this blogpost

As you can see, there are many steps involded, each probably already well documented both here on stackexchange and on different blogs. But I think that the last blogpost really teaches you the basics.

For more information about how to update the SQL database i recommend you to just google terms like "update SQL database from C#" or variants on the same theme.

share|improve this answer

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.