RowModCtr and STATS_DATE
RowModCtr and 2012 and DMV.
Dynamic SQL to be able to cut across from sys.databases in master.
Use sys views not the informationschema. For example, schemas. And object id is only available in sys views.
File System Permissions March 2, 2014
Trouble shooting jobs.
2. Check that Task Scheduler service is running.
Verbose errors to a file.
Firstly, configure logging for the steps you wish to keep log data for:
Right-click the job, and select “Properties”.
Click “Steps” in the left-hand pane.
Click on the step to edit in the right-hand pane.
Click “Edit” (or simply double-click the step to combine 2 and 3)
Click “Advanced” in the left-hand pane.
Click “Log to table”.
Confirm the modifications to the step, and to the Job.
What matters here is the use of two columns:
Log in sysjobstepslogs
Message in sysjobhistory