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

79 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

Ana Burden 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

MR King # said...

It’s rare knowledgeable individuals within this topic, however you sound like do you know what you are talking about! Thanks oneplus service center in Hsr Layout

Unknown said...

When did it start? The day I started surfing the Internet to read articles related to . I've been fond of seeing various sites related to 안전놀이터 around the world for over 10 years. Among them, I saw your site writing articles related to and I am very satisfied.

Unknown said...

My spouse and I found you from a another page plus thought I might check things out on الإحتباس الحراري وأثره على البيئة | هندسة نت . We like what I view thus now I am a fan. Look toward exploring your web site again. Incidentally what about Muammar Gaddafi breathtaking media stories what do you really think . Kudos … Irrigation System Maintenance Best Graphics Card

Unknown said...

Certainly completely with your conclusions and imagine that you’ve made some excellent points. Also, I like design of one’s site plus the ease of navigation. I’ve bookmarked your site and may return often! Removal company stevenage

kera4d said...

you will need support or suggestions, write me privately.
I interested in your implementation/use case.
the best kera4d
Togel2win

Unknown said...

Hi there, It’s posts like this that keep me coming back and checking this site regularly, thanks for the info! Diagnostic Assessment

Unknown said...

I have been examinating out some of the stories and it is fairly very good stuff. I’ll certainly bookmark your blog. Mechanical Energy

Unknown said...

Fantastic site. A lot of useful information here. I am sending it to several friends ans additionally sharing in delicious. And naturally, thank you on your effort! Crime Control Model

Unknown said...

You need to experience a contest for one of the finest blogs on the web. I most certainly will suggest this blog! Marginal Cost

Unknown said...

As I web site possessor I believe the content material here is rattling magnificent , appreciate it for your hard work. You should keep it up forever! Good Luck. Rhyme Scheme

Unknown said...

Is your webdesigner looking for a job. I think your site is great. Power Function

Unknown said...

Look at your efforts and also exactly what it’s always worth. SO2 – A Detailed Discussion

Unknown said...

After study some of the websites with your web site now, and i also genuinely much like your strategy for blogging. I bookmarked it to my bookmark website list and will also be checking back soon. Pls consider my site at the same time and tell me what you think. Circle Of Illumination

Unknown said...

I really appreciate this particular blog and exactly how its laid out, thankyou I’ve saved. How Can You Square a Number in Java

Unknown said...

Hiya, have you possibly pondered to publish concerning Nintendo DSi? Poe’s The Cask of Amontillado

Unknown said...

I and my friends happened to be going through the good tips and hints on your web blog and before long came up with a terrible feeling I never expressed respect to the web blog owner for those techniques. My ladies were certainly glad to learn them and have in effect surely been taking pleasure in those things. Thanks for actually being considerably considerate and for pick out varieties of wonderful themes millions of individuals are really desirous to learn about. My very own honest regret for not expressing gratitude to sooner. professional agile scrum certification

yousuf said...

I and my friends happened to be going through the good tips and hints on your web blog and before long came up with a terrible feeling I never expressed respect to the web blog owner for those techniques. My ladies were certainly glad to learn them and have in effect surely been taking pleasure in those things. Thanks for actually being considerably considerate and for pick out varieties of wonderful themes millions of individuals are really desirous to learn about. My very own honest regret for not expressing gratitude to sooner. shed rentals near me

yousuf said...

I’d have got to talk to you here. Which isn’t some thing I do! I enjoy reading an article that should get people to think. Also, thank you for allowing me to comment! gửi hàng sang nhật

yousuf said...

I am often to blogging and that i really appreciate your content regularly. The article has truly peaks my interest. I’m going to bookmark your website and maintain checking for brand spanking new data. oil cooler cummins isx

Unknown said...

I am often to blogging and that i really appreciate your content regularly. The article has truly peaks my interest. I’m going to bookmark your website and maintain checking for brand spanking new data. marijuana pipes

Unknown said...

light bulbs are good for lighting the home but stay away from incandescent lamps because they generate so much heat“ Adinkra symbols

Unknown said...

Hello, I just hopped over to your web page via StumbleUpon. Not somthing I would usually browse, but I appreciated your thoughts none the less. Thanks for making some thing well worth browsing. ortodontia asa sul

yousuf said...

light bulbs are good for lighting the home but stay away from incandescent lamps because they generate so much heat“ sexual problems

Unknown said...

Not a unhealthy post, did it take you numerous of time to consider it? register company Singapore

Unknown said...

I liked the article, Ill be back to read more of your blog later =) Charlotte Moving Company

Unknown said...

It’s nearly impossible to find knowledgeable men and women about this topic, but you appear to be what happens you are dealing with! Thanks transformer table

yousuf said...

Hi, I think your website might be having browser compatibility issues. When I look at your blog in Firefox, it looks fine but when opening in Internet Explorer, it has some overlapping. I just wanted to give you a quick heads up! Other then that, awesome blog! garmin 935 forerunner reviews

Unknown said...

I am impressed with this web site , rattling I am a big fan . plüschtiere

Unknown said...

I simply wanted to thank you very much all over again. I am not sure the things I might have accomplished without those aspects shown by you on such problem. It had been a real distressing condition in my view, nevertheless taking note of a specialized way you resolved the issue forced me to jump with happiness. I’m just happy for this assistance as well as hope you really know what a powerful job that you are carrying out instructing most people thru a blog. I’m certain you have never come across all of us. Garage door repair huntington beach ca

Unknown said...

Hello, i think that i saw you visited my site thus i came to “return the favor”.I’m trying to find things to enhance my site!I suppose its ok to use some of your ideas!! high end fashion retouching services

yousuf said...

Youre so cool! I dont suppose Ive read anything like this prior to. So nice to seek out somebody with a few original applying for grants this subject. realy i appreciate you for beginning this up. this fabulous website is a thing that is required online, somebody with a little originality. beneficial job for bringing something totally new to your web! lamborghini t shirt

Unknown said...

This is very significant, and yet necessary towards just click this unique backlink: 토토커뮤니티

Unknown said...

This content is simply exciting and creative. I have been deciding on a institutional move and this has helped me with one aspect. 먹튀검증사이트

Unknown said...

This is very significant, and yet necessary towards just click this unique backlink: 먹튀검증사이트

Unknown said...

This is very significant, and yet necessary towards just click this unique backlink: 꽁머니사이트

Unknown said...

–Ask on your own in case you are enthusiastic about utilising weblogs to communicate with your clientele? BEP20 token creation

Unknown said...

So Great! I need some infos in this post for my rapport de stage. Can i have your contact please? I need your permission to quote it . Anyway, That’s great job. Keep going. baby designer clothes

Unknown said...

hey there and thank you for your information – I’ve definitely picked up anything new from right here. I did however expertise some technical issues using this website, as I experienced to reload the web site a lot of times previous to I could get it to load correctly. I had been wondering if your web hosting is OK? Not that I am complaining, but sluggish loading instances times will very frequently affect your placement in google and could damage your high quality score if advertising and marketing with Adwords. Well I am adding this RSS to my email and can look out for a lot more of your respective exciting content. Ensure that you update this again very soon.. company secretary services singapore

Mindest said...

I think this is an informative post and it is very useful and knowledgeable. therefore, I would like to thank you for the efforts you have made in writing this article. https://www.5g999.co/slot

bombay said...

I appreciated your work very thanks INDIAN VISA APPLICATION

nuch said...

SuperSlot The betting site that we trust to be number one in our hearts can't be a website other than this website which we can say that you will surely be impressed.

pgslot.game said...

เกม pg slot เกี่ยวกับ สภาพอากาศ วันนี้พวกเรามาดูกันว่า pg slot มีเกมไหนบ้างที่ลักษณะอากาศด้านในเกมนั้น มีผลกับการเล่นของพวกเราได้โดยตรง มีเกมไหนบ้าง มาดูกัน เกมหลายเกมมองสดชื่นมากเพิ่มขึ้น

james said...

His innovative method is designed to have maximum carry over into specific athletic techniques. Paul is the author of books and DVD’s on the topic of flexibility, martial arts and bodyweight training. first arabesque ballet

bombay said...

It is an excellent blog, I have ever seen. I found all the material on this blog utmost unique and well written. And, I have decided to visit it again and again. ดู เค้า ไพ่ บา คา ร่า

Mindest said...

I really appreciate this wonderful post that you have provided for us. I assure this would be beneficial for most of the people. hotmail login

bombay said...

It is a fantastic post – immense clear and easy to understand. I am also holding out for the sharks too that made me laugh. https://huayyeekee-finnbet.com

Post a Comment

Ads