Tag Archives: job

Find and update the owner of SQL Job, Maintenance Plan

When we update Maintenance plan, ownership of the job will be changed back to plan owner (In my case it was inactive account resulting job failure). This is a known bug in SQL Server 2005 and SQL Server 2008. (Ref: … Continue reading

Posted in Productivity, Script, SQL, SQL Query | Tagged , , , , , | Leave a comment

A required privilege is not held by the client. The step failed. – SQL Job Fails with error – Solution

I was aware of the best practice to use SQL Server Configuration Manager instead of using MMC Console but faced this error for not following the best practice. Well, I had to change the Logon account of my SQL Server … Continue reading

Posted in SQL, SQL Error, Windows Server | Tagged , , , | Leave a comment

Long running job monitor – Alert

I have created this script which will monitor long running jobs and alerts the analyst. One advantage of this custom script is to find threshold dynamically using job history! – Vijred

Posted in Productivity, Script, SQL, SQL Query | Tagged , , , , , , | Leave a comment