Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Is it possible to make a backup of SQL scheduled tasks

Posted on 2010-08-18
3
217 Views
Last Modified: 2012-05-10
We recently had development SQL box go down, and ended up having to recreate the SQL scheduled tasks. Is it possible to export to query or make a backup of the SQL tasks that can be transferred to another SQL box?

Thanks in advance.
0
Comment
Question by:ROMAD77
3 Comments
 
LVL 3

Accepted Solution

by:
meagain35 earned 500 total points
ID: 33469470
You should have the following option through management studio.

This will give you the option of saving the task to a file/clipboard/etc... to backup the tasks you have defined.




sql-agent.jpg
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 33470925
If you are referring to the SQL Server Agent jobs, they are saved in the msdb database, so just ensure that database is getting backed up.
0
 
LVL 1

Expert Comment

by:Waynepi
ID: 33474055
You can use the MSDB but it will replace your users too.
1.I suggest you go to SQL server agent and highlight jobs.
2.On the menu list on top select View....Object Explorer Details.....Youll then see all the jobs.
3. Select all(Ctrl+A) and right click....Create script and run it on the new server.
0

Featured Post

Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question