Find the best tutors and institutes for SQL Server

Find Best SQL Server Training

Please select a Category.

Please select a Locality.

No matching category found.

No matching Locality found.

Outside India?

Search for topics

Troubleshooting SQL Server Agent failed Jobs - Common daily routine work for DBA

06/08/2018 0 0

If you are lazy and not intended to do repetitive manual work at a routine time, then SQL Server Agent job help you achieve this. SQL Server agent jobs help to automate the execution of the recurring task in the SQL Server database at a scheduled time. 

It is important that DBA should have a clear idea about how to troubleshoot when the job gets failed.

SQL Agent can automate the execution of multiple tasks in a single or by creating multiple jobs. Below are few things which SQL Agent job can handle or categorise. 

1. Execute TSQL Query

2. Execute Maintenace Plan (SSIS) 

3. SSIS Package 

4. Execute Powershell script.

5. Database Integrity check

6. Replication agent

7. Log-shipping


How DBA can help resolve or troubleshoot the failure of SQL Jobs?

  1. DBA should use Job activity
  2. Check for last run status 
  3. Find out the error resulting in failure. 


Some common reason for job failure

1. Insufficient Permission provided to the job owner.

2. Script error / Incorrect syntax /Object missing/ Source file missing

3. Primary foreign key relation error 

4. Deadlock/Blocking 

5. Insufficient space on the drive

6. Restricted growth of database (data, Log file)

7. Linked server permission issue

8. LSN mismatch in case of log shipping


If you are not able to find the error, you should add logging to the job which can be done in advance setting on job steps. Apart from the listed error, DBA should check the SQL Server Error log to find the RCA.

0 Dislike
Follow 2

Please Enter a comment


Other Lessons for You

What is DBMS and RDBMS
Database Management Systems A database is a collection of data or records. Database management systems are designed to work with data. A database management system (DBMS) is a software system that uses...

Amit Patil | 15 Apr

0 0

What's the best way to learn SQL Server?
Just read the book, type and run the code, and work the chapter examples. If you work the book, you will be ahead of many SQL Server programmers. You’ll understand declarative set-based interaction...

Cursors In SQL Server
First thing first Usage of Cursors is not encouraged in SQL Server as they are slow. You may go with While loop if you need to iterate through a recordset. Cursor is a database object to retrieve data...

Understanding Indexes In SQL Server
Indexes in SQL Server are created on columns in tables or views. The index provides a faster way to look up data based on the values in those columns.For example, if you create an index on the primary...

Essential SQL Tips For Developers And For MS SQL DBA
10 Essential SQL Tips for Developers: SQL is yet another essential language for developers wishing to create data-driven websites. However, many developers are unfamiliar with various aspects of SQL;...

Find Best SQL Server Training?

Find Now » is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on, to fulfill their learning requirements across 1,000+ categories. Using, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more