Multiple choice technology databases

Which database holds the information of all the jobs in a server?

  1. master

  2. model

  3. sysjobs

  4. msdb
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The msdb database is used by SQL Server Agent to store job information, schedules, and operational history. The sysjobs table is actually a table within the msdb database, not a database itself. master stores system-level configuration, and model is a template database used when creating new databases.

Keep practicing — related questions