SQL Server Agent : It is a component of Microsoft SQL Server and it uses SQL Server to store job information. It is kind of background process tool to handle schedules jobs and other automated task. In simple words it runs scheduled background job continuously.
So now we will schedule our package.dtsx as a job to SQL Server Agent to run this task automatically.
In order to schedule a job in SQL Server Agent, Open SQL Server Agent -> right click on Jobs -> Create a New Job -> Form Module Opens -> Enter Job Name.
In order to schedule a job in SQL Server Agent, Open SQL Server Agent -> right click on Jobs -> Create a New Job -> Form Module Opens -> Enter Job Name.
Now in the same form module if see on left hand side there is menu in that select steps -> Click on New button. Here we need to specify what task we want to schedule.
Just specify nice name and in the type -> Select SQL Integration Service Package why because we want to schedule integration service package -> in the server text select appropriate server name -> and in the package column select your deployed package as shown in below image.
Here in this step go to -> Schedule which should be under "Steps menu link" -> New Button and Give nice name and schedule date time and other parameters as per your requirement like when you want to run (Daily/Weekly) and Schedule type so on.
It will send you the email notification alert, when the JOB succeeds or fails.
If you want to notify an operator by e-mail, check E-mail, select an operator from the list.
If you’d like to add multiple e-mail addresses on this “Operator” you separate each e-mail with a semi-colon. You would do this so that multiple people can be notified but you only have to refer to one operator in the SQL Agent Job.
