SQL Server Event Calendar

Manage SQL Server and Windows events in a visual calendar

Descargar prueba gratis Enviar enlace a prueba en email

Funcional durante 14 días

Más información

Manage Scheduled Events

Outlook-Style Calendar

Filter Events

Track Job Runtime

Set Proactive Notifications

Easily stay on top of scheduled events

Efficiently managing SQL Server and Windows jobs and tasks isn’t easy, but SolarWinds^® SQL Sentry’s Event Calendar was designed to take some of the pressure off your shoulders. The SQL Server Event Calendar keeps track of jobs, tasks, and other events and presents everything in an easy-to-understand visual format. Plus, it comes with an advanced filtering system, making identifying and addressing potential event conflicts simple.

Descargar prueba gratis Enviar enlace a prueba en email

Funcional durante 14 días

Más información

View and manage your database environment events in a single calendar

Event Calendar is a centralized event log management capability designed to visually display events across monitored SQL Server instances and help you automate workflows to proactively improve performance.

Event Calendar shows Windows and SQL Server events in a familiar, Outlook-style calendar, where you can do the following:

View historical and future event data
Drag and drop future events to reschedule them
View event failures and potential conflicts capable of leading to resource contention on the server
Drill down on specific tasks and events and view their history in the SQL Sentry Performance Analysis Dashboard

Descargar prueba gratis Enviar enlace a prueba en email

Funcional durante 14 días

Más información

Apply filters to find essential information faster

The default SQL Server Event Calendar view can be overwhelming when managing multiple SQL Server jobs, but filtering SQL events with SQL Sentry to find exactly what you’re looking for is simple.

First, you can apply duration filters. Then, you can further simplify your view by deselecting event types you aren’t interested in, leaving critical SQL event types like Deadlocks, Blocking SQL, Top SQL, or SQL Server Agent Jobs selected. With SQL Sentry, finding the information you need is effortless!

Descargar prueba gratis Enviar enlace a prueba en email

Funcional durante 14 días

Más información

Track job runtime

With Event Calendar, you can track the runtime for monitored SQL Server agent jobs. You can compare runtimes for different server instances—for example, when a job will run after a cluster failover. You can also set up Event Chains, which consist of a series of SQL Server Agent jobs or Windows-scheduled tasks running on the same server or different servers. With Event Chains, you can automate a series of events needing to follow a specific sequence.

Descargar prueba gratis Enviar enlace a prueba en email

Funcional durante 14 días

Más información

Stay up to date with notifications

Keeping up with all your events and jobs in SQL Server isn’t simple, but the Event Calendar can help. Instead of manually checking in, you can use Advisory Conditions. You’ll receive automatic notifications for any tasks and jobs you’re monitoring, meaning you’ll know when failures occur or database server runtime thresholds have been met.

Descargar prueba gratis Enviar enlace a prueba en email

Funcional durante 14 días

Más información

Get More on SQL Sentry Event Calendar

Do you find yourself asking…

What is SQL Sentry Event Calendar?
What can you do with the SQL Sentry Event Calendar?
How do I keep track of all my jobs in SQL Server?
Is it possible to see a multi-day comparison in the Event Calendar?
Does the Event Calendar support SQL Agent Jobs in RDS for SQL Server databases?
Is it possible to create custom event views in SQL Sentry?

SQL Sentry^® Event Calendar is a capability designed to combine historical and future SQL Server and Windows event data in a visual, Outlook-style display. With the Event Calendar, you can identify and fix potential conflicts between multiple events—such as SQL Server jobs or Windows scheduled tasks—competing for the same resources, which can slow database performance.

Yes, you can create custom event views in SQL Sentry—and you won’t need to recreate these views every time you want to view SQL events.

If you want to create a new view, you’ll need to double-click the local or shared node. Or, you can right-click and select New. This will open the Add a Custom Event View tab regardless of your chosen method. Here, you can name your view and add a description to make differentiating your various views easier in the future.

Next, you can define everything included in your view in the Define View section. Options include:

Select Instances: This button will allow you to select the event sources you want to include in your view. SQL Sentry will allow you to choose individual Microsoft SQL Server instances, specific Azure SQL Database connections, or all instances of a specific type. Once you’ve made your selection, click OK to ensure your changes are saved.
Select Objects: You can add individual object types to your view by filling out the Select Objects section. The top portion will enable you to search for objects by name, type, or even specific text within a job step (like a specific event name). After entering information into the search fields and hitting the Search button, SQL Sentry will populate the Search Results area. You can review the results, select the objects you’d like to add to your view, and hit Add. These objects will now appear in the Selected Objects portion of the window.
Event Sources: You can also tie real-time event sources to your view, such as deadlock events, blocking processes, Advisory Conditions, and SQL Server Agent Jobs. This is crucial for performance optimization, as you can even filter for specific T-SQL batches or deadlocks. With certain event sources, you’ll also be able to choose specific objects or categories.
Filtering Options: After selecting the instances, objects, and event sources to include in your view, hit Set Filters. This powerful UI saves you from having to write complex T-SQL queries using functions like DATEADD or joining to a custom calendar table just to isolate events for a specific weekday or time range. Then hit OK to apply your filters to the view and Save to make sure SQL Sentry saves your custom view.

You can also create a custom event view by simply saving your current calendar view. All you have to do is click File and Save View As. Then, you can name your view and add a description.

To find custom event views you’ve already created, go to the Navigator pane and look under the Event Calendars object. Then, you can expand the Event Calendars object to access calendars that are split between local and shared nodes.

You can also organize your custom views into folders to make locating them easier in the future. You should right-click the local or shared node under the Event Calendars object. Then, hit New Folder and drag views into your folder to add them.

SQL Sentry^® Event Calendar is a capability designed to combine historical and future SQL Server and Windows event data in a visual, Outlook-style display. With the Event Calendar, you can identify and fix potential conflicts between multiple events—such as SQL Server jobs or Windows scheduled tasks—competing for the same resources, which can slow database performance.
Manage SQL Server and Windows events with a centralized, graphical Outlook-style Event Calendar
View historical and future event data
Automatically reschedule future SQL Server tasks
View contention issues in a graphical format
Drill down on events and troubleshoot them within the SQL Sentry Performance Analysis Dashboard
Filter the events display on your calendar by events for a particular server
Filter events by event type (deadlocks, for example) or event source
Use the Event Calendar for SQL Server Agent Job, Alert, and Log events; Windows tasks and Event Log events; and SQL Server Reporting Services (SSRS) events
Yes, you can create custom event views in SQL Sentry—and you won’t need to recreate these views every time you want to view SQL events.
If you want to create a new view, you’ll need to double-click the local or shared node. Or, you can right-click and select New. This will open the Add a Custom Event View tab regardless of your chosen method. Here, you can name your view and add a description to make differentiating your various views easier in the future.
Next, you can define everything included in your view in the Define View section. Options include:
Select Instances: This button will allow you to select the event sources you want to include in your view. SQL Sentry will allow you to choose individual Microsoft SQL Server instances, specific Azure SQL Database connections, or all instances of a specific type. Once you’ve made your selection, click OK to ensure your changes are saved.
Select Objects: You can add individual object types to your view by filling out the Select Objects section. The top portion will enable you to search for objects by name, type, or even specific text within a job step (like a specific event name). After entering information into the search fields and hitting the Search button, SQL Sentry will populate the Search Results area. You can review the results, select the objects you’d like to add to your view, and hit Add. These objects will now appear in the Selected Objects portion of the window.
Event Sources: You can also tie real-time event sources to your view, such as deadlock events, blocking processes, Advisory Conditions, and SQL Server Agent Jobs. This is crucial for performance optimization, as you can even filter for specific T-SQL batches or deadlocks. With certain event sources, you’ll also be able to choose specific objects or categories.
Filtering Options: After selecting the instances, objects, and event sources to include in your view, hit Set Filters. This powerful UI saves you from having to write complex T-SQL queries using functions like DATEADD or joining to a custom calendar table just to isolate events for a specific weekday or time range. Then hit OK to apply your filters to the view and Save to make sure SQL Sentry saves your custom view.
You can also create a custom event view by simply saving your current calendar view. All you have to do is click File and Save View As. Then, you can name your view and add a description.
To find custom event views you’ve already created, go to the Navigator pane and look under the Event Calendars object. Then, you can expand the Event Calendars object to access calendars that are split between local and shared nodes.
You can also organize your custom views into folders to make locating them easier in the future. You should right-click the local or shared node under the Event Calendars object. Then, hit New Folder and drag views into your folder to add them.

“The SQL Sentry Event Calendar helps us to discover the overlapping jobs; we were able to ‘chain them,’ and nowadays, it is very easy to schedule a job.”

Leonardo Velez

Database Administrator

Portima