Agent jobs

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)

2016-06-30 (first published: )

435 reads

Blogs

T-SQL Tuesday #121: Gifts received for this year

By

It’s T-SQL Tuesday time again! This edition is hosted by Malathi (blog|twitter) and the...

A gift. T-SQL Tuesday #121

By

My good friend Malathi Mahadevan (blog|twitter) is hosting T-SQL Tuesday this month and wants...

Distributing Jupyter Notebooks

By

If you’re working with the Microsoft Data Platform, you should be, at the least,...

Read the latest Blogs

Forums

T-SQL script to purge all the tables including foreign key references

By Brahmanand Shukla

Comments posted to this topic are about the item T-SQL script to purge all...

Performance difference

By tcroninlifepoint

I have a user sql from 3rd party started running terrible on prod server. ...

List of INDEX with create and DROP script should not include any constrains P/F

By DBA.k

Hello Sir.. Please help me the script.. From entire database i want List of...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers