April 27, 2013 at 7:21 am
Hi All,
I am facing issue in sql agent jobs after a RAM upgrade in a multi -instance server.
Details are as below
Microsoft Windows Server 2008 R2
Enterprise Edition,NT x64
MICROSOFT SQL SERVER 2008 R2
MICROSOFT CORPORATION ENTERPRISE EDITION (64-BIT) - 10.50.2500.0
SP1
RAM is upgraded to 64 GB from 32 GB . Out of 32 GB ,
a) For one instance it is upgraded from 4 to 12 GB
b) For one instance it is upgraded from 12 to 20 GB
Rest is available to OS.
After this and server reboot , The agent jobs are not getting is triggered automatically.
Any help , where I am missing .
Thanks
Aslam
April 27, 2013 at 8:43 am
has the SQLAgent service been restarted. Some sysadmins do not realise that restarting the SQL service does not restart the agent.
---------------------------------------------------------------------
April 27, 2013 at 9:24 am
Yes . It as has been set to automatic mode . Still I have tried restarting it. Does not help .
However just as a try , I recreated one of the maintenance job and it started working . So i do have a workaround of the situation but I am looking for cause .
Thanks
April 27, 2013 at 9:31 am
long shot (I hope) and I doubt it but they didn't rename the server did they?
maint plans should produce a .txt file in the install path\log directory, any errors in those?
---------------------------------------------------------------------
April 27, 2013 at 12:11 pm
No change . only ram increase.
April 30, 2013 at 4:00 am
Surprisingly , The sql jobs started working automatically after few hours .
Still not able to find the cause.
If i was not having the error mails , i would would have got suspicious of my eyes.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy