Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

How to backup SQL Server Agent jobs?

Tags:

sql-server

sql-server-2005

backup

ssis

sql-server-agent

How can I backup and restore SQL Server 2005 Agent job schedules?

like image 839
Firas Assaad Avatar asked Jul 07 '09 18:07

Firas Assaad

2 Answers

the msdb database is where all the jobs live, it is one of the system databases

like image 187
SQLMenace Avatar answered Oct 20 '22 12:10

SQLMenace

You can also script all the jobs out as a sql file and store them in svn or other source control if you'd like to track changes.

like image 41
sam yi Avatar answered Oct 20 '22 12:10

sam yi
Sign in to Comment

Related questions

best way to catch database constraint errors
SQl: Update Table from a text File
SQL Server drop and recreate indexes of a table
Hiding menu in SRSS
there is a process running select statement on tempdb database?
How to connect to sql server database via LAN
DataAdapter: Update unable to find TableMapping['Table'] or DataTable 'Table'
How to generate sql scripts using SMO scripter
Delete statements locks table
TSQL: NOCHECK Foreign Key inside CREATE TABLE
What's different between INTERSECT and JOIN?
ALTER ROLE to drop all members
Data migration from MS SQL to PostgreSQL using SQLAlchemy
Converting rows to XML format in SQL Server
Get Value From Json object contain table column using SQL Query
Alternative for String_split in SQL Server
1:1 Foreign Key Constraints
Tracking changes in a SQL server 2005 database
Large Text and Images In SQL
Using both a GUID and an auto-incrementing integer

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!