When any critical error / warning is reported by SQL Server Agent, it is written to a log file MSSQL\Log\SQLAgent.out. By default only critical errors and warnings are reported to this log file. If you would like to see additional information messages...

The goal of this post is to show how you can create a schedule and attach an existing job to that schedule. Create a schedule on an existing job (or create a job as described in a number of previous posts). 1) Open SQL Server Manament Studio (SSMS...

Email is so popular now. Do you also want to send emails from database applications by using T-SQL statements? Do you want to send a result of T-SQL queries directly to some one else? If you do, Database Mail is the solution to fulfill your needs. This...

If you interested to know more about SQL Agent /DB Mail/ Data Collector or you have a specific questions in regards of your own scenarios or just generic how to questions. Please do not hesitate to ask, leave your question under this blog entry and we...

I will explain how to add another step to existing job and configure it correctly. Let's assume that you already have a job with 1 step (for example as in Sethu's backup job example ) 1. Open SSMS (SQL Server Management Studio, make sure that SQL...

SQL Server Management Studio can be used to create a database backup job to backup an user database. Here are the steps and User interface workflow to create a simple backup job, run the job and view results 1) Create a demo database and insert sample...