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 […]

You rated this post out of 5. Change rating

2021-02-02

395 reads

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)

You rated this post out of 5. Change rating

2021-02-02

5,017 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)

You rated this post out of 5. Change rating

2019-05-03 (first published: )

1,278 reads

Blogs

Speaking at SQL Saturday Boston 2023

By

I’m heading to Boston next week for SQL Saturday Boston 2023. I went to...

SQL Prompt Quick Access to Helper Code

By

We’ve been doing some events as part of the Redgate Roadshow, and at one...

Eleven chapters of my data architecture book are available

By

As I have mentioned in prior blog posts, I have been writing a data...

Read the latest Blogs

Forums

Best Sildenafil Is The Fildena 100mg For Male Protection

By Eliadavised

Fildena 100 mg is used to deal with sexual issues. This medication is taken...

Building Bonds with Entertainment

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Building Bonds with Entertainment

Closing a Symmetric Key

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Closing a Symmetric Key

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers