Question: Where is SQL Jobs Stored?
Answer: In MSDB Database in dbo.sysjobs table.
This question was actually asked to me on my YouTube Channel. The user wanted to know in case if SQL Job was deleted accidentally where they can find it. The answer is the MSDB Database in dbo.sysjobs table.
I often tell my blog readers as well as clients of Comprehensive Database Performance Health Check that just like the backup of the user database is important the same way the backup of the system database is equally important. You never know when you need them and what kind of information they contain.
With that said you should never need to take a backup of the TempDB because that is recreated with every single restart of the system. As the matter of fact, you can use TempDB to know when was your SQL Server services restarted by looking at its date created.
Here are a few associated blog posts which you may find interesting about Jobs Stored.
- SQL SERVER – Details About SQL Jobs and Job Schedules
- SQL SERVER – Query to List All Jobs with Owners
- How to List All the SQL Server Jobs When Agent is Disabled?
- SQL SERVER – T-SQL Script to Check SQL Server Job History
- SQL SERVER – Displaying SQL Agent Jobs Running at a Specific Time
- How to Schedule a Job in SQL Server?
- Activity Monitor and Running Query – SQL in Sixty Seconds #115
- Email an Execution Plan – SQL in Sixty Seconds #114
- Execution Plan – Estimated vs Actual – SQL in Sixty Seconds #113
Reference: Pinal Dave (https://blog.sqlauthority.com)