Job Summary

This proc will capture a snapshot of all the connections to your SQL Server at the time that it runs. Execute this as a job when an alert fires, and you'll have the user connection context for when something went wrong on your server. (Suggested job and alert creation are included in the script.) Two versions provided- one that includes the last command each connection ran, and one that doesn't.

SCRIPT: Job Summary

jQuery( document ).ready(function($) { // Handler for .ready() called. //alert("nav js added"); if(jQuery(window).width() <= 768){ /*jQuery( "#secondaryNav" ).insertAfter( "#primary_nav" );*/ jQuery('body').addClass('mobile-menu-design'); jQuery('#mobile_second_level_ul > li > ul.sub-menu > li > ul.sub-menu > li > ul.sub-menu ').addClass('custom-mobile-sub-menu'); jQuery('.mobile-menu-design .navbar.navbar-expand-md').find('#logo').addClass('main-logo-in-mobile'); jQuery('.mobile-menu-design .navbar.navbar-expand-md .main-logo-in-mobile + .ml-md-auto > div > ul li').addClass('search-icon'); jQuery('.mobile-menu-design .navbar.navbar-expand-md .main-logo-in-mobile + .ml-md-auto > div > ul li + li').addClass('cart-icon'); jQuery('.mobile-menu-design .navbar.navbar-expand-md .main-logo-in-mobile + .ml-md-auto > div > ul li + li').removeClass('search-icon'); } jQuery('#mobile_first_level_ul > li > a').click(function(e){ e.preventDefault(); /*console.log('parent-click-check');*/ var class_name = jQuery(this).parent('li').attr('class') menuItemSelector = class_name.substr( class_name.lastIndexOf(' ') + 1); /*console.log(menuItemSelector);*/ /*jQuery('#mobile_second_level_ul > li').css('display', 'none'); jQuery('#mobile_second_level_ul > li.'+menuItemSelector).css('display', 'block');*/ jQuery('#mobile_second_level_ul > li').addClass('hide_sub_menu'); jQuery('#mobile_second_level_ul > li.'+menuItemSelector).addClass('show_sub_menu'); /*console.log('#mobile_second_level_ul > li.'+ menuItemSelector);*/ jQuery('#mobile_second_level_ul > li.'+menuItemSelector).find('ul.sub-menu').slideToggle(); jQuery('#mobile_second_level_ul > li.'+menuItemSelector).find('ul.sub-menu.custom-mobile-sub-menu').css('display', 'none'); jQuery('#mobile_first_level_ul').css('display', 'none'); jQuery('.mobile-login-menu').css('display', 'none'); jQuery('.mobile-menu-header .menu-btn').css('display','none'); jQuery('.mobile-menu-header .back-menu-btn').css('display','inline-block'); }); jQuery('.mobile-menu-header .close-btn').click(function(event){ jQuery('.mobile-menu-header .menu-btn').css('display','inline-block'); jQuery('.mobile-menu-header .back-menu-btn').css('display','none'); }); jQuery('.mobile-menu-header .back-menu-btn,#mobile-menu-toggle').click(function(event){ jQuery('#mobile_first_level_ul').css('display', 'block'); jQuery('#mobile_second_level_ul > li').addClass('hide_sub_menu'); jQuery('#mobile_second_level_ul > li').removeClass('show_sub_menu'); jQuery('.mobile-login-menu').css('display', 'block'); jQuery('.mobile-menu-header .menu-btn').css('display','inline-block'); jQuery('.mobile-menu-header .back-menu-btn').css('display','none'); jQuery('#mobile_second_level_ul > li').find('ul.sub-menu').css('display', 'none'); }); jQuery('#mobile_second_level_ul > li > ul.sub-menu > li > ul.sub-menu > li > a').click( function(event) { /*alert('enter');*/ event.preventDefault(); /*console.log('Hello');*/ jQuery(this).parent('li').find('ul.sub-menu').slideToggle(); jQuery(this).parent('li').toggleClass('active'); }); });