Agent jobs

SQLServerCentral Article

How to Restore an Agent Job that was Dropped

  • Article

Once upon a time, you had one job, well actually two jobs. The first SQL Server agent job was important, the other was a test. You have decided you do not need the test agent job. Quick right-click on a job name, remove, confirm, done. When you refreshed the list, the test job was still […]

5 (5)

2021-02-02

4,426 reads

Technical Article

Job Step Log Output file path

  • Script

If you have a requirement to carefully have the output file against each sql agent job step, you can use this script. If incase, there are many sql agent jobs and by any reason if any of the step does not have proper o/p file, this script can automatically create the o/p file.

4 (4)

2019-05-03 (first published: )

1,166 reads

Blogs

Truncating very large transaction log in full recovery mode

By

While I always configure transaction log backups for every database in non-simple recovery model,...

Autonomous Driving Around London

By

There’s a video of Bill Gates taking a drive in an autonomous car around...

Best way to monitor high worker thread on SQL Server

By

It is common to see high worker count issue on the production server and...

Read the latest Blogs

Forums

Significance of Historical waits report in SQL server Performance dashboard

By IT researcher

I have the following historical wait report for my SQL server. I have noticed...

Has SQL Server Performance Improved?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Has SQL Server Performance Improved?

Is TemporalTable SysStartTime available before performing an insert/Update?

By Dwaine Wright

I want to align a Date column (datetime2(7)) with the same full resolution date...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers