Advertisements
Once we have configured all linked server setup and we can create a job in the agent based on the alert we wanted to email.
Following image will give some idea, how many jobs can be created with combined of SP and sctipts.
Job to be created:
Hoping this will give some idea.