In one of my previous posts "Undocumented stored procedure for retrieving SQL Agent properties", I had explained how to retrieve the SQL Agent Properties.
In this post I will explain how to change the location of the SQL Agent Log file "SQLAGENT.OUT".
To find the current location of SQLAGENT.OUT file, execute the below SP and look at the value of the column "errorlog_file". This is location where SQLAGENT.OUT file is located.
EXEC msdb..sp_get_sqlagent_properties GOOutput:
Now, to change the location of SQLAGENT.OUT file, run the below command and re-start the SQL Server Agent Service and you are done.
EXEC msdb.dbo.sp_set_sqlagent_properties @errorlog_file=N'<new path>\SQLAGENT.OUT' GO
4 comments:
I really liked this post. I don't even know about this file..now i got and learnt.
Very nice post..
Keep posting like these scenario's
Thanks,
Prasad
Its a great pleasure reading your post.Its full of information I am looking for and I love to post a comment that "The content of your post is awesome" Great work. moving company los angeles
Awesome and interesting article. Great things you've always shared with us. Thanks. Just continue composing this kind of post. moving company in van nuys
One more disadvantages start with the trip to the casino. Depending on where you live, you might have to drive for several hours, or fly, just to get there., on the other hand, When you choose an online casino, you remain in control.
sbobet88 mobile
Post a Comment