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

772 reads

Blogs

Tales From The Field Weekly Wrap Up for the Week of 05-22-2023 Microsoft Fabric Launch & Moving Home Offices

By

 Hello Dear Reader!  Sorry this is so late, moving houses has gotten me a...

Microsoft Announcement: Microsoft Fabric

By

Yesterday at Microsoft Build, a significant announcement took place—the introduction of Microsoft Fabric, which...

Introduction to SQL Server Query Store

By

Introduced with SQL 2016, Query Store was, probably without doubt, the most anticipated and...

Read the latest Blogs

Forums

You have an error in your SQL syntax; check the manual that corresponds

By yrstruly

I am having great trouble creating a data pipeline using MariaDB connector 3 with...

Availability Group database went into 'Restoring' state

By Arsh

Dear Friends, Please advise why would one of my Availability Group databases go into...

Access db

By sqlguru

Access db wanting to move  sql server, how much control does business have over...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers