November 19, 2024 at 7:25 am
Hi All,
I have few sql server agent scheduled jobs which are supposed to run as NT Service\mssqlserveragent account however at times it runs using different account. Being novice in this world , I am not able to figure out where to make the change in agent job security to ensure that it only and always runs under nt service account or any other account as specified.
Where do i set this up?
Thanks in advance.
-Onkar
November 19, 2024 at 9:16 am
Don't !
There must be a reason someone configured it that way.
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
November 19, 2024 at 11:03 am
Thank you for the response Johan. This job was always running under nt service account but now it is somehow not sending emails. Job runs successfully in the db but the mail part fails.
November 19, 2024 at 4:14 pm
Check the database mail log and verify the email is being sent to the queue, the queue is active and that there are no errors.
select * from msdb.dbo.sysmail_allitems
If it has suddenly stopped working, hopefully something in the DBMail log can point you in the right direction.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply