استفسار

نورة رباح كتب:

السلام عليكم اود ان اعرف ما هو دور agent sql server 

اختي الفاضلة : نوره

وعليكم السلام ورحمة الله وبركاته

ليس لقاعدة البيانات اكسيس علاقة بهذا الموضوع فأنتي تسألين في قاعدة البيانات SQL Server  وكان المفروض ان تتوجهي بالسؤال الى هذا القسم

/index.php/forum/63-%D9%82%D9%88%D8%A7%D8%B9%D8%AF-%D8%A8%D9%8A%D8%A7%D9%86%D8%A7%D8%AA-microsoft-sql-server/

عموما سوف نجيبك على سؤالك

SQL Server Agent is a Microsoft Windows service that executes scheduled administrative tasks, which are called jobs in SQL Server

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. For example, if you want to back up all the company servers every weekday after hours, you can automate this task. Schedule the backup to run after 22:00 Monday through Friday; if the backup encounters a problem, SQL Server Agent can record the event and notify you

By default, the SQL Server Agent service is disabled when SQL Server 2012 is installed unless the user explicitly chooses to autostart the service

SQL Server Agent uses the following components to define the tasks to be performed, when to perform the tasks, and how to report the success or failure of the tasks

بالتوفيق