Intelligently Monitor SQL Server Agent

SQL Server provides limited monitoring capabilities for SQL Agent jobs in SQL Server Management Studio (SSMS). You have the Job Activity Monitor and View History for a job, while these items provide useful information, you need more.

In this webinar, learn how to use and query the system tables in the msdb database to retrieve the data you need to support your own customized SQL Agent monitoring solution.

In this session I will demonstrate:

• Calculating average job step and job duration based on job history
• Sending notifications for jobs that are running longer than normal
• Predicting when a currently running job step and job will complete based on job history
• Using a Power BI report to view this information on demand
• and more.

Webcast Date

Wednesday, March 24, 2021
3:00:00 PM EDT (New York) | 7:00:00 PM UTC

Speaker(s)

Sponsored by

Register for this webinar:

First Name*

Last Name*

Business Email*

Organization*

Org Address*

Org City*

Org State

Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware District of Columbia Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming Puerto Rico Virgin Islands Guam Alberta British Columbia Manitoba New Brunswick Newfoundland Northwest Territories Nova Scotia Nunavut Ontario Prince Edward Island Quebec Saskatchewan Yukon Other

Org Postal Code*

Org Country*

United States Canada Albania Algeria American Samoa Andorra Angola Anguilla Antarctica Antigua and Barbuda Argentina Armenia Aruba Australia Austria Azerbaijan Bahamas Bahrain Bangladesh Barbados Belarus Belgium Belize Benin Bermuda Bhutan Bolivia Bosnia-Herzegowina Botswana Bouvet Island Brazil Brunei Darussalam Bulgaria Burkina Faso Burundi Cambodia Cameroon Cape Verde Cayman Islands Chad Chile China Christmas Island Colombia Comoros Congo (Democratic Republic) Congo Cook Islands Costa Rica Cote d'Ivoire Croatia Cyprus Czech Republic Denmark Djibouti Dominica Dominican Republic East Timor Ecuador Egypt El Salvador Equatorial Guinea Eritrea Estonia Ethiopia Falkland Islands Faroe Islands Fiji Finland France French Guiana French Polynesia Gabon Gambia Georgia Germany Ghana Gibraltar Greece Greenland Grenada Guadeloupe Guatemala Guinea Guinea-Bissau Guyana Haiti Honduras Hong Kong Hungary Iceland India Indonesia Iran Ireland Israel Italy Jamaica Japan Jordan Kazakhstan Kenya Kiribati Kuwait Kyrgyzstan Laos Latvia Lebanon Lesotho Liberia Liechtenstein Lithuania Luxembourg Macau Macedonia Madagascar Malawi Malaysia Maldives Mali Malta Marshall Islands Martinique Mauritania Mauritius Mayotte Mexico Micronesia Moldova, Republic of Monaco Mongolia Montenegro Montserrat Morocco Mozambique Myanmar Namibia Nauru Nepal Netherlands Netherlands Antilles New Caledonia New Zealand Nicaragua Niger Nigeria Niue Norfolk Island North Korea Norway Oman Pakistan Palau Panama Papua New Guinea Paraguay Peru Philippines Pitcairn Poland Portugal Qatar Reunion Romania Russian Federation Rwanda Saint Kitts and Nevis Saint Lucia Samoa (Independent) Sao Tome and Principe Saudi Arabia Senegal Serbia Seychelles Sierra Leone Singapore Slovakia Slovenia Solomon Islands Somalia South Africa South Korea Spain Sri Lanka St. Helena Suriname Swaziland Sweden Switzerland Taiwan Tajikistan Tanzania Thailand Togo Tokelau Tonga Trinidad and Tobago Tunisia Turkey Turkmenistan Tuvalu Uganda Ukraine United Arab Emirates United Kingdom Uruguay Uzbekistan Vanuatu Vatican City Venezuela Viet Nam Western Sahara Yemen Zambia Zimbabwe Other

Org Phone*

Industry*

Accounting Advertising/Marketing/PR Aerospace & Defense Agriculture Apparel Associations Automotive Banking & Securities Biotech Call Center Outsourcing Construction Consulting Consumer Goods & Services Education Energy, Chemical, Utilities Financial Services - Other Food & Beverage Furniture Government - Federal Government - State & Local High Tech - Hardware High Tech - ISP High Tech - Other Home & Garden Hospital, Clinic, Doctor Office Hospitality, Travel, Tourism Insurance Legal Manufacturing Medical, Pharma, Biotech Mining Other Pharmaceuticals Printing & Publishing Real Estate Recreation Retail Software - Finance Software - Healthcare Software - Other Support Outsourcing Telecommunications Textiles Transportation & Distribution VAR/Systems Integrator

Job Title*

Application Developer Back up Administrator C- Level (CEO, CFO, CIO, CMO, CSO, CTO Data Analyst Database Administrator DBA Manager Developer eCommerce/eBusiness Manager Exchange/Mail Administrator Help Desk Staff/Manager Infrastructure Architect/Manager IT Applications Manager IT Architect IT Consultant IT Director/VP IT Manager IT Security Director Java Developer Network Administrator Network Manager Non IT Director/VP Other Partner Project Manager Security Officer Software Engineer Student System Administrator Systems Analyst/Architect Systems Engineer Virtualization Administrator

# of SQL Servers*

Organization Size*

1-99 1-99 100-499 500-999 1,000-1,999 2,000-4,999 5,000-9,999 10,000-19,999 20,000+

SMS reminder

carrier: AT&T Sprint T-Mobile US Cellular Verizon number: (5551234567)

Save My Details

Register me for these webinars too:

 

Building a Proper SQL Server Database Security Model
Tuesday, March 09, 2021 - 3:00:00 PM EST
Speaker(s): K. Brian Kelley - Sponsor: MSSQLTips

 

3 Ways to move databases to the cloud and back, which way is best for you?
Thursday, March 11, 2021 - 12:00:00 PM EST
Speaker(s): Denny Cherry, Argenis Fernandez and Robert Quimbey - Sponsor: Pure Storage

 

How To Disaster-Proof SQL Server
Thursday, March 18, 2021 - 1:00:00 PM EST
Speaker(s): Edwin Sarmiento - Sponsor: SIOS

 

Configuring SQL Server for Best Performance
Tuesday, March 30, 2021 - 1:00:00 PM EST
Speaker(s): Andy Warren - Sponsor: Quest

 

Development Best Practices for SQL Server
Tuesday, April 13, 2021 - 3:00:00 PM EST
Speaker(s): Andy Warren - Sponsor: MSSQLTips

 

Indexing for Performance: Query Strategies to Maximize Your SQL Server Indexes
Tuesday, April 27, 2021 - 1:00:00 PM EST
Speaker(s): Kevin Kline and Thomas LaRock - Sponsor: Confio

Signup for our newsletter

I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.