I have a scheduler job that's defined as below:
EXEC dbo.spCheckSystemFailure @Threshold = 5
Now the Threshold is stored in a database table, "SystemParameter".
The way to get @Threshold is by executing the following statement:
WHERE SystemParameterName = 'Threshold'
Anyone can tell me the best way to streamline this job, i.e., to get
Threshold from "SystemParameter" table,and execute the stored
procedure with this value as @Threshold?