Skip to content
sqlkitty

sqlkitty

sql for everyone

Menu
  • Home
  • About
  • Auditing
  • Code
  • Presentations
  • Publications
  • Contact

Category: jobs

PowerShell (and T-SQL) and Elastic Jobs

  • Posted onFebruary 7, 2025February 27, 2025
  • azure

I’ve covered how to create Elastic Jobs in the portal (this one is important to read if you aren’t familiar with elastic jobs already), with Terraform, and with Bicep. Now, I’ll cover how to create them and their associated objects with PowerShell. Don’t do this…

Continue Reading

Elastic Jobs for Azure SQL DB

  • Posted onApril 16, 2024April 17, 2024
  • azure

I know if you are a SQL Server DBA using Azure SQL DB, you’ve been sorely missing the agent. Enter Elastic Jobs to help you schedule jobs more easily against Azure SQL DB. I will cover setting up and scheduling Elastic Jobs to execute Ola…

Continue Reading

Testing SQL Server backups and offloading integrity checks

  • Posted onMay 18, 2021November 6, 2022
  • jobs

We have a fair number of pretty large databases, and I was having a hard time scheduling full integrity checks to run at least once a week. For a long time, I only ran physical_only with my fingers crossed, but finally, I got a new…

Continue Reading

updating multiple jobs on sql agent with a prefix

  • Posted onAugust 16, 2019
  • jobs

This came up because we had many sql agent jobs that DBA’s don’t want to be alerted to like sql agent jobs that run SSIS packages.  Those alerts need to be sent to the database developers instead.  We use Idera Diagnostic Manager to send failed…

Continue Reading

Newletter Signup

Loading

Recent posts

  • T-SQL Tuesday #186 Invitation – Managing Agent Jobs
  • Query multiple Azure SQL Databases
  • Azure Vulnerability Assessments
  • Using Cron in Postgres Flex
  • Why use XACT_ABORT?

Categories

  • audit (2)
  • azure (45)
  • containerization (14)
  • datawarehousing (4)
  • dba (52)
  • editorial (8)
  • excel and others (3)
  • IT Certifications (1)
    • network+ (1)
  • linux (2)
  • network administration (15)
  • newjob (7)
  • other (8)
  • performance (1)
  • postgresql (16)
  • powershell (1)
  • security (3)
  • sql server (22)
  • sql server administration (124)
    • jobs (4)
  • sql sever syntax (78)
  • terraform (5)
  • tsql2sday (2)
  • web dev (6)
  • zen (2)

Archives

  • June 2025 (1)
  • May 2025 (2)
  • April 2025 (2)
  • March 2025 (3)
  • February 2025 (3)
  • January 2025 (4)
  • November 2024 (3)
  • October 2024 (1)
  • September 2024 (2)
  • August 2024 (1)
  • July 2024 (5)
  • June 2024 (4)
  • May 2024 (4)
  • April 2024 (3)
  • March 2024 (2)
  • February 2024 (1)
  • January 2024 (5)
  • December 2023 (2)
  • November 2023 (5)
  • October 2023 (1)
  • September 2023 (1)
  • August 2023 (2)
  • July 2023 (2)
  • June 2023 (3)
  • May 2023 (4)
  • April 2023 (3)
  • March 2023 (5)
  • January 2023 (1)
  • October 2022 (2)
  • April 2022 (1)
  • December 2021 (1)
  • May 2021 (1)
  • April 2021 (2)
  • February 2021 (7)
  • January 2021 (4)
  • December 2020 (2)
  • November 2020 (1)
  • January 2020 (2)
  • December 2019 (3)
  • August 2019 (2)
  • February 2019 (1)
  • June 2018 (1)
  • January 2018 (1)
  • September 2017 (1)
  • May 2016 (4)
  • January 2016 (2)
  • December 2015 (2)
  • August 2015 (2)
  • July 2015 (4)
  • June 2015 (3)
  • May 2015 (9)
  • April 2015 (4)
  • November 2014 (7)
  • October 2014 (19)
  • September 2014 (3)
  • July 2014 (2)
  • July 2013 (1)
  • December 2012 (1)
  • October 2012 (1)
  • December 2011 (6)
  • October 2011 (6)
  • September 2011 (5)
  • July 2011 (1)
  • June 2011 (1)
  • May 2011 (2)
  • April 2011 (1)
  • February 2011 (15)
  • January 2011 (19)
  • December 2010 (14)
  • November 2010 (16)
  • October 2010 (3)

RSS SQL Kitty RSS

  • T-SQL Tuesday #186 Invitation – Managing Agent Jobs
  • Query multiple Azure SQL Databases
  • Azure Vulnerability Assessments
  • Using Cron in Postgres Flex
  • Why use XACT_ABORT?
© Copyright 2025 – sqlkitty
Chip Life Theme by TutorialChip ⋅ Powered by WordPress