sql operator

Last Post 10 Jan 2011 07:20 AM by russellb. 6 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
dbandee
New Member
New Member

--
07 Jan 2011 07:39 AM
Hi
hope everyone had great new year start! it is good to be back!

this is on sql2k5
i created new sql operator, it is enabled
i have valid emails to be emailed and paged to my phone

i created dummy job that fails and it worked fine for a few days both emailing and paging but today i started getting error message in SQL Server Agent Error Log

Message:
[277] Operator 'TestDBAOpsTeam' is not currently on duty so can not be paged for job "Year Fin Close Stmtmnt"


does any one experienced this error?

thanks

russellb
New Member
New Member

--
07 Jan 2011 08:19 AM
Happy New Year!

Check the Pager on Duty Schedule in the operator properties
dbandee
New Member
New Member

--
07 Jan 2011 08:25 AM
all days checked including sat and sun from 115959 am to 115959pm
russellb
New Member
New Member

--
07 Jan 2011 08:36 AM
What time was the alert tried? You have it "off duty" from Midnight til noon. Is that the intended behavior? Maybe you meant it to be from 12:00:00 am to 11:59:59pm
gunneyk
New Member
New Member

--
08 Jan 2011 07:10 AM
I agree with Russell in that it has to be in one of the operators profiles to not be on duty at that time.
dbandee
New Member
New Member

--
10 Jan 2011 06:28 AM
thank you
that was it.
i did mean 12AM to 115959pm

thank you


russellb
New Member
New Member

--
10 Jan 2011 07:20 AM
Glad to help
You are not authorized to post a reply.

Acceptable Use Policy