Greetings,

I'm a seasoned SQL Server Developer (not on SQL Azure) where I could schedule a SQL job using the SQL Agent to execute a stored procedure which would use sp_send_dbmail to send emails out to contacts in my db based on certain criteria. Now that I'm using Windows Azure and SQL Azure, how do I accomplish the same thing.

Thank you in advance.

JohnD

HI John,

SQL Azure does not support such jobs.

So if you have need to such jobs you might wanna go with SQL on Azure VM or if you can continue having jobs on OnPrem SQL then it would be one option.

Hi JohnD,

If you are willing to use a service for this, Cotega allows you to both execute scheduled stored procedures as well as to send emails from a SQL Azure database.

Full disclosure, I work on the Cotega service.

• Proposed as answer by Cotega Monitoring Monday, December 30, 2013 4:48 PM

Hi JohnD,

If you are willing to use a service for this, Cotega allows you to both execute scheduled stored procedures as well as to send emails from a SQL Azure database.

Full disclosure, I work on the Cotega service.

• Proposed as answer by Cotega Monitoring Monday, December 30, 2013 4:48 PM

Hi JohnD,

If you are willing to use a service for this, Cotega allows you to both execute scheduled stored procedures as well as to send emails from a SQL Azure database.

Full disclosure, I work on the Cotega service.

• Proposed as answer by Cotega Monitoring Monday, December 30, 2013 4:48 PM

Hi JohnD,

If you are willing to use a service for this, Cotega allows you to both execute scheduled stored procedures as well as to send emails from a SQL Azure database.

Full disclosure, I work on the Cotega service.

• Proposed as answer by Cotega Monitoring Monday, December 30, 2013 4:48 PM

Hello,

Windows Azure SQL database doesn't support  SQL Server Agent. You can refer to the following blog about how to use Windows Azure worker role and custom code to schedule job:
http://sqlazureagent.codeplex.com/

Regards,
Fanny Liu