|
Welcome to SQLsmarts, Idera’s newsletter for SQL Server Professionals!
We welcome your questions, comments or suggestions. Tell us more about how you’re using any of Idera’s products and we’ll
send you a
free Idera “SQL Server Professional v2.0” t-shirt!
Email us: SQLsmartseditor@Idera.com.
|
In this issue:
Product News
Announcing new SQLschedule v2.0: Enterprise-class job management and monitoring for SQL Server environments
Case Study
Money Management International relies on SQLschedule to help manage complex job schedules and keep SQL Server running smoothly 24 x 7
Tips & Tricks
Rewrite a job's schedule in seconds using SQLschedule
Create advanced job alerting with SQLschedule
|
 |
| Product News |
|
Announcing new SQLschedule v2.0:
Enterprise-class job management and monitoring for SQL Server environments
Regardless of how large your SQL Server enterprise, or how complex your job schedules, Idera’s new SQLschedule v2.0 will simplify and streamline your SQL Server job scheduling and management. From a central, easy-to-use console, you’ll be able to view, schedule, and oversee all jobs across your entire SQL Server environment. SQLschedule will help you reduce job failure rates and improve performance while dramatically reducing administrative time and cost.
SQLschedule v 2.0 provides these key benefits: |
- Powerful, easy-to-use Microsoft Outlook-style Interface – Quickly analyze calendars and job schedules for multiple servers or databases. Get complete control of which servers, events or objects are displayed.
- Customized Event Views – Analyze job schedules by time, user, resource, servers, job type, event type, and more. Quickly find inefficient job schedules, level job schedules across resources, and optimize job planning. For example, find all jobs that utilize a specific enterprise resource throughout the environment (SAN device, NAS device, network segment.)
- Integration with Idera SQLsafe Backup and Recovery – Manage all SQLsafe backup jobs across the enterprise from a single view. Quickly identify conflicts, plan, schedule, and level all SQLsafe backup and recovery jobs across the enterprise.
- External Scheduler Support – Connect to non-SQL Server systems which utilize scheduled tasks or generate events. View all jobs from a central point of control. This includes Windows Task Scheduler, Reporting Services, and DTS.
- Advanced Task Chaining – Quickly and easily configure complex cross-server job chains and determine dependencies between events occurring on disparate systems. For example, run a SQL Server job whenever a Reporting Services event completes, and execute a Windows Task Scheduler task whenever the SQL Server job fails.
|
Learn more about SQLschedule v2.0 
Try it FREE for 30 days!
|
|
|
| Case Study |
|
Money Management International relies on SQLschedule to help manage complex job schedules and keep SQL Server running smoothly 24 x 7 |
“SQLschedule is an essential tool for managing our job workload,” said Don McGee at Money Management International, a non-profit financial management firm based in Houston, Texas. “We use the product to coordinate, monitor, and manage all SQL Server jobs - it gives us the full historical view of actual run times, as well as a projected view of anticipated run times. Also, using automated task chaining, we’re able to solve our complex job dependency issues. Not only is SQLschedule saving us hours of time, it has increased the efficiency of our SQL Server infrastructure.”
Read the case study
|
|
|
| Bryan’s Tips & Tricks |
|
SQLschedule tricks for SQL Server job management
Easily rewrite a job's schedule in seconds using SQLschedule
Quickly move jobs to new time slots, with just a few simple steps
Find out how
|
|
Create advanced job alerting with SQLschedule
It's easy to customize alerts to notify of failed jobs, perform an action on another server,
execute a SQL statement, and more!
Find out how
|
| Feedback |
|
We want to hear from you!
Have an interesting story about how Idera product(s) have helped you?
Want to share a product tip, trick or hint?
Have product suggestions or questions?
Your feedback helps us ensure that our solutions continue to best serve your SQL Server management and administration needs.
You may even find your input published here in future newsletters.
Send us your comments and suggestions to SQLsmartseditor@idera.com and we’ll send you a free
Idera “SQL Server Professional v2.0” t-shirt!
|
|
|
|
SQLschedule custom event view
SQLschedule advanced chaining interface
