Unanswered: SQL Server Performance Condition Alerts
I am in the process of setting up performance condition alerts for monitoring data file / log file growth etc. The action to be taken in the event of an alert needs to be triggered by firing a pre-defined job.
Can I pass a parameter to a job ? If so, how do I create such a job ?
The reason is, if I have 20 databases in my server and if I have to create 4 alerts (20 for data space and 20 for log space), I do not want to create 40 different jobs to send alert messages to me based on which alert has occurred. Instead, I want to create 1 job that will take in a parameter and fire some messages.
The use of Email/Pager eliminates this problem but unfortunately, our corporate standard for messaging is Lotus and hence I cannot have Outlook installed.