Prev: SQL JOB created by virus
Next: Service accounts
From: msnews.microsoft.com on 23 Jul 2008 05:32
Hi folks,

Our DBA support rests with two teams. From 07:30am PT till 07:30pm PT, it is
from USA and then it is outsourced to India. Thus we would like to have two
paging operators for all our jobs.

I can create two operators but the sql 2005 agent job would allow to assign
to only one paging operator. Thus when a job fails at midnight USA time, it
pages the USA pager and not the India one as we would like.

Any suggestions?

Thanks,
SQL_Help


From: Damian Widera on 23 Jul 2008 06:18
Well
I would create another job that would check which operator is on duty (India
or US) and change it in the main job just before it starts. Then you
probably get the message to the right country.
But this is my suggestion only

Damian
"msnews.microsoft.com" <SQL_Help(a)aaa.com> wrote in message
news:%23yUeYdK7IHA.4204(a)TK2MSFTNGP03.phx.gbl...
> Hi folks,
>
> Our DBA support rests with two teams. From 07:30am PT till 07:30pm PT, it
> is from USA and then it is outsourced to India. Thus we would like to have
> two paging operators for all our jobs.
>
> I can create two operators but the sql 2005 agent job would allow to
> assign to only one paging operator. Thus when a job fails at midnight USA
> time, it pages the USA pager and not the India one as we would like.
>
> Any suggestions?
>
> Thanks,
> SQL_Help
>


From: msnews.microsoft.com on 23 Jul 2008 06:46
Thanks for the reply, Damian.

That was my line of thinking too. But then, we are talking about close to 35
jobs to make the change. Thus I investigated and found this:
http://www.mssqltips.com/tip.asp?tip=1091
That article sums up what I need to do. Create a job at 07:30am and 7:30pm
PT and make the change in 'operator' across all jobs.

But then, that article does not mention about automating the process. Iam
now working on the automation part.

"Damian Widera" <damian.widera(a)ezuniverse.com> wrote in message
news:%23KSQ91K7IHA.2416(a)TK2MSFTNGP02.phx.gbl...
> Well
> I would create another job that would check which operator is on duty
> (India or US) and change it in the main job just before it starts. Then
> you probably get the message to the right country.
> But this is my suggestion only
>
> Damian
> "msnews.microsoft.com" <SQL_Help(a)aaa.com> wrote in message
> news:%23yUeYdK7IHA.4204(a)TK2MSFTNGP03.phx.gbl...
>> Hi folks,
>>
>> Our DBA support rests with two teams. From 07:30am PT till 07:30pm PT, it
>> is from USA and then it is outsourced to India. Thus we would like to
>> have two paging operators for all our jobs.
>>
>> I can create two operators but the sql 2005 agent job would allow to
>> assign to only one paging operator. Thus when a job fails at midnight USA
>> time, it pages the USA pager and not the India one as we would like.
>>
>> Any suggestions?
>>
>> Thanks,
>> SQL_Help
>>
>
>


 | 
Pages: 1
Prev: SQL JOB created by virus
Next: Service accounts