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 

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' 


Anonymous said...

I really liked this post. I don't even know about this i got and learnt.

Very nice post..

Keep posting like these scenario's


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!

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

Post a Comment