Open links in new tab
  1. Stairway to SQL Server Agent: Level 1: Setup and Overview

    Jan 11, 2012 · SQL Server Agent is a Microsoft Windows service that allows a DBA to automate administrative tasks. SQL Server Agent can run jobs, monitor SQL Server, and process alerts. The …

  2. Stairway to SQL Server Agent - Level 10: Using proxy accounts with …

    Dec 7, 2011 · SQL Server Agent Proxy accounts enable non- sysadmin users the ability to perform critical tasks while impersonating other Windows Security Credentials that have rights and privileges …

  3. how to know status of currently running jobs - Stack Overflow

    Aug 26, 2013 · I need to know if a given Job is currently running on Ms SQL 2008 server. So as to not to invoke same job again that may lead to concurrency issues.

  4. Understanding the Role of SQL Server Agent in SQL Server

    Feb 13, 2009 · SQL Server Agent is a component of Microsoft SQL Server that is responsible to execute & schedule tasks or jobs in SQL Server. It runs as a Windows service and starts automatically when …

  5. Where does SQL Server Agent save jobs? - Stack Overflow

    Oct 8, 2012 · My server is down and I can only get the harddisk from it. I found my database and copied it but where I can find agent jobs? Where are they saved?

  6. sql server - How can I schedule a job to run a SQL query daily? - Stack ...

    Mar 29, 2011 · I need to know how to make a SQL query run daily using a SQL Server Agent job, with minimum required configuration settings.

  7. sql server - The request failed or the service did not respond in a ...

    32 Above mentioned issue happened in my local system. Check in sql server configuration manager. Step 1: SQL server Network configuration step 2: Protocols for local server name Protocol name VIA …

  8. How to check if SQL Server Agent is running - Stack Overflow

    Jul 24, 2012 · I am using SQL Server 2008 r2. I want to find a way to verify if SQL Server Agent is running. I am suspicious that the Agent isn't running, but I don't know how to check.

  9. I need to grant SQL Agent Service Account rights to execute SQL …

    1 My goal is to run jobs not by employee but by SQL Server Agent / Service Account. All you have to do is create the job as a sysadmin, because

  10. No tengo acceso al SQL server Agent - Stack Overflow en español

    Jan 11, 2023 · Hola a todos necesito crear y visualizar los jobs creados en sql server management pero no tengo acceso al sql server agent. Esto es lo que muestra mi explorador de objetos: y esta es mi …