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

3,497 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: )

869 reads

Blogs

Creating a new User-Defined Data Type–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

A new chapter begins

By

In 2012 when I originally founded Born SQL, I never imagined I would find...

Daily Coping 19 Jan 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Recursive Triggers

By Ken at work

I know there is, somewhere, T-SQL that will allow me to update (keep in...

How to get cummulative sum per column?

By Barendrecht82

Hi, I have a statement per period. I want the periods to be cumulate. ...

Secondary Filegroup

By jayoub

Hi, I have a quick question If I have a database with a primary...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers