Calendar View

The Calendar View is the default display in the Workspace Area. It combines both historical and future event data to present an accurate visual representation of the schedule. Visual indicators highlight overlapping active event instances, event status, and duration. Additional detail information is available with a single click via popup windows. You can use drag-and-drop to reschedule future jobs or tasks in order to "level” a schedule, thus minimizing contention between multiple events fighting for the same resources.

 

 

To navigate to the Calendar View, double-click on any root, group, connection, source, object "Event View", or Custom Event View node in the Navigator Pane. The actual event instances displayed on the view will vary depending on the node selected. For example if you select the Jobs node under a SQL Server, only jobs will be displayed; all other events (DTS packages, maintenance plans, etc.) will be filtered from the view, and only the Jobs tab will be available in the corresponding Event View filter.

 

Recurring Events Pane

This pane is used to display events that run frequently or long enough that they would clutter the calendar in the current interval view. Exactly which events are displayed in the recurring events pane depends on the active interval and the schedule frequency of the respective events. For example, future instances of a job that runs every 5 minutes will be pinned to the recurring events view when in a 24 hour interval, but will be displayed on the calendar in 1 hour view. To determine how long events must run before showing in this window, go to the Calendar tab in the User Preferences menu.

 

NOTE: Events listed in the recurring pane will not register as conflicts with other events on the Calendar.

 

Calendar Context Menus

A Context Menu is available for all event instances by right-clicking the instance in the calendar. Exactly which context items are available depend on the source type of the selected instance. 

 

Navigation Control

The navigation toggle button at the top left of the calendar allows you to move quickly forwards and backwards through the calendar.

 

Click the Up ▲ or Down ▼ Arrows to move to the previous or next time interval . The Right ► or Left ◄ Arrows move forward or backward one day, keeping the same interval and start time. The Plus + and Minus - buttons are used to zoom in or out in the Time Ruler, one interval at a time, keeping the interval start time the same.

 

Date Bar

This bar shows the day of the week and date for each day displayed in the current view.

 

When in a multi-day view, if you single-click any date on the date bar it will make that date active, highlighting the date. You can zoom into a single date by double-clicking the date on the date bar. You can drill into any interval for one or more days by double-clicking on the Time Ruler at the left of the calendar (see below).

 

Time Ruler

On the left side of the calendar, a vertical Time Ruler shows the current time-range for the selected interval. By default, Hours are displayed. You can use the Time Ruler to zoom in or out to a desired time interval display.

 

When you hover over the Time Ruler, the ruler highlights a time-range. Double-click to zoom into the time-range. This is similar to clicking the Zoom In button, except that the Zoom In button does not change the start time.

 

Current Time

The current time is displayed (when in view) with a horizontal red bar. The bar will move as the time changes.

 

Current Time Column

To see the exact time, mouse-over the narrow column between the time ruler and the calendar or between adjacent days.

 

zoom in/out

You can also use the calendar to zoom in or out to any time intervals. Right-click anywhere there is empty space on the calendar or on the Time Ruler to bring up the context menu. Select a time interval to zoom in and out.   

 

interval buttons 

Hover over the very top or bottom of the time ruler and popup arrows are displayed which you can use to quickly move to the previous or the next interval, just as with the Up ▲ or Down ▼ navigation control arrows.

 

Event Instances on the Calendar

All event instances on the calendar appear with a rectangular block. Future instances don't include a Run Status indicator bar.

 

 

 

Step Details are accessible by clicking the bottom-right corner of the event instance.  By default an event instance background is white.

 

Default Run Status colors are:

• Green - Successful
• Yellow - Warning
• Red - Failed
• Orange - Running
• Black - Stopped

 

Glyphs

Glyphs are used to provide quick visual cues about event instances on the calendar, including their event source type, queuing settings and status, block status, etc. Each instance contains at least one glyph representative of its type, which matches exactly the icon shown in the navigator pane for the source object. Below is a calendar showing several different types of event instances. See the Navigator Pane Map for a complete listing of all event instance glyphs.

 

Other informational glyphs are listed below:

 

	Job actively blocked or blocking
	Job actively being queued
	Job cannot be queued
	Job set to queue
	Job actively queuing
	Event instance or event object contains a note
	Event instance was run as part of an event chain
	Top SQL indicator
	Analysis Services Top Commands indicator
	Deadlock indicator
	SharePoint Timer Job indicator

 

Popup Windows

To view details for any event instance, left-click it anywhere to the right of the duration bar to select it and bring up a popup window. The popup reveals details about the instance, including the last step output, start and end time, duration, runtime statistics, schedules, queuing settings, notes, etc. The actual data contained in the popup will vary based upon the instances event source type. You can clear the window by moving your mouse away from the instance.  

 

HighLighting Related Events

The calendar provides several options for grouping events on the calendar. Right-clicking an event and selecting "Highlight" will display the applicable highlighting options for the event.  Once the highlight option(s) are chosen, similar events to the one selected will be highlighted on the calendar.

 

Event Conflicts

A conflict is defined as two active event instances running on the same server at the same time. When a instance"s runtime (as indicated by the duration bar) overlaps with one or more other instances in the same view, it is considered conflicting and its background color will be orange as shown below, otherwise the background will be white.

 

You can easily resolve most conflicts by dragging-and-dropping future instances on the calendar. The amount of time instances must overlap before showing as in conflict can be adjusted in User Preferences.

 

NOTE: Events listed in the recurring window will not register as conflicts with other events on the Calendar.

 

 

Too Much Data Indicators

On very busy schedules, if too many event instances exist within a given range to display all of them in a meaningful fashion, a small hashed box will be shown on the right side of the pane. Hovering over the box will show a tooltip with the number of additional events in that time period. Double-clicking the box will zoom in so each actual event can be seen. If conflicts exist within the specified range, the box will be displayed in orange (default). A filter can also be applied to reduce the number of event instances on the calendar.

 

Selecting an Event Instance

Click to select any event instance on the calendar and it will be displayed with a blue border on the top and bottom. Note that all other instances of the same object on the calendar will change background color at the same time for easy reference. 

 

Rescheduling via Drag-and-Drop

After you select a future job or task instance, you can easily move it to a different time slot by dragging-and-dropping the instance. After you move an instance, you will receive a confirmation dialog box. Either click OK to confirm the move or Cancel to return the instance to its original position.

 

NOTE: This feature is disabled in the evaluation version of SQL Sentry.

 

Viewing Step Details

To view full step details for an event instance, click the small gray triangle in the lower-right corner of the instance and the step callout window will appear. You can move the window by clicking the gray bar at the top, and you can resize it by clicking the small dashed triangle in the lower-right corner. Note that event instances that don't contain steps, such as status events or Windows tasks, will not have a step callout button.