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!
@ianmcquade46644 жыл бұрын
Excellent explanation and demo; massively better than what is available at docs.microsoft.com, which is essentially useless!
@kohligaurav814 жыл бұрын
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.
@fullduckdev73272 жыл бұрын
hey David, I already knew EJA, but just stopped to say - great content!
@stephenbliss40525 жыл бұрын
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.
@peoriaos66274 жыл бұрын
Thanks David. This was very detailed and I was able to do a poc based on your instruction.
@KamilNowinski4 жыл бұрын
Thanks David for this video, good stuff. Unfortunately, almost 2 years later, Elastic Job Agents is still in preview.
@mrrakeshreddy284 жыл бұрын
Thanks for the details explanation and Scripts David. May god bless you for your good heart (Y)
@marciovieira15404 жыл бұрын
Thank you for such valuable information! Great job
@patchydrizzle28584 жыл бұрын
yep, that was a great explanation, very useful , ta!
@pckroezen5 жыл бұрын
David, can you share with us the scripts you're using in this video?
@DavidPostlethwaiteSQL5 жыл бұрын
I've put the sql script here 1drv.ms/f/s!AoTIKCDACoJWgcdrEo06NEgSbzCq6g
@srigurusankar3 жыл бұрын
@@DavidPostlethwaiteSQL David you are create, Thanks bro
@FWSBASH2 жыл бұрын
Im still slightly confused by the logins. Why can't we just use one login and grant the permissions necessary to run?
@radheyazunjur87022 жыл бұрын
Hello David, Can you tell me where is the Creation Script of jobs.sp_add_target_group ?
@srinuit545 жыл бұрын
good session, could you please share the script which you have been used in presentation??
@vktop22 жыл бұрын
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?
@eduardo.sanchez4 жыл бұрын
Thank you very much for this video!
@xenomorph13033 жыл бұрын
Thank you David!
@miguelcajas903 жыл бұрын
Good video!!!
@nagurymec2 жыл бұрын
Hi David, is there a way to schedule the job to run on specific days at a specific time, in a week?
@lflewwelling24 жыл бұрын
Thank you for doing this!
@eloyo793 жыл бұрын
Hi David, any idea how one would configure a job if public access is disabled?
@andyngo75654 жыл бұрын
Great video David, is there any way for us to monitor the job and create alerts that report on failure?
@saathvikjadhav82423 жыл бұрын
Hi David! This is a very detailed explanation and thank you for your content. How do we execute stored procedures using elastic jobs?
@adrianimpedovo52372 жыл бұрын
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.
@damn685 жыл бұрын
Very nice and easy to execute
@smashinghum5 жыл бұрын
my sql db is not in an elastic pool, does it have to be in an elastic pool to have an elastic job ?
@nayanbhagawati42323 жыл бұрын
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