Sql Server Agent in SQL Server||SQL Server Agent #sqlserver #sqlserver #agent

preview_player
Показать описание
SQL Server Agent Job is a component of Microsoft SQL Server which schedules jobs and handles other automated tasks. It runs as a Windows service so it can start automatically when the system boots or it can be started manually.
credit : Wikipedia.

Sql Server Agent in SQL Server||SQL Server Agent #sqlserver #sqlserver #agent
Рекомендации по теме
Комментарии
Автор

I appreciate your efforts in making this. 🙂

dhruvipatel
Автор

Thanks for detailed explanation. one quick question we have source system with sql server and sql DB with read-only access. we need to extract the data from source system by querying and our target is flat files created packages by using visaul studio. we don't want to deploy the pacakges on source system for the new Target server we just need 1) Sql Server integration service catalog enabled for deploying the pacakges 2) Sql Server agent enabled for scheduling the packages correct ?. I don't need any Database as I'm writing to Flat files. Please confirm if correct ?

narenchitra