Dynamically change the path of the ASE error log : sp_errorlog
Now you can take relief using sp_error for changing the errorlog dynamically without any down time. Its available from version V15.02 ESD4
sp_errorlog : Dynamically changes the path of the error log.
Syntax
sp_errorlog “change log”, “new_path”[,{“jslog true”| “jslog false”}]
sp_errorlog “help”, “change log”
Parameters
new_path – new path of the error log. Maximum length of new_path is 255 characters.
jslog true – the default option. If the Job Scheduler is running, change log attempts to change the Job Scheduler Agent log to the directory where the new Adaptive Server error log will reside. Both logs will indicate error messages, if any.
jslog false – do not change the location of the Job Scheduler Agent log.
Check the Sybase Wiki @ sybasewiki.com
Categories: ASE
Anurag has more than 6+ years of experience in Sybase Database Development .His Area of expertise includes Performance, Query Optimization, Cost Optimization, TSQL Development. He is also involved in Consultancy to Financial Firms for Database Implementation and Maintenance. He has supported many Global Financial firms.