I know some jobs can be run periodically or querys a database. how achievement run this code every "x" days in an azure sql table?
DELETE FROM [MobileServiceExtra].[ACTIVITY]
WHERE [NewsItemDate] < GETDATE()- 5
Add a comment
|
7 Answers
Windows Azure Scheduler is a new service that has just gone into preview - http://www.windowsazure.com/en-us/services/scheduler/. This looks like an all-purpose service to do this kind of thing. I don't expect SQL on Azure will ever support Agent.
1 Comment
Brett Rigby
Everything I have read about Azure suggests this is true; SQL Azure != SQL Server, and so things like the Agents are indeed missing - just means you have to find a workaround in this scenario.
It would seem that Azure does not support SQL Server Agent and scheduling of jobs.
According to a series of blog posts on MSDN you can however use the Windows Azure Worker role to schedule custom jobs (that run SQL):
I Miss You SQL Server Agent: Part 1
I haven't tried this, so I can't tell you if it's a viable solution.
Comments
We use Quartz.Net within our Azure combined web and worker role.
You can see my colleagues post about it here
2 Comments
Simon W
Use Windows Azure Scheduler instead of Quartz.
GraemeMiller
Quartz has features that Azure scheduler doesn't.
It looks like you're using Mobile Services. Mobile Services comes with a Scheduler which can connect to your database and do whatever you need in a recurring schedule.
More information:
Build your own SQL Server Agent for Windows Azure SQL Database with the Scheduler
You would end up writing a little bit of javascript in the Scheduler which will run your SQL statement:
function Call_sp_ClearOldLogs() {
console.log("Executing sp_ClearOldLogs...");
mssql.query('EXEC dbo.sp_ClearOldLogs', {
success: function(results) {
console.log("Finished executing sp_ClearOldLogs.");
}
});
}
answered Nov 17, 2013 at 23:17
Sandrino Di Mattia
24.9k2 gold badges63 silver badges66 bronze badges
4 Comments
Simon W
The mobile services scheduled tasks utilise the Windows Azure Scheduler (see next post). Good answer though :).
Sandrino Di Mattia
Where do you get your info that the Mobile Services Scheduler uses the Windows Azure Scheduler? The FAQ clearly states that these are independent from each other: windowsazure.com/en-us/pricing/details/scheduler
Simon W
See the second point on this page: windowsazure.com/en-us/services/scheduler
Sandrino Di Mattia
Oh, you got me. Didn't see that one!
You can use windows azure scheduler preview right now http://www.windowsazure.com/en-us/services/scheduler/.
Do check out the pricing,right now they are charging $10/month and it will be increased to $20/month once the preview period is over.
You can also try aditi scheduler http://www.aditicloud.com/ as well,the only issue with aditi scheduler is its available in azure store ( which is not accessible in many countries) and you have to use your credit card again to consume it.
Hope it helps!
Thanks.
Mohit Chhabra
Comments
If you are open to using a service for this, we offer this functionality within our Cotega service. The way that it works is that you create a stored procedure within your database to execute this code and simply set up a schedule for how often you want it to run.
Comments
You can use Azure Automation Runbook. Example here. I use this for daily table truncation, works perfect for me.