Questions tagged [sql-server-agent]

SQL Server Agent is a Microsoft Windows service that executes scheduled administrative tasks, which are called jobs. SQL Server Agent uses SQL Server to store job information. Jobs contain one or more job steps. Each step contains its own task, for example, backing up a database. SQL Server Agent can run a job on a schedule, in response to a specific event, or on demand.

From Microsoft.com:

SQL Server Agent is a Microsoft Windows service that executes scheduled administrative tasks, which are called jobs. SQL Server Agent uses SQL Server to store job information. Jobs contain one or more job steps. Each step contains its own task, for example, backing up a database. SQL Server Agent can run a job on a schedule, in response to a specific event, or on demand.

483 questions
-1
votes
1 answer

How to use SQL Server Agent Job?

I will need a steps that detect some values and alert me through email. So I enable Database Email and setup. I will need a Query that detects and if Value is what I am looking for then, I will need that to be send email alert. SELECT * FROM…
user2502947
  • 69
  • 1
  • 4
-2
votes
2 answers

SQL Server Jobs only finishing after I restart the Server Agent

I have 13 Sql jobs that run at night starting at 11:30pm. Most of them never finish. When I restart the sql agent job it and run the jobs manually it will run but when they run on their own they will continue to run until I stop them. I have a…
Andrea
  • 1
1 2 3
32
33