sql operator

Last Post 10 Jan 2011 08:20 AM by russellb. 6 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
dbandee
New Member
New Member

--
07 Jan 2011 08: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 09:19 AM
Happy New Year!

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

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

--
07 Jan 2011 09: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 08: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 07:28 AM
thank you
that was it.
i did mean 12AM to 115959pm

thank you


russellb
New Member
New Member

--
10 Jan 2011 08:20 AM
Glad to help


Acceptable Use Policy
---