Skip to content
February 6, 2023
  • Subscribe
  • Twitter
  • LinkedIN Group (Forum)
  • Facebook Group (Forum)
  • Facebook Page
  • YouTube
  • Telegram Group (Forum)
SQLServerGeeks

SQLServerGeeks

SQL Server Education (by the geeks, for the geeks)

Free Live Training Virtual Symposium DPD banglore
  • Blogs
    • Subscribe To Our Newsletter
    • SQLServerGeeks Bulletin Index
    • The Scripts Garage
    • All Blog Posts
    • One DMV a Day Series
    • Accidental DBA Series
    • One Operator a Day Series
    • One Trace Flag a Day Series
  • Magazine
  • Events
    • Browse Events
    • Suggest Topics
  • Videos
    • SSG Videos Lobby
    • SQL Server Tutorials & Demos
    • Webinar Recordings
    • SQLShighra Recordings
    • Virtual Symposium Recordings
      • SQL Server & Azure SQL – May 2021
      • SQL Server 2019 & Azure SQL – May 2020
    • Geek Talks
  • RESOURCES
    • SQL Server Resources
    • SQL Server Notes
  • Social
    • Subscribe To Our Newsletter
    • Twitter
    • LinkedIN Group (Forum)
    • Facebook Group
    • Facebook Page
    • YouTube Channel
    • Telegram Group (Forum)
  • About Us
    • Subscribe To Our Newsletter
    • SSG Team
    • Join Us
    • Speakers
    • Blog With Us
    • Contact Us
    • Write a Guest Post
    • Testimonials
    • Join DataPlatformGeeks community
  • Log In
  • Join Now
Main Menu

Tag: SQL Server agent

SQL Server

SQL Agent Job Error CMDEXEC subsystem failed to load

April 15, 2015April 11, 2015 - by Arsalan Khan - Leave a Comment

We have been recently migrating a lot of physical clusters to virtual. The quickest way to move sql agent jobs was to restore MSDB database. To validate if jobs were in order …

SQL Agent Job Error CMDEXEC subsystem failed to load Read More
SQL Server

SQL Server Job Performing Completion Actions Blocked: An Interesting case

March 10, 2015July 3, 2020 - by Manohar Punna - Leave a Comment

Hello, Recently we had an issue with chain blocking and most of the jobs are complete but do not finish. When observed in Job Activity Monitor most of the jobs say …

SQL Server Job Performing Completion Actions Blocked: An Interesting case Read More
SQL Server / SQL Server Accidental DBA Series

Get SQL Server Agent job details

December 12, 2014December 20, 2019 - by SQL Geek - Leave a Comment

A DBA must be aware of what all jobs are scheduled and there details. To get SQL Server Agent job details, msdb.dbo.sp_help_job system stored procedure comes in handy. 1. To get …

Get SQL Server Agent job details Read More
SQL Server

SQL Server Using Powershell to Move SQL Agent Jobs Across Instances

April 10, 2013December 23, 2019 - by SQL Geek - 3 Comments.

Migrating jobs from one server to other can be easily done with powershell. Let’s look into the script. At first, include reference to the relevant SMO assemblies and then create the …

SQL Server Using Powershell to Move SQL Agent Jobs Across Instances Read More
SQL Server

SQL Server Real-time Monitoring using WMI classes: Part -1

February 18, 2012September 19, 2014 - by Abhay Chaudhary - 28 Comments.

SQL Server Real-time Monitoring using WMI classes: Part -1 We all know that that SQL Server had a great face lift from SQL Server 2000 to 2005 .Everything else was a …

SQL Server Real-time Monitoring using WMI classes: Part -1 Read More

Subscribe to SQLServerGeeks


Ad

Virtual Symposium

master classes



SSG_linkedin

SSG_fb

About Us

  • Core Team
  • Authors
  • Blog With Us
  • Testimonials
  • Contact Us
  • Join DataPlatformGeeks Community

Virtual Symposium

Copyright © 2022 SQLServerGeeks. Community initiative by Amit Bansal | Anti-Harassment Policy
Powered by WordPress and HitMag.