What is the default windows server directory where the SQL Server Agent 2012 Job log files are stored? I would like to transfer the raw log files to a group server so that an external support team can verify that the job executed without necessarily connecting to the server.
存储SQL server Agent 2012作业日志文件的默认windows server目录是什么?我希望将原始日志文件传输到组服务器，以便外部支持团队可以验证执行的作业，而不必连接到服务器。
1 个解决方案
#1
2
I don't think there is a normal directory for job logs. Generally, they live in the msdb catalog. When you view a job's history through the GUI, you're effectively looking at something along the lines of the following:
我认为没有一个正常的工作日志目录。通常，他们生活在msdb目录中。当你通过GUI查看工作的历史时，你实际上是在观察下面一行的内容:
SELECT TOP 1000 *
FROM msdb.dbo.sysjobs sj
INNER JOIN msdb.dbo.sysjobhistory sjs
ON sj.job_id = sjs.job_id;
That said, you should be able to tailor an export of this information to your liking and have your remote support work with that output.
也就是说，您应该能够根据自己的喜好定制此信息的导出，并使用该输出进行远程支持工作。
#1
2
I don't think there is a normal directory for job logs. Generally, they live in the msdb catalog. When you view a job's history through the GUI, you're effectively looking at something along the lines of the following:
我认为没有一个正常的工作日志目录。通常，他们生活在msdb目录中。当你通过GUI查看工作的历史时，你实际上是在观察下面一行的内容:
SELECT TOP 1000 *
FROM msdb.dbo.sysjobs sj
INNER JOIN msdb.dbo.sysjobhistory sjs
ON sj.job_id = sjs.job_id;
That said, you should be able to tailor an export of this information to your liking and have your remote support work with that output.
也就是说，您应该能够根据自己的喜好定制此信息的导出，并使用该输出进行远程支持工作。