
|
Log output from sql agent jobs Two ways to log jobs - both equally effective You can either pipe the output if you are running batch (.bat) files or In the jobs steps - advanced use the output file option. Database dumps / log dumps Don't forget to include the logs directory in the server backup schedule! One word of warning...Permissions - the account that SQLServerAgent is running under will need permission to create files in the log directory. |