Interview Questions

1. Sometimes there is no History available for the Failure or Success of a job? What could be the reason for the same?

By default SQL Server doesn’t hold a very long job history for your server. The defaults that SQL Server comes with are as follows:

That is the reason sometimes we are not able to get the job history details due to purging of the job history.

By Hena Parveen 2 0
Is this helpful? Yes No

Submit an interview question

Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.

Get Started

Comments

Leave a Comment


Check out more interview questions

Based on your skills

MS SQL Server

1661059 1720 23 859

Angular

42416 92 0 46

Wordpress

34292 72 1 36