Azure Database Support Blog

  • 300 Blog Articles
Options
17.1K
MelaniaNitu on 12-12-2020 05:49 AM
769
Jose_Manuel_Jurado on 12-11-2020 01:03 PM
594
Jose_Manuel_Jurado on 12-11-2020 11:38 AM
1,049
Jose_Manuel_Jurado on 12-10-2020 01:17 PM
968
Jose_Manuel_Jurado on 12-03-2020 09:53 AM
1,173
Jose_Manuel_Jurado on 12-01-2020 12:27 PM
733
Jose_Manuel_Jurado on 12-01-2020 10:16 AM
781
Jose_Manuel_Jurado on 11-30-2020 11:17 AM
645
Ahmed_S_Mahmoud on 11-30-2020 06:03 AM
976
Thamires_Lemes on 11-30-2020 04:00 AM
897
Jose_Manuel_Jurado on 11-30-2020 12:23 AM
985
Jose_Manuel_Jurado on 11-24-2020 12:04 PM
1,224
Jose_Manuel_Jurado on 11-23-2020 02:38 PM
1,201
Jose_Manuel_Jurado on 11-23-2020 01:23 AM
821
Jose_Manuel_Jurado on 11-20-2020 05:52 AM
579
Jose_Manuel_Jurado on 11-19-2020 04:10 AM
886
Jose_Manuel_Jurado on 11-19-2020 03:40 AM
2,228
Diego_N on 10-28-2020 09:04 AM
1,095
MelaniaNitu on 10-28-2020 07:37 AM
1,529
Thamires_Lemes on 10-23-2020 09:55 AM
1,734
Thamires_Lemes on 10-23-2020 09:29 AM
2,123
Jose_Manuel_Jurado on 10-21-2020 04:26 PM

Latest Comments

Hi @proesler Thank you for reaching out, you may use the instructions to create the Elastic Jobs setup. you can then use any procedure you like to be automated with the Job. when you create the job step using "sp_add_jobstep" use your preferred Maintenance procedure in the @command parameter. just m...
0 Likes
Hi @Yochanan_MSFT Thanks for your work! The updated script works perfectly!
1 Likes
Hello, we want to use Elastic Jobs in Azure to do that. We found that instruction on the web:Automating Azure SQL Database index maintenance using Elastic Job Agents (sqlshack.com)How do we need to adjust your script so it would work with the instructions above? We want to run many jobs parallel.Br,...
0 Likes
@nreddipalle - Thank you for reporting back. I fixed the wrong condition in the procedure. you may download the current version and replace it in your environment. Again - Thank you for your feedback this is very valuable for me to improve this maintenance script. Yochanan.
1 Likes
Hello , I am running this script successfully via automation account for the past 18 months. As I noticed recently that the script is being updated, I planned to use the updated script and seeing my automation account job getting timed out.. The old script completes the statistics update in approxim...
0 Likes
www.000webhost.com