SQL DBA Blog

Tag: SQL Server Agent

SQL Server Agent Blog Post Archives: Includes tips and SQL Scripts from an experienced Microsoft SQL Database Administrator.

  • SQL Server Script: Enable or Disable All SQL Agent Jobs

    SQL Server Agent jobs automate tasks within SQL Server, but there are times when you need to enable or disable multiple jobs, such as during maintenance, troubleshooting, or system upgrades. This guide provides a script that generates SQL commands to enable or disable all SQL Server Agent jobs…

    Read More

  • List All SQL Agent Jobs in SQL Server

    SQL Server Agent jobs are needed for automating tasks such as backups, index maintenance, and data processing. This post provides a SQL script to list all SQL Server Agent jobs on an instance, along with useful tips to help understanding. How to List SQL Agent jobs in SQL…

    Read More

  • Include Execution Trace Messages in SQL Server Error Logs

    Execution trace messages in SQL Server Agent error logs can be helpful for diagnosing issues. This guide explains how to enable this option. Logs are always important if you’re supporting systems. The SQL Server Agent is used very often by DBA’s and Software Devs, so writing execution trace…

    Read More

  • How to Run Scheduled Tasks with SQL Server Express

    SQL Server Express lacks SQL Server Agent, which means scheduling tasks like index maintenance, backups, and other recurring operations requires an alternative approach. The best way to achieve this is by using Windows Task Scheduler with sqlcmd and a batch script. In this guide, we will walk through…

    Read More

  • Resolving “Index was out of range” in SSMS

    This post is here to help if you’ve encountered the following error while performing a task in SQL Server Management Studio (SSMS): Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index (mscorlib) In my experience, I’ve seen this…

    Read More

Categories
Tags

Always On Availability Groups (AAG) (4) AWS (4) AWS Redshift (6) Database Admin (72) Database Backups & Recovery (14) Database Mirroring (2) Error Messages (5) Failover Cluster Instances (FCI) (1) Git Commands (6) Importing & Exporting Data (2) Linked Servers (3) Linux Administration (2) Logging & Monitoring (1) Microsoft Patching (2) MySQL (4) Postgres (6) PowerShell Scripts (2) SQL Certificates & Encryption (3) SQL Server Agent (5) SQL Server CDC (2) SQL Server Data Types (2) SQL Server Management Studio (SSMS) (17) SQL Server Networking (3) SQL Server on Linux (1) SQL Server Patching (2) SQL Server Performance Tuning (6) SQL Server Processes (SPIDs) (7) SQL Server Replication (2) SQL Server Scripts (13) SQL Server Security (4) SQL Server Storage (10) Windows Admin (20) Windows Authentication (2) Windows Automation (1) Windows Events (2) Windows Firewall (4) Windows Subsystem for Linux (WSL) (18)