Problem

Apply best practices to existing and newly created jobs

Solution

Native T-SQL

  1. Change job ownership to sa – Change job ownership to sa
  2. Add failed job notify operator (if missing) – Add failed job notify operator (if missing)
  3. Add 3 retries to Job 1st step – Add 3 retries to Job 1st step
  4. Add non-default job categories – Add non-default job categories
  5. Change job operator based job category – Change job operator based job category