Technical Article

Copy all jobs, job steps and job schedules

This vbscript will generate the sql to recreate all the jobs running on a given SQL server. I wrote this because the last time we migrated a SQL server, I ended up re-creating all the jobs, steps and schedules by hand using the Enterprise Manager. It was the slowest, dullest and most error-prone part of […]

You rated this post out of 5. Change rating

2003-04-17

776 reads

Blogs

FDD 2023 – Session Materials

By

You can find the slides for my session at Future Data Driven summit at...

Quick Filtering in SSMS–#SQLNewBlogger

By

I saw someone limit the databases they see in SSMS, which isn’t something I...

Penetration Testing your SQL Server, Part 1 – The Recon Mission

By

Since witnessing a rather nasty cyber attack around a year ago, I’ve been thinking...

Read the latest Blogs

Forums

Write https request to azure blobstorage

By Charmer

Hi All, I have been trying to download a csv file which is produced...

High tempdb usage alternatives

By anoop.mig29

Hi We have an stored procedure which runs frequently and  it contain logic in...

high latency in sql server transactional replication

By anoop.mig29

Hi I am new to replication and we have database of size around 2TB...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers