March 3, 2006 at 8:14 am
when sql agent is restarted what is actually happens behind the scene?
March 6, 2006 at 8:00 am
This was removed by the editor as SPAM
April 3, 2006 at 12:24 pm
SQL Server Agent is a Windows service. So, when SQL Server Agent is started the service is turned on. It then connects to SQL Server and looks for alerts it needs to send or jobs that should be run. The information is stored in the MSDB database.
Not sure if this is at the level of information that you need.
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
April 3, 2006 at 12:27 pm
thanks for reply, I was looking for what happens programatically behind the scenes.
April 3, 2006 at 12:32 pm
If you are familiar with SQL profiler, you can set up a trace to watch the commands that SQL Server Agent sends to SQL Server.
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply