July 13, 2011 at 8:14 am
We recently lost our SQL admin and a couple of us know a little so we're trying to get up to speed. While doing this we have notice the following error in the Error Logs
07/13/2011 08:01:25,,Warning,[277] Operator 'SQL Admin' is not currently on duty so cannot be paged for job Transaction Log Backup.Subplan_1
(where SQL Admin is a defined Operator).
I've googled the above line and come up with only two hits so i'm hoping to tap into someone's experience here and maybe direct me to where I can turn this off. I've opened up the SQL Admin operator and there is nothing in the pager e-mail name. The only field used is the E-mail name.
I've also looked through the Transaction Log Backup job and I don't see a request to page any number/address.
July 13, 2011 at 8:22 am
Have you opened up this Maintenance plan? (Transaction Log Backup.Subplan_1) To see what is going on in it? Is it failing? Try changing the ownership of the Job.
July 13, 2011 at 11:49 am
That did it thanks!!
July 13, 2011 at 11:51 am
No Problem.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply