SQLTeam.com | Weblogs | Forums

Long duration action in trigger - Azure Sql Server

#1

Hello,
I need to do some time-consuming process of some data in a trigger and Azure doesn't have "dbo.sp_start_job" to implement a separate process.
Any idea on how can this be implemented on Azure Sql Databases?

Thank you

0 Likes

#2

You want to start a sql agent job through a trigger??

0 Likes

#3

I'm not an Azure expert, but I think Azure Storage Queues would be a way to do this. The queue is processed async from the process inserting to the q.

0 Likes

#4

Thank you @mike01
Something like that BUT, as I said, Azure doesn't allow that (at least via dbo.sp_start_job)

0 Likes

#5

Thank you @ScottPletcher, I'll try this one.

0 Likes