CODEWITHSUNDEEP
sql-serverazure
Alex Edelstein
Alex Edelstein

Reputation: 528

How can I get Azure to notify me when a db Copy operation is complete?

Our deployment process involves two db copy procedures, one where we copy the production db to our rc site for rc testing, and then one where we copy the production db to our staging deployment slot for rollback purposes. Both of these can take as long as ten minutes, even though our db is very small. Ah, well.

What I'd like to do is have a way to get notified when a db Copy operation is done. Ideally, I could link this to an SMS alert or email.

I know that Azure has a big Push Notification subsystem but I'm not sure if it can hook the completion of an arbitrary db copy, and if there's a lighterweight solution.

Upvotes: 0

Views: 124

Answers (1)

Shaun Xu
Shaun Xu

Reputation: 4656

There are some information about copy database in this page, http://msdn.microsoft.com/en-us/library/azure/ff951631.aspx. If you you are using T-SQL you can check the copy process through the query likes SELECT name, state, state_desc FROM sys.databases WHERE name = 'DEST_DB'. So you can keep running this query and send SMS when it shows finished.

Upvotes: 1

Related Questions