Tag: jobs

Pro Members SQL Server Standard Members

Some tips to work with SQL Server 2016 alerts

by

Some tips to work with SQL Server 2016 alerts SQL Server 2016 writes the events into the Windows Application log. SQL Server Agent checks the Windows application log for SQL Server events. When an event occurs, the SQL Server Agent checks if the appropriate alert exists and if so perform the defined response. Alerts can be used to execute a...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
SQL Server

Tips for using jobs in SQL Server 2016

by

Tips for using jobs in SQL Server 2016 Run the scheduled jobs during periods of low database access. To reduce the total SQL Server overhead, try to schedule SQL Server 2016 jobs during CPU idle time and slow production periods. For example, you can schedule the job to run every night at midnight. Specify the understandable job name. Try to […]

Continue Reading →
Pro Members SQL Server Standard Members

Intelligent error alerting to reduce On-call hours

by

Intelligent error alerting to reduce On-call hours: The purpose of this article is to get you some much needed sleep! Yes, you heard me! So try to stay awake for this! I intend to introduce you to a few tried and true strategies to improve error and issue resolution and ultimately get you and your teammates a good night’s sleep....

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Tips for using jobs in SQL Server 2012

by

Tips for using jobs in SQL Server 2012 Specify the understandable job name. Try to specify the job’s name so, that the name describes what the job makes. By using so, you can simplify jobs administering and monitoring. Try to separate very large job into several small jobs. This can improve performance, and can be useful to maintenance the jobs...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →