|
robvolk
Most Valuable Yak
USA
15557 Posts |
 Posted - 10/17/2012 : 18:13:58
|
There's no way for SQL Server to do this automatically, you'd have to schedule a job that updates the other jobs to change their operators.
Typically you'd set up a Windows group and add the support techs to that group, then set the SQL operator to email that group. Each recipient responds or ignores the emails depending on whether it's their shift. |
 |
|
Day / Night Operators
