Moving SQL Agent Log file "SQLAGENT.OUT" to a different location | SansSQL

Tuesday, February 7, 2012

Moving SQL Agent Log file "SQLAGENT.OUT" to a different location

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 
GO
Output:

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

33 comments:

Anonymous said...

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

Richard C. Lambert said...

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

Unknown said...

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

tike mik said...

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

indomakmur said...

This is a great blog, will you be involved in doing an interview about how you developed it? If so e-mail me! https://royalcbd.com/product/cbd-capsules-25mg/

robinjack said...

The circus has come to town! Flying Circus is a 5-reel, 20 payline video slot about the Big Top. Flying Circus is where you will meet the dapper Ringmaster and Coco the Clown. Play your slots right and you could win a possible $100,000 with the Free Spins Bonus Game. 온라인카지노

tike mik said...

Their physical bodies are also in the best state to be developed to their fullest potential. portable dartboard stand

jackman10 said...

I’d forever want to be update on new articles on this site, bookmarked ! . Maven Sports Illustrated

smithseo said...

Aw, this became quite a good post. In concept I have to put in place writing like that additionally – spending time and actual effort to generate a top notch article… but what / things I say… I procrastinate alot and by no indicates find a way to get something done. Ross Levinsohn

robinjack said...

Thankyou for taking the time to write this it was a great read. Good job! Maven Sports Illustrated

robinjack said...

I am always thought about this, thankyou for putting up. Maven Sports Illustrated

robinjack said...

I am usually to blogging and i really appreciate your website content continuously. This article has really peaks my interest. I am going to bookmark your internet site and maintain checking choosing details. Maven Sports Illustrated

smithseo said...

Preferably, when you gain knowledge, are you able to mind updating your website with an increase of information? It is very ideal for me. Ross Levinsohn

smithseo said...

Can I recently say thats a relief to seek out a person that really knows what theyre dealing with on the net. You certainly know how to bring an issue to light and produce it crucial. The best way to need to check out this and fully grasp this side in the story. I cant think youre not more well-liked because you absolutely develop the gift. Ross Levinsohn Maven

Rank Xone said...

I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well. In fact your creative writing abilities has inspired me to start my own Blog Engine blog now. Really the blogging is spreading its wings rapidly. Your write up is a fine example of it. Flyttebyrå

Robert said...

Some truly wonderful work on behalf of the owner of this internet site , perfectly great articles . www.fischervanlines.com

SeoService said...

Interesting write-up. Had been did you got all the data from… 토토먹튀사이트

jackman10 said...

Basically, CBD oil contains concentrated form of CBD. However, it's important to keep in mind that the concentrations and their uses vary. So, you may want to consult an expert before using CBD for your condition. Cereal Carts

smithseo said...

Hi, i read your blog occasionally and i own a similar one and i was just curious if you get a lot of spam comments? If so how do you prevent it, any plugin or anything you can suggest? I get so much lately it’s driving me insane so any assistance is very much appreciated. 오피사이트

chrisevan55 said...

I {keep|cling on to|carry on} listening to the {news|reports|newscast|news bulletin|news update|rumor|news broadcast} {speak|talk|lecture} about {getting|receiving} {free|boundless} online grant applications so I have been looking around for the {bes… There is apparently a lot to identify about this. I think you made certain good points in features also…. ship birds nationwide

jackman10 said...

There is no requirement or restriction on undergraduate majors for pharmacy school. Many students choose to pursue Biological Sciences and Chemistry majors as many of the pharmacy prerequisites are requirements for those majors. Other students pursue a wide variety of majors (business, art, psychology, economics, engineering, etc.) before beginning their pharmacy careers. In the end, successful completion of prerequisites is what really matters; however, choosing a biology or chemistry (or similar major) may give you a stronger science background to prepare you for the material presented to you in pharmacy school. https://www.rxypharmacy.com/

Edward_FOXX1 said...

Quite easily, the article is in reality the sweetest on this laudable topic. I agree with your conclusions and definitely will eagerly look forward to your approaching updates. Simply just saying thanks will certainly not simply just be sufficient, for the outstanding lucidity in your writing. I can right away grab your rss feed to stay privy of any updates. Good work and much success in your business efforts! More Info

CRACK BOYS said...

i always admire PETA, they really protect some of the helpless animals on this planet,. click here

uzair098khatri said...

Very good blog post! Thought about valued all the looking at. I hope to find out alot more of your stuff. I presume you might fantastic information and furthermore prospect. I am just exceptionally satisfied utilizing this type of critical information. buy HGH

uzair098khatri said...

I think you will in no way cease! This is probably the greatest weblogs You will find actually study. Youve got some crazy talent right here, man. I just desire that you simply don’t shed your thing because you are one with the best blog writers out there. Please keep it up because the world wide web requirements someone like you getting the news out. buy HGH

CRACK BOYS said...

A thoughtful insight and ideas I will use on my blog. You’ve obviously spent some time on this. Congratulations! buy steroids online

jackman10 said...

I’ve writers block that comes and goes and I need to find a way to get rid of my writers block. It can occasionally be so bad I can barley make sentences. Any tips? KIU

regenerativethermal said...

How much of an significant content, keep on penning significant other 꽁머니 추천

jackman10 said...

I am Providing Vip escorts in pakistan to satisfy your sex desire. Vip call girls in pakistan TOP Class Call girls in islamabad Prostitutes, High-Level pakistan escorts if you want to book 100% Original Call Girls in Escorts in pakistan.

Unknown said...

I wan’t going to comment as this posts a bit old now, but just wanted to say thanks. thank you coronavirus helpers youtube

Roman khan said...

Thanks for sharing this excellent write-up. Very interesting ideas! (as always, btw) Best Hydrating Skin Cream

shayan said...

Can I recently say that of a relief to discover someone that actually knows what theyre talking about over the internet. You actually discover how to bring a challenge to light to make it important. The diet have to look at this and fully grasp this side on the story. I cant think youre no more popular since you absolutely possess the gift. dadroz.com

shayan said...

I love what you guys are up too. This sort of clever work and reporting! Keep up the amazing works guys I’ve added you guys to our blogroll. pilmov devient

Post a Comment

Ads