DBA and DataScience

  • SQL Server
    • SQL Backup Recovery
    • SQL Security
    • SQL Performance
  • DataScience
    • Python
  • About Me

Start from failed job step

SQL Server

SQL Job resume automatically after server restart

As the title says, this script looks for any failed or cancelled jobs and will restart them from the failed step automatically. This type of script is useful in below scenario: You have a job with multiple steps which runs overnight and is required to be completed before start of Read more…

By harimindi, 11 months11 months ago
Categories
  • DataScience (10)
  • Python (5)
  • SQL Backup Recovery (1)
  • SQL Performance (9)
  • SQL Security (4)
  • SQL Server (17)
  • TSQL (2)
Recent Posts
  • SQL Job resume automatically after server restart
  • Linked Server Double-Hop Issues with SQL Server
  • Calculate date difference of 2 consecutive rows of a column – TSQL
  • Verify TLS 1.2 Connections from SQL Server
  • SQL VDI Errors
Contact Email:
  • harikumar.mindi@gmail.com
  • About Me
  • Contact Me
  • Data Science
  • Posts
  • Python Scripts
  • Scripts
  • SQL Server
Hestia | Developed by ThemeIsle