Automon completion and job creation scheduling from agent DBA


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.


I’m currently working as a SQL server DBA in one of the top MNC. I’m passionate about SQL Server And I’m specialized in Administration and Performance tuning. I’m an active member of SQL server Central and MSDN forum. I also write articles in SQL server Central. For more Click here

Leave a Reply

Your email address will not be published. Required fields are marked *

20 + = 28