Blog Archives

Index rebuild on large database – SQL Agent Powershell job

Index rebuild on a large database could take longer time. One of our customer was looking for a solution to rebuild index one by one  when index  fragmentation is greater than 30%.  Related  newsgroup thread: In this blog post, I have

Posted in DB Management, Powershell, SQL Agent, SQL Power shell, SQL Server

Emailing job output as a file attachment

One of our customer would like to email result of a SQL Agent job to email id. related thread. You can achieve this by enabling job step output to a file, add a new job step in current job that

Tagged with:
Posted in SQL Agent