April 28, 2010 at 7:24 am
Today we observed that The scheduled loads on Server are not kicked off.But we could see the status as successful.We verified the Event Viewer and observed that the packages ran for 1 second and showed the status as successfully completed.
But the jobs are not running successfully.we have to run manuvally those jobs are running fine.
whats wrong with Sql server agent.
April 28, 2010 at 7:39 am
April 28, 2010 at 7:43 am
Three things :
1) Are you using sp_send_dbmail ?
2) Did you see any records in EXTERNALEMAILQUEUE table ?
3) Have you checked Sql agent mail log ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 28, 2010 at 9:10 am
ya .i have checked in alllogs and i have seen sp_readerrorlog info.there is no failure mesages.
April 28, 2010 at 9:13 am
Are the jobs set to for "On Failure Action" to "Quit the Job Reporting Failure"?
Sometimes jobs are set to report success even when they failed (there are good business reasons why)
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 29, 2010 at 12:01 am
have you changed the Job scheduled timing recently ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 29, 2010 at 12:24 am
Are your schedules enabled ?
What kind of jobs do you have ?
- local sqlinstance only
- ssis packages
- cmdshell
did you change the sqlagent service account lately ? (and does that account have the same windows privileges a the previous account ?)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
April 29, 2010 at 12:27 am
ALZDBA (4/29/2010)
did you change the sqlagent service account lately ? (and does that account have the same windows privileges a the previous account ?)
Good Question 🙂
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply