Azure Elastic Database Jobs -Elastic Job Agents

[@adrianimpedovo5237]

I've been through 3 Elastic Job Agent tutorials and this is the only one I understood (and the only one that worked fully). Great stuff!

[@ianmcquade4664]

Excellent explanation and demo; massively better than what is available at docs.microsoft.com, which is essentially useless!

[@kohligaurav81]

David, a fantastic and simple explanation for a complex functionality that is still in preview (almost 1.5 years later) but is crucial. Thanks for your efforts.

[@fullduckdev7327]

hey David, I already knew EJA, but just stopped to say - great content!

[@stephenbliss4052]

Great Presentation Dave. I have been experimenting with this as a replacement as it's a much needed enhancement to managing Azure Databases. I have noticed that if you define a multi step job the ordering seems to be reversed with the latest step defined being placed and executed first.

[@peoriaos6627]

Thanks David. This was very detailed and I was able to do a poc based on your instruction.

[@mrrakeshreddy28]

Thanks for the details explanation and Scripts David. May god bless you for your good heart (Y)

[@marciovieira1540]

Thank you for such valuable information! Great job

[@KamilNowinski]

Thanks David for this video, good stuff. Unfortunately, almost 2 years later, Elastic Job Agents is still in preview.

[@RadheyaZunjur]

Hello David, Can you tell me where is the Creation Script of jobs.sp_add_target_group ?

[@patchydrizzle2858]

yep, that was a great explanation, very useful , ta!

[@srinuit54]

good session, could you please share the script which you have been used in presentation??

[@FWSBASH]

Im still slightly confused by the logins. Why can't we just use one login and grant the permissions necessary to run?

[@pckroezen]

David, can you share with us the scripts you're using in this video?

[@DavidPostlethwaiteSQL]

I've put the sql script here 1drv.ms/f/s!AoTIKCDACoJWgcdrEo06NEgSbzCq6g

[@srigurusankar]

@@DavidPostlethwaiteSQL David you are create, Thanks bro

[@eloyo79]

Hi David, any idea how one would configure a job if public access is disabled?

[@andyngo7565]

Great video David, is there any way for us to monitor the job and create alerts that report on failure?

[@nagurymec]

Hi David, is there a way to schedule the job to run on specific days at a specific time, in a week?

[@smashinghum]

my sql db is not in an elastic pool, does it have to be in an elastic pool to have an elastic job ?

[@eduardo.sanchez]

Thank you very much for this video!

[@xenomorph1303]

Thank you David!

[@vktop2]

Nice Video! I want to update a couple of tables in a database every 5 minutes, I already have a stored procedure that performs this task, my question is: What is the most effective and least expensive method for this, Azure Elastic Jobs or Azure Functions?

[@lflewwelling2]

Thank you for doing this!

[@saathvikjadhav8242]

Hi David! This is a very detailed explanation and thank you for your content. How do we execute stored procedures using elastic jobs?

[@adrianimpedovo5237]

The only change from this tutorial you need to make to get stored procedures to work using elastic jobs is to make sure your users on your dbs have permission to run stored procedures. If you go into each of the databases the sql agent will run on and run GRANT EXEC TO [User_Name]; where username is the login you made for the server agent, it will work.

[@nayanbhagawati4232]

I am getting Error while executing the job Error Msg: "Failed to connect to the target database: Login failed for user 'job_credential'. (Msg 18456, Level 14, State 1, Line 65536)" Can you suggest

[@miguelcajas90]

Good video!!!

[@damn68]

Very nice and easy to execute

[@vsivanantham]

Exceleent one, can you share with us the script