How to backup SQL Server Agent jobs?

sql-server sql-server-2005 ssis backup sql-server-agent
Firas Assaad picture Firas Assaad · Jul 7, 2009 · Viewed 16.7k times · Source

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

Answer

SQLMenace picture SQLMenace · Jul 7, 2009

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

Related questions

SSIS Connection Manager Not Storing SQL Password

I used to have a dts that had a sql server authentication connection. Basically, the userid password is stored in the package itself. Now, when I go to SSIS, the password is not getting stored to the package. I saw …

Read More
How do you call a Stored Procedure in SSIS?

I am trying to create an SSIS package that queries data from a table, and calls a stored procedure in another database with each row. In my old DTS package, I was doing this: EXEC myStoredProcedure ?, ?, ? ...and then I mapped …

Read More
SSIS: Just started getting a "Key not valid for use in specified state." error on my scheduled SSIS package

I have 2 scheduled jobs on my SQL Server 2005 machine that are scheduled to run each morning (around 2:00 AM). These jobs have worked fine (mostly) for years and although I've had a few hiccups that I've had to work through this …

Read More