Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have set 'job' for re-indexing, I want to know when the last re-indexing happened in datetime.

share

migration rejected from stackoverflow.com Aug 6 '13 at 10:33

This question came from our site for professional and enthusiast programmers. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as unclear what you're asking by Mark Storey-Smith, RolandoMySQLDBA, Kin, Mat, dezso Aug 6 '13 at 10:33

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question.If this question can be reworded to fit the rules in the help center, please edit the question.

2  
view history..... –  Mitch Wheat Feb 6 '13 at 6:55
    
What's defined as re-indexing: rebuild, reorganize, both? What situation fits best your question: a) Inside the job (when running it) you want to know when was the last re-index operation for a table OR b) The job has been executed some time last night and you want to know when it was completed? –  Marian Feb 6 '13 at 9:49
    
My question: why do you care? An index on a table with no writes that was "re-indexed" three years ago will still be unfragmented. Conversely, an index that encounters a lot of page splits in a short period of time could be heavily fragmented in five minutes. –  Ben Thul Feb 6 '13 at 13:09
    
@Ben, Lots of reasons why this info might be interesting. If a fragmented index is reindexed nightly, maybe it's time to re-evaluate fill factor or index strategy. But I suspect the question asker wants to know about whether a job ran or not rather than table by table history. –  Michael J Swart May 8 '13 at 13:01
    
@MichaelJSwart: The question was more rhetorical than anything. The answers you gave are good ones! But answering a question without knowing the why is often providing disservice to the asker. –  Ben Thul May 8 '13 at 13:25