Where are SQL Jobs Stored? – Interview Question of the Week #293

Question: Where is SQL Jobs Stored?

Answer: In MSDB Database in dbo.sysjobs table.

Where are SQL Jobs Stored? - Interview Question of the Week #293 JobsStored-800x369

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.

Reference: Pinal Dave (https://blog.sqlauthority.com)

, ,
Previous Post
When was Stored Procedure Last Compiled? – Interview Question of the Week #292
Next Post
What is Temp Stored Procedures? – Interview Question of the Week #294

Related Posts

Leave a Reply

Menu