Skip to main content

Advanced features overview

What is it?​

This section covers SQL Agent features that go beyond the core job-running flow. Use these pages to understand how the agent retrieves and stores job output and how it writes and archives its own log files.

Pick the right page​

If you want to...Go to
Understand where job output goes and how it's retainedJob Output Retrieval System
Find or troubleshoot agent log filesLogging

In this section​

  • Job Output Retrieval System — How the Job Output Retrieval System (JORS) captures and stores job output for the SQL Agent.
  • Logging — Log files written by the SQL Agent and how the agent archives and retains them.