Where does SQL Server Agent save jobs?

sql sql-server restore sql-server-agent
Std_Net picture Std_Net · Oct 8, 2012 · Viewed 22.8k times · Source

My server is down and I can only get the harddisk from it. I found my database and copied it but where I can find agent jobs? Where are they saved?

Answer

Pete Carter picture Pete Carter · Oct 8, 2012

Within the MSDB database, jobs are stored in a tables called dbo.sysjobs. This joins to a table called dbo.sysjobsteps that stores details of the individule steps. The schedules are stored in dbo.sysjobschedules and the History is stored in dbo.sysjobhistory.

MSDB will also contain other instance level objects such as alerts, operators and SSIS packages.

Related questions

Restore DB — Error RESTORE HEADERONLY is terminating abnormally.

I have taken backup of SQL Server 2008 DB on server, and download them to local environment. I am trying to restore that database and it is keep on giving me following error. An exception occurred while executing a Transact-SQL statement …

Read More
How can I retrieve the logical file name of the database from backup file

I was looking into the steps of how to Restore Database Backup using SQL Script (T-SQL). Here are the steps: Database YourDB has full backup YourBackUpFile.bak. It can be restored using following two steps: Step 1: Retrieve the logical file …

Read More
How do you backup and restore a database as a copy on the same server?

I have a SQL2005 Express database that I would like to create a copy of on the same instance. How do you go about doing this with a script? I already have a script for generating the backup, but the …

Read More