January 7, 2004 at 12:50 pm
We would like to change who gets the email on a weekly basis. The On Call DBA is the person who should get emails. I have developed an email group called "DBAOnCall". The group contains one email address – the on-call DBA. Each Monday, I'd like change the membership in this group to the on call DBA email. The information is located in SQL Server and I can access that fine. Now that I know who's on call how do I change the membership in the group. I'd like to do this programmatically so it can be automated. The logon on the server is a local administrator.
Any thoughts?
January 7, 2004 at 1:57 pm
The server would need rights to get to Exchange and that requires a domain account.
What about retrieving the "to" email from the table and passing that into the email procedure?
If you're using alerts and such, then I'd put the onus on the new on call guy to get the group membership changed every week to his name. Or the old on call guy to move it. We do that here with the phone system. There is a central number that "points" to a cell phone. As on call changes, the DBAs have responsibility to change the pointer.
January 8, 2004 at 10:25 am
Since the programatic solution is lengthy, I would recommend looking into the Windows 2000 Active Directory Programming book, ISBN:0-7356-1037-1. Chapter 10 shows a scripted way of adding and removing user accounts in a group. This would allow you to setup scripts that change your DBA group memberships according to their work schedule or on-call schedule.
January 9, 2004 at 3:45 pm
I am not sure why you want to modify DBAoncall group everyweek. It is a permenent group and should have permenent member. In our group DBAoncall read all the email and respondes to all calls and pager for that week, but everyone is still allow to look at what's in the DBAoncal in-box. DBAoncall often would forward calls to other DBAs if we can't handle all the requests at once. So it is rather safe to say that our DBA group share the same DBAoncall mail box. We also have our own mailbox that contain our mail.
mom
January 14, 2004 at 10:55 am
I would like any emails to be sent to the DBA on call. So, I Thought if I created an email group that contained the name of this week's DBA then the email would be directed to them. I can change the group on a weekly basis to have the on call DBA manually but I would like to do it automatically each Monday. I have been told, offline, that the MS-Exchange server we are using is not an Outlook folder but some other structure. Anyway I think I would like to write a VB 6 program to read the database determine the on call DBA and release some routine that will update the DBAOnCall email group with that name. Once that is done then the program can be released via SQL Agent.
We are running Windows NT 4, with MS-Outlook 2000 and MS-Exchange Server and SQL Server 2000 SP 3a.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply