SQL Agent Jobs Quiz

5 questions Pass: 70% +25 pts (50 with Pro)

Quiz covering Task Automation

What you'll be asked

  1. Which SQL Server component is primarily responsible for scheduling and executing automated tasks such as backups and maintenance plans?
  2. When creating a new SQL Agent Job, which component defines the actual work (e.g., T-SQL script, PowerShell, or SSIS package) to be performed?
  3. If you need a job to run every day at 2:00 AM, which component of the SQL Agent Job must be configured?
  4. You want to be notified via email immediately if a critical maintenance job fails. Which feature should you configure in the job properties?
  5. You are running a job step that executes a PowerShell script. The job fails with an 'Access Denied' error, even though the SQL Server Agent service account has high privileges. What is the most secure way to resolve this?

Answers and explanations come after you submit.