Task: Functional-Dependency (source dataset: Auto-Relate)

Given a table represented shown below, your task is to determine functional dependencies that exist in the table. Recall that a functional dependency is a relationship where the value of one attribute (or a set of attributes), known as the determinant columns, can uniquely determines the value of another attribute, known as the dependent columns (e.g., student-ID => student-Name, car-model => car-make, employee-ID => department, etc.).

Instructions:
Analyze the provided table below, identify all functional dependencies that should semantically hold in the table. Do not produce spurious relationships that not semantically meaningful.

No explanation, format the output as a JSON object:{"Functional-Dependency": <list of functional dependencies>}. Each functional dependency should be represented as [<determinant column>, <dependent column>]

Input Table:
| Server    | Job Name                                 | Step Name                                                     | Execution Status   | Run Date                | Run Time                |   Run Duration Minutes | Message Generated                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | Job Status   | Date Created            | Date Modified           | Job Description           |   Step ID | Calendar Month   |   Calendar Month Number | Calendar Week in Year   |   Calendar Week Number in Year |   Calendar Year Month Number |   Calendar Year Week Number |   Calendar Year | Calendar Year Status   | Calendar Month Status     | Calendar Week Status   | Calendar Yr-Mo   | Calendar Yr-Qtr   |   Calendar Year Quarter Number | Calendar Yr-Wk   | Date                    | Prior Calendar Year Date   | Prior Calendar Month Date   |   Date Key |   Date Number | Fiscal Quarter   |   Fiscal Period | Calendar Week Ending Date   |   Weekday Sort | Weekday Abb   | Weekday   |   Fiscal Yr-Wk Sort | Fiscal Yr-Wk   | Fiscal Yr-Qtr   | Fiscal Yr-Period   |   Fiscal Yr-Period Sort |   Fiscal Year |   Fiscal Week Sort |   Fiscal Yr-Qtr Sort | Fiscal Date Last Year   |   Fiscal Week Sequence |   Fiscal Week of Period | Full Date Description   |   Day Number in Calendar Month |   Day Number in Calendar Year | Calendar Quarter in Year   |   Calendar Quarter Number in Year | Weekday Indicator   | Holiday Indicator   |   Calendar Week in Month | One Year Prior Date     | DST Flag   |
|:----------|:-----------------------------------------|:--------------------------------------------------------------|:-------------------|:------------------------|:------------------------|-----------------------:|:------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|:-------------|:------------------------|:------------------------|:--------------------------|----------:|:-----------------|------------------------:|:------------------------|-------------------------------:|-----------------------------:|----------------------------:|----------------:|:-----------------------|:--------------------------|:-----------------------|:-----------------|:------------------|-------------------------------:|:-----------------|:------------------------|:---------------------------|:----------------------------|-----------:|--------------:|:-----------------|----------------:|:----------------------------|---------------:|:--------------|:----------|--------------------:|:---------------|:----------------|:-------------------|------------------------:|--------------:|-------------------:|---------------------:|:------------------------|-----------------------:|------------------------:|:------------------------|-------------------------------:|------------------------------:|:---------------------------|----------------------------------:|:--------------------|:--------------------|-------------------------:|:------------------------|:-----------|
| PRODSRV01 | Capture Hourly Baselines                 | (Job outcome)                                                 | Succeeded          | 2017-05-27 00:00:00.000 | 1899-12-30 12:06:13.000 |                      2 | The job succeeded.  The Job was invoked by User ProdAccount\DBA.  The last step to run was step 4 (Capture Wait stats).  The job was requested to start at step 4 (Capture Wait stats).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       | Disabled     | 2017-04-22 04:24:25.020 | 2017-04-22 04:25:07.640 | No description available. |         0 | May              |                       5 | Wk21                    |                             21 |                          101 |                         445 |            2017 | Current Calendar Year  | Other Calendar Month      | Other Calendar Week    | 2017-May         | 2017-Q2           |                             34 | 2017-Wk21        | 2017-05-27 00:00:00.000 | 2016-05-27 00:00:00.000    | 2017-04-27 00:00:00.000     |   20170527 |          3069 | Q2               |               5 | 2017-05-27 00:00:00.000     |              7 | Sat           | Saturday  |                 439 | 2017-Wk17      | 2017-Q2         | 2017-P5            |                     111 |          2017 |                 17 |                   35 | 2016-05-28 00:00:00.000 |                    485 |                       1 | May 27, 2017            |                             27 |                           147 | Q2                         |                                 2 | Weekend             | Non-Holiday         |                        4 | 2016-09-11 00:00:00.000 | DST        |
| PRODSRV01 | DBMaint_IntegrityCheck                   | DBMaint-IntegrityCheck                                        | Succeeded          | 2017-05-26 00:00:00.000 | 1899-12-30 20:00:00.000 |                    473 | Executed as user: ProdAccount\DBA. Date and time: 2017-05-26 20:00:00  Server: PRODSRV01  Version: 13.0.4422.0  Edition: Enterprise Edition: Core-based Licensing (64-bit)  Procedure: [master].[dbo].[DatabaseIntegrityCheck]  Parameters: @Databases = 'Prod_Accounts', @CheckCommands = 'CHECKDB', @PhysicalOnly = 'N', @NoIndex = 'N', @ExtendedLogicalChecks = 'N', @TabLock = 'N', @FileGroups = NULL, @Objects = NULL, @MaxDOP = NULL, @AvailabilityGroups = NULL, @AvailabilityGroupReplicas = 'ALL', @Updateability = 'ALL', @LockTimeout = NULL, @LogToTable = 'N', @Execute = 'Y'  Source: https://ola.hallengren.com [SQLSTATE 01000] (Message 50000)  Date and time: 2017-05-26 20:00:01  Database: [Prod_Accounts]  Status: ONLINE  Standby: No  Updateability: READ_WRITE  User access: MULTI_USER  Is accessible: Yes  Recovery model: FULL  Availability group: AccountingAG  Availability group role: PRIMARY [SQLSTATE 01000] (Message 50000)  Date and time: 2017-05-26 20:00:01  Command: DBCC CHECKDB ([Prod_Accounts]) WITH NO_INFOMSGS, ALL_ERRORMSGS, DATA_PURITY [SQLSTATE 01000] (Message 50000)  Outcome: Succeeded  Duration: 07:53:14  Date and time: 2017-05-27 03:53:15 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-05-27 03:53:15 [SQLSTATE 01000] (Message 50000).  The step succeeded.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | Enabled      | 2017-04-22 04:22:33.823 | 2017-05-17 17:05:12.993 | No description available. |         1 | May              |                       5 | Wk21                    |                             21 |                          101 |                         445 |            2017 | Current Calendar Year  | Other Calendar Month      | Other Calendar Week    | 2017-May         | 2017-Q2           |                             34 | 2017-Wk21        | 2017-05-26 00:00:00.000 | 2016-05-26 00:00:00.000    | 2017-04-26 00:00:00.000     |   20170526 |          3068 | Q2               |               5 | 2017-05-27 00:00:00.000     |              6 | Fri           | Friday    |                 439 | 2017-Wk17      | 2017-Q2         | 2017-P5            |                     111 |          2017 |                 17 |                   35 | 2016-05-27 00:00:00.000 |                    485 |                       1 | May 26, 2017            |                             26 |                           146 | Q2                         |                                 2 | Weekday             | Non-Holiday         |                        4 | 2016-09-11 00:00:00.000 | DST        |
| PRODSRV01 | Backup_USER_DATABASES - FULL             | (Job outcome)                                                 | Succeeded          | 2017-06-14 00:00:00.000 | 1899-12-30 00:30:00.000 |                     76 | The job succeeded.  The Job was invoked by Schedule 14 (Daily - Full Backups of User Databases).  The last step to run was step 1 (DatabaseBackup - USER_DATABASES - FULL).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | Enabled      | 2017-04-19 21:17:02.956 | 2017-05-16 01:58:22.846 | No description available. |         0 | Jun              |                       6 | Wk24                    |                             24 |                          102 |                         448 |            2017 | Current Calendar Year  | 3 Mo Prior Calendar Month | Other Calendar Week    | 2017-Jun         | 2017-Q2           |                             34 | 2017-Wk24        | 2017-06-14 00:00:00.000 | 2016-06-14 00:00:00.000    | 2017-05-14 00:00:00.000     |   20170614 |          3087 | Q2               |               5 | 2017-06-17 00:00:00.000     |              4 | Wed           | Wednesday |                 442 | 2017-Wk20      | 2017-Q2         | 2017-P5            |                     111 |          2017 |                 20 |                   35 | 2016-06-15 00:00:00.000 |                    488 |                       4 | June 14, 2017           |                             14 |                           165 | Q2                         |                                 2 | Weekday             | Non-Holiday         |                        3 | 2016-09-11 00:00:00.000 | DST        |
| PRODSRV01 | DBMaint_OptimizeIndexes                  | Update stats for selected tables                              | Succeeded          | 2017-06-29 00:00:00.000 | 1899-12-30 00:41:15.000 |                    137 | Executed as user: ProdAccount\DBA. The step succeeded.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        | Enabled      | 2017-04-22 04:22:14.693 | 2017-06-14 00:54:16.890 | No description available. |         3 | Jun              |                       6 | Wk26                    |                             26 |                          102 |                         450 |            2017 | Current Calendar Year  | 3 Mo Prior Calendar Month | Other Calendar Week    | 2017-Jun         | 2017-Q2           |                             34 | 2017-Wk26        | 2017-06-29 00:00:00.000 | 2016-06-29 00:00:00.000    | 2017-05-29 00:00:00.000     |   20170629 |          3102 | Q2               |               6 | 2017-07-01 00:00:00.000     |              5 | Thu           | Thursday  |                 444 | 2017-Wk22      | 2017-Q2         | 2017-P6            |                     112 |          2017 |                 22 |                   35 | 2016-06-30 00:00:00.000 |                    490 |                       2 | June 29, 2017           |                             29 |                           180 | Q2                         |                                 2 | Weekday             | Non-Holiday         |                        5 | 2016-09-11 00:00:00.000 | DST        |
| PRODSRV01 | Backup_USER_DATABASES - FULL             | DatabaseBackup - USER_DATBASES - FULL                         | Succeeded          | 2017-07-13 00:00:00.000 | 1899-12-30 01:00:00.000 |                    254 | Executed as user: ProdAccount\DBA. ...13.0.4435.0  Edition: Enterprise Edition: Core-based Licensing (64-bit)  Procedure: [master].[dbo].[DatabaseBackup]  Parameters: @Databases = NULL, @Directory = '\\prodsrv01\W$\Backups', @BackupType = 'FULL', @Verify = 'Y', @CleanupTime = 96, @CleanupMode = 'AFTER_BACKUP', @Compress = NULL, @CopyOnly = 'N', @ChangeBackupType = 'N', @BackupSoftware = NULL, @CheckSum = 'Y', @BlockSize = NULL, @BufferCount = NULL, @MaxTransferSize = NULL, @NumberOfFiles = NULL, @CompressionLevel = NULL, @Description = NULL, @Threads = NULL, @Throttle = NULL, @Encrypt = 'N', @EncryptionAlgorithm = NULL, @ServerCertificate = NULL, @ServerAsymmetricKey = NULL, @EncryptionKey = NULL, @ReadWriteFileGroups = 'N', @OverrideBackupPreference = 'N', @NoRecovery = 'N', @URL = NULL, @Credential = NULL, @MirrorDirectory = NULL, @MirrorCleanupTime = NULL, @MirrorCleanupMode = 'AFTER_BACKUP', @AvailabilityGroups = 'ALL_AVAILABILITY_GROUPS', @Updateability = 'ALL', @LogToTable = 'Y', @Execute = 'Y'  Source: https://ola.hallengren.com [SQLSTATE 01000] (Message 50000)  Date and time: 2017-07-13 01:00:00  Database: [HR]  Status: ONLINE  Standby: No  Updateability: READ_WRITE  User access: MULTI_USER  Is accessible: Yes  Recovery model: FULL  Encrypted: No  Availability group: AccountingAG  Availability group role: PRIMARY  Availability group backup preference: PRIMARY  Is preferred backup replica: Yes  Differential base LSN: 37000000037600037  Last log backup LSN: 37000000061200001 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-07-13 01:00:00  Command: DECLARE @ReturnCode int EXECUTE @ReturnCode = [master].dbo.xp_create_subdir N'\\prodsrv01\W$\Backups\prodsrv01\W$\\HR\FULL' IF @ReturnCode <> 0 RAISERROR('Error creating directory.', 16, 1) [SQLSTATE 01000] (Message 50000)  Outcome: Succeeded  Duration: 00:00:00  Date and time: 2017-07-13 01:00:00 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-07-13 01:00:00  Command: BACKUP DATABASE [HR] TO DISK = N'\\prodsrv01\W$\Backups\prodsrv01\W$\\HR\FULL\prodsrv01\W$\_HR_FULL_20170713_010000.bak' WITH CHECKSUM, COMPRESSION [SQLSTATE 01000] (Message 50000)  Processed 360 pages for database 'HR', file 'HR' on file 1. [SQLSTATE 01000] (Message 4035)  Processed 2 pages for database 'HR', file 'HR_log' on file 1. [SQLSTATE 01000] (Message 4035)  BACKUP DATABASE successfully processed 362 pages in 0.878 seconds (3.217 MB/sec). [SQLSTATE 01000] (Message 3014)  Outcome: Succeeded  Duration: 00:00:02  Date and time: 2017-07-13 01:00:02 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-07-13 01:00:02  Command: RESTORE VERIFYONLY FROM DISK = N'\\prodsrv01\W$\Backups\prodsrv01\W$\\HR\FULL\prodsrv01\W$\_HR_FULL_20170713_010000.bak' WITH CHECKSUM [SQLSTATE 01000] (Message 50000)  The backup set on file 1 is valid. [SQLSTATE 01000] (Message 3262)  Outcome: Succeeded  Duration: 00:00:00  Date and time: 2017-07-13 01:00:02 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-07-13 01:00:02  Command: DECLARE @ReturnCode int EXECUTE @ReturnCode = [master].dbo.xp_delete_file 0, N'\\prodsrv01\W$\Backups\prodsrv01\W$\\HR\FULL', 'bak', '2017-07-09T01:00:02' IF @ReturnCode <> 0 RAISERROR('Error deleting files.', 16, 1) [SQLSTATE 01000] (Message 50000)  Outcome: Succeeded  Duration: 00:00:00  Date and time: 2017-07-13 01:00:02 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-07-13 01:00:02  Database: [ETL]  Status: ONLINE  Standby: No  Updateability: READ_WRITE  User access: MULTI_USER  Is accessible: Yes  Recovery model: FULL  Encrypted: No  Availability group: AccountingAG  Availability group role: PRIMARY  Availability group backup preference: PRIMARY  Is preferred backup replica: Yes  Differential base LSN: 31834000001050400048  Last log backup LSN: 31909000002001400001 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-0...  The step succeeded.           | Enabled      | 2017-04-24 17:10:45.000 | 2017-06-18 01:26:21.536 | No description available. |         1 | Jul              |                       7 | Wk28                    |                             28 |                          103 |                         452 |            2017 | Current Calendar Year  | 2 Mo Prior Calendar Month | Other Calendar Week    | 2017-Jul         | 2017-Q3           |                             35 | 2017-Wk28        | 2017-07-13 00:00:00.000 | 2016-07-13 00:00:00.000    | 2017-06-13 00:00:00.000     |   20170713 |          3116 | Q2               |               6 | 2017-07-15 00:00:00.000     |              5 | Thu           | Thursday  |                 446 | 2017-Wk24      | 2017-Q2         | 2017-P6            |                     112 |          2017 |                 24 |                   35 | 2016-07-14 00:00:00.000 |                    492 |                       4 | July 13, 2017           |                             13 |                           194 | Q3                         |                                 3 | Weekday             | Non-Holiday         |                        3 | 2016-09-11 00:00:00.000 | DST        |
| PRODSRV01 | DBMaint_OptimizeIndexes                  | Remove fragmentation for selected tables                      | Succeeded          | 2017-06-25 00:00:00.000 | 1899-12-30 03:36:34.000 |                    121 | Executed as user: ProdAccount\DBA. ...13.0.4435.0  Edition: Enterprise Edition: Core-based Licensing (64-bit)  Procedure: [master].[dbo].[IndexOptimize]  Parameters: @Databases = 'Prod_Accounts', @FragmentationLow = NULL, @FragmentationMedium = 'INDEX_REORGANIZE', @FragmentationHigh = 'INDEX_REORGANIZE', @FragmentationLevel1 = 5, @FragmentationLevel2 = 30, @PageCountLevel = 1000, @SortInTempdb = 'Y', @MaxDOP = 8, @FillFactor = NULL, @PadIndex = NULL, @LOBCompaction = 'N', @UpdateStatistics = NULL, @OnlyModifiedStatistics = 'N', @StatisticsSample = NULL, @StatisticsResample = 'N', @PartitionLevel = 'Y', @MSShippedObjects = 'N', @Indexes = 'Prod_Accounts.dbo.AccountData, Prod_Accounts.dbo.AccountDataHistory, Prod_Accounts.dbo.AccountDataOwner, Prod_Accounts.dbo.OldAccount, Prod_Accounts.dbo.CompanyData, Prod_Accounts.dbo.Customers,Prod_Accounts.dbo.Banks', @TimeLimit = 7200, @Delay = NULL, @WaitAtLowPriorityMaxDuration = NULL, @WaitAtLowPriorityAbortAfterWait = NULL, @AvailabilityGroups = NULL, @LockTimeout = NULL, @LogToTable = 'Y', @Execute = 'Y'  Source: https://ola.hallengren.com [SQLSTATE 01000] (Message 50000)  Date and time: 2017-06-25 03:36:34  Database: [Prod_Accounts]  Status: ONLINE  Standby: No  Updateability: READ_WRITE  User access: MULTI_USER  Is accessible: Yes  Recovery model: FULL  Availability group: AccountingAG  Availability group role: PRIMARY [SQLSTATE 01000] (Message 50000)  Date and time: 2017-06-25 03:36:36  Command: ALTER INDEX [_dta_index_AccountData_5_1739153241__K2_K1] ON [Prod_Accounts].[dbo].[AccountData] REORGANIZE WITH (LOB_COMPACTION = OFF)  Comment: ObjectType: Table, IndexType: NonClustered, ImageText: N/A, NewLOB: No, FileStream: N/A, ColumnStore: No, AllowPageLocks: Yes, PageCount: 26624, Fragmentation: 15.5273 [SQLSTATE 01000] (Message 50000)  Outcome: Succeeded  Duration: 00:01:08  Date and time: 2017-06-25 03:37:44 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-06-25 03:37:44  Command: ALTER INDEX [_dta_index_AccountData_6_1739153241__K2_K4_K20_K1_K22_3_8_9_10_12_13_14_15_18_19_21_23_24_25_26_27_28_30] ON [Prod_Accounts].[dbo].[AccountData] REORGANIZE WITH (LOB_COMPACTION = OFF)  Comment: ObjectType: Table, IndexType: NonClustered, ImageText: N/A, NewLOB: Yes, FileStream: N/A, ColumnStore: No, AllowPageLocks: Yes, PageCount: 121337, Fragmentation: 9.85684 [SQLSTATE 01000] (Message 50000)  Outcome: Succeeded  Duration: 00:05:39  Date and time: 2017-06-25 03:43:23 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-06-25 03:43:23  Command: ALTER INDEX [IX_AccountType] ON [Prod_Accounts].[dbo].[AccountData] REORGANIZE WITH (LOB_COMPACTION = OFF)  Comment: ObjectType: Table, IndexType: NonClustered, ImageText: N/A, NewLOB: No, FileStream: N/A, ColumnStore: No, AllowPageLocks: Yes, PageCount: 87528, Fragmentation: 7.8889 [SQLSTATE 01000] (Message 50000)  Outcome: Succeeded  Duration: 00:02:54  Date and time: 2017-06-25 03:46:17 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-06-25 03:46:17  Command: ALTER INDEX [IX_AccountData_6] ON [Prod_Accounts].[dbo].[AccountData] REORGANIZE WITH (LOB_COMPACTION = OFF)  Comment: ObjectType: Table, IndexType: NonClustered, ImageText: N/A, NewLOB: No, FileStream: N/A, ColumnStore: No, AllowPageLocks: Yes, PageCount: 86212, Fragmentation: 7.11966 [SQLSTATE 01000] (Message 50000)  Outcome: Succeeded  Duration: 00:03:02  Date and time: 2017-06-25 03:49:19 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-06-25 03:49:19  Command: ALTER INDEX [IX_AccountData_LastUpdatedBy] ON [Prod_Accounts].[dbo].[AccountData] REORGANIZE WITH (LOB_COMPACTION = OFF)  Comment: ObjectType: Table, IndexType: NonClustered, ImageText: N/A, NewLOB: No, FileStream: N/A, ColumnStore: No, AllowPageLocks: Yes, PageCount: 48865, Fragmentation: 7.08278 [SQLSTATE 01000] (Message 50000)  Outcome: Succeeded  Duration: 00:0...  The step succeeded. | Enabled      | 2017-04-22 04:22:14.693 | 2017-06-14 00:54:16.890 | No description available. |         2 | Jun              |                       6 | Wk26                    |                             26 |                          102 |                         450 |            2017 | Current Calendar Year  | 3 Mo Prior Calendar Month | Other Calendar Week    | 2017-Jun         | 2017-Q2           |                             34 | 2017-Wk26        | 2017-06-25 00:00:00.000 | 2016-06-25 00:00:00.000    | 2017-05-25 00:00:00.000     |   20170625 |          3098 | Q2               |               6 | 2017-07-01 00:00:00.000     |              1 | Sun           | Sunday    |                 444 | 2017-Wk22      | 2017-Q2         | 2017-P6            |                     112 |          2017 |                 22 |                   35 | 2016-06-26 00:00:00.000 |                    490 |                       2 | June 25, 2017           |                             25 |                           176 | Q2                         |                                 2 | Weekend             | Non-Holiday         |                        5 | 2016-09-11 00:00:00.000 | DST        |
| PRODSRV01 | Backup_USER_DATABASES - FULL             | (Job outcome)                                                 | Succeeded          | 2017-06-27 00:00:00.000 | 1899-12-30 01:00:00.000 |                    269 | The job succeeded.  The Job was invoked by Schedule 27 (Prod_Accounts_FullBackup).  The last step to run was step 1 (DatabaseBackup - USER_DATBASES_AG - FULL).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | Enabled      | 2017-04-24 17:10:45.000 | 2017-06-18 01:26:21.536 | No description available. |         0 | Jun              |                       6 | Wk26                    |                             26 |                          102 |                         450 |            2017 | Current Calendar Year  | 3 Mo Prior Calendar Month | Other Calendar Week    | 2017-Jun         | 2017-Q2           |                             34 | 2017-Wk26        | 2017-06-27 00:00:00.000 | 2016-06-27 00:00:00.000    | 2017-05-27 00:00:00.000     |   20170627 |          3100 | Q2               |               6 | 2017-07-01 00:00:00.000     |              3 | Tue           | Tuesday   |                 444 | 2017-Wk22      | 2017-Q2         | 2017-P6            |                     112 |          2017 |                 22 |                   35 | 2016-06-28 00:00:00.000 |                    490 |                       2 | June 27, 2017           |                             27 |                           178 | Q2                         |                                 2 | Weekday             | Non-Holiday         |                        5 | 2016-09-11 00:00:00.000 | DST        |
| PRODSRV01 | Backup_USER_DATABASES - FULL             | DatabaseBackup - USER_DATABASES - LOG                         | Succeeded          | 2017-07-07 00:00:00.000 | 1899-12-30 04:00:00.000 |                      2 | Executed as user: ProdAccount\DBA. ...13.0.4435.0  Edition: Enterprise Edition: Core-based Licensing (64-bit)  Procedure: [master].[dbo].[DatabaseBackup]  Parameters: @Databases = NULL, @Directory = '\\prodsrv01\W$\Backups', @BackupType = 'LOG', @Verify = 'Y', @CleanupTime = 108, @CleanupMode = 'AFTER_BACKUP', @Compress = NULL, @CopyOnly = 'N', @ChangeBackupType = 'N', @BackupSoftware = NULL, @CheckSum = 'Y', @BlockSize = NULL, @BufferCount = NULL, @MaxTransferSize = NULL, @NumberOfFiles = NULL, @CompressionLevel = NULL, @Description = NULL, @Threads = NULL, @Throttle = NULL, @Encrypt = 'N', @EncryptionAlgorithm = NULL, @ServerCertificate = NULL, @ServerAsymmetricKey = NULL, @EncryptionKey = NULL, @ReadWriteFileGroups = 'N', @OverrideBackupPreference = 'N', @NoRecovery = 'N', @URL = NULL, @Credential = NULL, @MirrorDirectory = NULL, @MirrorCleanupTime = NULL, @MirrorCleanupMode = 'AFTER_BACKUP', @AvailabilityGroups = 'ALL_AVAILABILITY_GROUPS', @Updateability = 'ALL', @LogToTable = 'Y', @Execute = 'Y'  Source: https://ola.hallengren.com [SQLSTATE 01000] (Message 50000)  Date and time: 2017-07-07 04:00:01  Database: [HR]  Status: ONLINE  Standby: No  Updateability: READ_WRITE  User access: MULTI_USER  Is accessible: Yes  Recovery model: FULL  Encrypted: No  Availability group: AccountingAG  Availability group role: PRIMARY  Availability group backup preference: PRIMARY  Is preferred backup replica: Yes  Differential base LSN: 36000000334100037  Last log backup LSN: 36000000333400001 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-07-07 04:00:01  Command: DECLARE @ReturnCode int EXECUTE @ReturnCode = [master].dbo.xp_create_subdir N'\\prodsrv01\W$\Backups\prodsrv01\W$\\HR\LOG' IF @ReturnCode <> 0 RAISERROR('Error creating directory.', 16, 1) [SQLSTATE 01000] (Message 50000)  Outcome: Succeeded  Duration: 00:00:00  Date and time: 2017-07-07 04:00:01 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-07-07 04:00:01  Command: BACKUP LOG [HR] TO DISK = N'\\prodsrv01\W$\Backups\prodsrv01\W$\\HR\LOG\prodsrv01\W$\_HR_LOG_20170707_040001.trn' WITH CHECKSUM, COMPRESSION [SQLSTATE 01000] (Message 50000)  Processed 3 pages for database 'HR', file 'HR_log' on file 1. [SQLSTATE 01000] (Message 4035)  BACKUP LOG successfully processed 3 pages in 0.006 seconds (2.685 MB/sec). [SQLSTATE 01000] (Message 3014)  Outcome: Succeeded  Duration: 00:00:00  Date and time: 2017-07-07 04:00:01 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-07-07 04:00:01  Command: RESTORE VERIFYONLY FROM DISK = N'\\prodsrv01\W$\Backups\prodsrv01\W$\\HR\LOG\prodsrv01\W$\_HR_LOG_20170707_040001.trn' WITH CHECKSUM [SQLSTATE 01000] (Message 50000)  The backup set on file 1 is valid. [SQLSTATE 01000] (Message 3262)  Outcome: Succeeded  Duration: 00:00:00  Date and time: 2017-07-07 04:00:01 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-07-07 04:00:01  Command: DECLARE @ReturnCode int EXECUTE @ReturnCode = [master].dbo.xp_delete_file 0, N'\\prodsrv01\W$\Backups\prodsrv01\W$\\HR\LOG', 'trn', '2017-07-02T16:00:01' IF @ReturnCode <> 0 RAISERROR('Error deleting files.', 16, 1) [SQLSTATE 01000] (Message 50000)  Outcome: Succeeded  Duration: 00:00:00  Date and time: 2017-07-07 04:00:01 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-07-07 04:00:01  Database: [ETL]  Status: ONLINE  Standby: No  Updateability: READ_WRITE  User access: MULTI_USER  Is accessible: Yes  Recovery model: FULL  Encrypted: No  Availability group: AccountingAG  Availability group role: PRIMARY  Availability group backup preference: PRIMARY  Is preferred backup replica: Yes  Differential base LSN: 31395000002376700096  Last log backup LSN: 31382000004030700001 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-07-07 04:00:01  Command: DECLARE @ReturnCode int EXECUTE @ReturnCode = [master].dbo.xp_create_subdir N'\\prodsrv01\W$\Back...  The step succeeded. | Enabled      | 2017-05-01 17:27:00.380 | 2017-05-26 23:13:35.970 | No description available. |         1 | Jul              |                       7 | Wk27                    |                             27 |                          103 |                         451 |            2017 | Current Calendar Year  | 2 Mo Prior Calendar Month | Other Calendar Week    | 2017-Jul         | 2017-Q3           |                             35 | 2017-Wk27        | 2017-07-07 00:00:00.000 | 2016-07-07 00:00:00.000    | 2017-06-07 00:00:00.000     |   20170707 |          3110 | Q2               |               6 | 2017-07-08 00:00:00.000     |              6 | Fri           | Friday    |                 445 | 2017-Wk23      | 2017-Q2         | 2017-P6            |                     112 |          2017 |                 23 |                   35 | 2016-07-08 00:00:00.000 |                    491 |                       3 | July 7, 2017            |                              7 |                           188 | Q3                         |                                 3 | Weekday             | Non-Holiday         |                        2 | 2016-09-11 00:00:00.000 | DST        |
| PRODSRV01 | Backup_USER_DATABASES - FULL             | (Job outcome)                                                 | Succeeded          | 2017-07-04 00:00:00.000 | 1899-12-30 00:30:00.000 |                     73 | The job succeeded.  The Job was invoked by Schedule 14 (Daily - Full Backups of User Databases).  The last step to run was step 1 (DatabaseBackup - USER_DATABASES - FULL).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | Enabled      | 2017-04-19 21:17:02.956 | 2017-05-16 01:58:22.846 | No description available. |         0 | Jul              |                       7 | Wk27                    |                             27 |                          103 |                         451 |            2017 | Current Calendar Year  | 2 Mo Prior Calendar Month | Other Calendar Week    | 2017-Jul         | 2017-Q3           |                             35 | 2017-Wk27        | 2017-07-04 00:00:00.000 | 2016-07-04 00:00:00.000    | 2017-06-04 00:00:00.000     |   20170704 |          3107 | Q2               |               6 | 2017-07-08 00:00:00.000     |              3 | Tue           | Tuesday   |                 445 | 2017-Wk23      | 2017-Q2         | 2017-P6            |                     112 |          2017 |                 23 |                   35 | 2016-07-05 00:00:00.000 |                    491 |                       3 | July 4, 2017            |                              4 |                           185 | Q3                         |                                 3 | Weekday             | Holiday             |                        2 | 2016-09-11 00:00:00.000 | DST        |
| PRODSRV01 | Match Accounts                           | Process Billing                                               | Succeeded          | 2017-07-03 00:00:00.000 | 1899-12-30 19:00:00.000 |                    120 | Executed as user: ProdAccount\DBA. The step succeeded.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        | Enabled      | 2017-04-22 04:24:43.666 | 2017-04-22 23:59:54.933 | No description available. |         1 | Jul              |                       7 | Wk27                    |                             27 |                          103 |                         451 |            2017 | Current Calendar Year  | 2 Mo Prior Calendar Month | Other Calendar Week    | 2017-Jul         | 2017-Q3           |                             35 | 2017-Wk27        | 2017-07-03 00:00:00.000 | 2016-07-03 00:00:00.000    | 2017-06-03 00:00:00.000     |   20170703 |          3106 | Q2               |               6 | 2017-07-08 00:00:00.000     |              2 | Mon           | Monday    |                 445 | 2017-Wk23      | 2017-Q2         | 2017-P6            |                     112 |          2017 |                 23 |                   35 | 2016-07-04 00:00:00.000 |                    491 |                       3 | July 3, 2017            |                              3 |                           184 | Q3                         |                                 3 | Weekday             | Non-Holiday         |                        2 | 2016-09-11 00:00:00.000 | DST        |
| PRODSRV01 | Backup_USER_DATABASES - FULL             | DatabaseBackup - USER_DATBASES - FULL                         | Succeeded          | 2017-07-01 00:00:00.000 | 1899-12-30 01:00:00.000 |                    298 | Executed as user: ProdAccount\DBA. ...13.0.4435.0  Edition: Enterprise Edition: Core-based Licensing (64-bit)  Procedure: [master].[dbo].[DatabaseBackup]  Parameters: @Databases = NULL, @Directory = '\\prodsrv01\W$\Backups', @BackupType = 'FULL', @Verify = 'Y', @CleanupTime = 96, @CleanupMode = 'AFTER_BACKUP', @Compress = NULL, @CopyOnly = 'N', @ChangeBackupType = 'N', @BackupSoftware = NULL, @CheckSum = 'Y', @BlockSize = NULL, @BufferCount = NULL, @MaxTransferSize = NULL, @NumberOfFiles = NULL, @CompressionLevel = NULL, @Description = NULL, @Threads = NULL, @Throttle = NULL, @Encrypt = 'N', @EncryptionAlgorithm = NULL, @ServerCertificate = NULL, @ServerAsymmetricKey = NULL, @EncryptionKey = NULL, @ReadWriteFileGroups = 'N', @OverrideBackupPreference = 'N', @NoRecovery = 'N', @URL = NULL, @Credential = NULL, @MirrorDirectory = NULL, @MirrorCleanupTime = NULL, @MirrorCleanupMode = 'AFTER_BACKUP', @AvailabilityGroups = 'ALL_AVAILABILITY_GROUPS', @Updateability = 'ALL', @LogToTable = 'Y', @Execute = 'Y'  Source: https://ola.hallengren.com [SQLSTATE 01000] (Message 50000)  Date and time: 2017-07-01 01:00:00  Database: [HR]  Status: ONLINE  Standby: No  Updateability: READ_WRITE  User access: MULTI_USER  Is accessible: Yes  Recovery model: FULL  Encrypted: No  Availability group: AccountingAG  Availability group role: PRIMARY  Availability group backup preference: PRIMARY  Is preferred backup replica: Yes  Differential base LSN: 36000000280500037  Last log backup LSN: 36000000287400001 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-07-01 01:00:00  Command: DECLARE @ReturnCode int EXECUTE @ReturnCode = [master].dbo.xp_create_subdir N'\\prodsrv01\W$\Backups\prodsrv01\W$\\HR\FULL' IF @ReturnCode <> 0 RAISERROR('Error creating directory.', 16, 1) [SQLSTATE 01000] (Message 50000)  Outcome: Succeeded  Duration: 00:00:00  Date and time: 2017-07-01 01:00:00 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-07-01 01:00:00  Command: BACKUP DATABASE [HR] TO DISK = N'\\prodsrv01\W$\Backups\prodsrv01\W$\\HR\FULL\prodsrv01\W$\_HR_FULL_20170701_010000.bak' WITH CHECKSUM, COMPRESSION [SQLSTATE 01000] (Message 50000)  Processed 360 pages for database 'HR', file 'HR' on file 1. [SQLSTATE 01000] (Message 4035)  Processed 2 pages for database 'HR', file 'HR_log' on file 1. [SQLSTATE 01000] (Message 4035)  BACKUP DATABASE successfully processed 362 pages in 4.833 seconds (0.584 MB/sec). [SQLSTATE 01000] (Message 3014)  Outcome: Succeeded  Duration: 00:00:13  Date and time: 2017-07-01 01:00:13 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-07-01 01:00:13  Command: RESTORE VERIFYONLY FROM DISK = N'\\prodsrv01\W$\Backups\prodsrv01\W$\\HR\FULL\prodsrv01\W$\_HR_FULL_20170701_010000.bak' WITH CHECKSUM [SQLSTATE 01000] (Message 50000)  The backup set on file 1 is valid. [SQLSTATE 01000] (Message 3262)  Outcome: Succeeded  Duration: 00:00:00  Date and time: 2017-07-01 01:00:13 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-07-01 01:00:13  Command: DECLARE @ReturnCode int EXECUTE @ReturnCode = [master].dbo.xp_delete_file 0, N'\\prodsrv01\W$\Backups\prodsrv01\W$\\HR\FULL', 'bak', '2017-06-27T01:00:13' IF @ReturnCode <> 0 RAISERROR('Error deleting files.', 16, 1) [SQLSTATE 01000] (Message 50000)  Outcome: Succeeded  Duration: 00:00:01  Date and time: 2017-07-01 01:00:14 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-07-01 01:00:14  Database: [ETL]  Status: ONLINE  Standby: No  Updateability: READ_WRITE  User access: MULTI_USER  Is accessible: Yes  Recovery model: FULL  Encrypted: No  Availability group: AccountingAG  Availability group role: PRIMARY  Availability group backup preference: PRIMARY  Is preferred backup replica: Yes  Differential base LSN: 31365000001816600050  Last log backup LSN: 31365000001830600001 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-0...  The step succeeded.           | Enabled      | 2017-04-24 17:10:45.000 | 2017-06-18 01:26:21.536 | No description available. |         1 | Jul              |                       7 | Wk26                    |                             26 |                          103 |                         450 |            2017 | Current Calendar Year  | 2 Mo Prior Calendar Month | Other Calendar Week    | 2017-Jul         | 2017-Q3           |                             35 | 2017-Wk26        | 2017-07-01 00:00:00.000 | 2016-07-01 00:00:00.000    | 2017-06-01 00:00:00.000     |   20170701 |          3104 | Q2               |               6 | 2017-07-01 00:00:00.000     |              7 | Sat           | Saturday  |                 444 | 2017-Wk22      | 2017-Q2         | 2017-P6            |                     112 |          2017 |                 22 |                   35 | 2016-07-02 00:00:00.000 |                    490 |                       2 | July 1, 2017            |                              1 |                           182 | Q3                         |                                 3 | Weekend             | Non-Holiday         |                        1 | 2016-09-11 00:00:00.000 | DST        |
| PRODSRV01 | Backup_USER_DATABASES - FULL             | (Job outcome)                                                 | Succeeded          | 2017-07-12 00:00:00.000 | 1899-12-30 00:30:00.000 |                     77 | The job succeeded.  The Job was invoked by Schedule 14 (Daily - Full Backups of User Databases).  The last step to run was step 1 (DatabaseBackup - USER_DATABASES - FULL).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | Enabled      | 2017-04-19 21:17:02.956 | 2017-05-16 01:58:22.846 | No description available. |         0 | Jul              |                       7 | Wk28                    |                             28 |                          103 |                         452 |            2017 | Current Calendar Year  | 2 Mo Prior Calendar Month | Other Calendar Week    | 2017-Jul         | 2017-Q3           |                             35 | 2017-Wk28        | 2017-07-12 00:00:00.000 | 2016-07-12 00:00:00.000    | 2017-06-12 00:00:00.000     |   20170712 |          3115 | Q2               |               6 | 2017-07-15 00:00:00.000     |              4 | Wed           | Wednesday |                 446 | 2017-Wk24      | 2017-Q2         | 2017-P6            |                     112 |          2017 |                 24 |                   35 | 2016-07-13 00:00:00.000 |                    492 |                       4 | July 12, 2017           |                             12 |                           193 | Q3                         |                                 3 | Weekday             | Non-Holiday         |                        3 | 2016-09-11 00:00:00.000 | DST        |
| PRODSRV01 | Capture Perf Stats                       | Find report info and log it                                   | Succeeded          | 2017-07-14 00:00:00.000 | 1899-12-30 11:00:00.000 |                      4 | Executed as user: ProdAccount\DBA. The step succeeded.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        | Enabled      | 2017-04-22 04:24:31.260 | 2017-05-17 19:44:45.240 | No description available. |         1 | Jul              |                       7 | Wk28                    |                             28 |                          103 |                         452 |            2017 | Current Calendar Year  | 2 Mo Prior Calendar Month | Other Calendar Week    | 2017-Jul         | 2017-Q3           |                             35 | 2017-Wk28        | 2017-07-14 00:00:00.000 | 2016-07-14 00:00:00.000    | 2017-06-14 00:00:00.000     |   20170714 |          3117 | Q2               |               6 | 2017-07-15 00:00:00.000     |              6 | Fri           | Friday    |                 446 | 2017-Wk24      | 2017-Q2         | 2017-P6            |                     112 |          2017 |                 24 |                   35 | 2016-07-15 00:00:00.000 |                    492 |                       4 | July 14, 2017           |                             14 |                           195 | Q3                         |                                 3 | Weekday             | Non-Holiday         |                        3 | 2016-09-11 00:00:00.000 | DST        |
| PRODSRV01 | Backup_USER_DATABASES - FULL             | (Job outcome)                                                 | Succeeded          | 2017-07-07 00:00:00.000 | 1899-12-30 00:00:00.000 |                      1 | The job succeeded.  The Job was invoked by Schedule 15 (Every 4 hours - Transaction Log Backups User Databases).  The last step to run was step 1 (DatabaseBackup - USER_DATABASES_AG - LOG).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | Enabled      | 2017-05-01 17:27:00.380 | 2017-05-26 23:13:35.970 | No description available. |         0 | Jul              |                       7 | Wk27                    |                             27 |                          103 |                         451 |            2017 | Current Calendar Year  | 2 Mo Prior Calendar Month | Other Calendar Week    | 2017-Jul         | 2017-Q3           |                             35 | 2017-Wk27        | 2017-07-07 00:00:00.000 | 2016-07-07 00:00:00.000    | 2017-06-07 00:00:00.000     |   20170707 |          3110 | Q2               |               6 | 2017-07-08 00:00:00.000     |              6 | Fri           | Friday    |                 445 | 2017-Wk23      | 2017-Q2         | 2017-P6            |                     112 |          2017 |                 23 |                   35 | 2016-07-08 00:00:00.000 |                    491 |                       3 | July 7, 2017            |                              7 |                           188 | Q3                         |                                 3 | Weekday             | Non-Holiday         |                        2 | 2016-09-11 00:00:00.000 | DST        |
| PRODSRV01 | DBMaint_IntegrityCheck                   | (Job outcome)                                                 | Succeeded          | 2017-07-01 00:00:00.000 | 1899-12-30 04:00:00.000 |                     18 | The job succeeded.  The Job was invoked by Schedule 59 (Weekly - User DB Integrity Check).  The last step to run was step 1 (DatabaseIntegrityCheck - USER_DATABASES_AG).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | Enabled      | 2017-05-17 17:04:02.040 | 2017-05-17 17:04:02.050 | No description available. |         0 | Jul              |                       7 | Wk26                    |                             26 |                          103 |                         450 |            2017 | Current Calendar Year  | 2 Mo Prior Calendar Month | Other Calendar Week    | 2017-Jul         | 2017-Q3           |                             35 | 2017-Wk26        | 2017-07-01 00:00:00.000 | 2016-07-01 00:00:00.000    | 2017-06-01 00:00:00.000     |   20170701 |          3104 | Q2               |               6 | 2017-07-01 00:00:00.000     |              7 | Sat           | Saturday  |                 444 | 2017-Wk22      | 2017-Q2         | 2017-P6            |                     112 |          2017 |                 22 |                   35 | 2016-07-02 00:00:00.000 |                    490 |                       2 | July 1, 2017            |                              1 |                           182 | Q3                         |                                 3 | Weekend             | Non-Holiday         |                        1 | 2016-09-11 00:00:00.000 | DST        |
| PRODSRV01 | Backup_USER_DATABASES - FULL             | DatabaseBackup - USER_DATABASES - FULL                        | Succeeded          | 2017-05-30 00:00:00.000 | 1899-12-30 00:30:00.000 |                     92 | Executed as user: ProdAccount\DBA. ...13.0.4422.0  Edition: Enterprise Edition: Core-based Licensing (64-bit)  Procedure: [master].[dbo].[DatabaseBackup]  Parameters: @Databases = 'USER_DATABASES, -AVAILABILITY_GROUP_DATABASES', @Directory = '\\prodsrv01\W$\Backups', @BackupType = 'FULL', @Verify = 'Y', @CleanupTime = 70, @CleanupMode = 'AFTER_BACKUP', @Compress = NULL, @CopyOnly = 'N', @ChangeBackupType = 'N', @BackupSoftware = NULL, @CheckSum = 'Y', @BlockSize = NULL, @BufferCount = NULL, @MaxTransferSize = NULL, @NumberOfFiles = NULL, @CompressionLevel = NULL, @Description = NULL, @Threads = NULL, @Throttle = NULL, @Encrypt = 'N', @EncryptionAlgorithm = NULL, @ServerCertificate = NULL, @ServerAsymmetricKey = NULL, @EncryptionKey = NULL, @ReadWriteFileGroups = 'N', @OverrideBackupPreference = 'N', @NoRecovery = 'N', @URL = NULL, @Credential = NULL, @MirrorDirectory = NULL, @MirrorCleanupTime = NULL, @MirrorCleanupMode = 'AFTER_BACKUP', @AvailabilityGroups = NULL, @Updateability = 'ALL', @LogToTable = 'Y', @Execute = 'Y'  Source: https://ola.hallengren.com     Date and time: 2017-05-30 00:30:01  Database: [Admin]  Status: ONLINE  Standby: No  Updateability: READ_WRITE  User access: MULTI_USER  Is accessible: Yes  Recovery model: FULL  Encrypted: No  Differential base LSN: 2370000009660600039  Last log backup LSN: 2372000010643700001     Date and time: 2017-05-30 00:30:01  Command: DECLARE @ReturnCode int EXECUTE @ReturnCode = [master].dbo.xp_create_subdir N'\\prodsrv01\W$\Backups\PRODSRV01\Admin\FULL' IF @ReturnCode <> 0 RAISERROR('Error creating directory.', 16, 1)  Outcome: Succeeded  Duration: 00:00:00  Date and time: 2017-05-30 00:30:01     Date and time: 2017-05-30 00:30:01  Command: BACKUP DATABASE [Admin] TO DISK = N'\\prodsrv01\W$\Backups\PRODSRV01\Admin\FULL\PRODSRV01_AdminFULL_20170530_003001.bak' WITH CHECKSUM, COMPRESSION  Processed 163288 pages for database 'Admin', file 'Admin' on file 1.  Processed 2 pages for database 'Admin', file 'Adminlog' on file 1.  BACKUP DATABASE successfully processed 163290 pages in 11.262 seconds (113.274 MB/sec).  Outcome: Succeeded  Duration: 00:00:13  Date and time: 2017-05-30 00:30:14     Date and time: 2017-05-30 00:30:14  Command: RESTORE VERIFYONLY FROM DISK = N'\\prodsrv01\W$\Backups\PRODSRV01\Admin\FULL\PRODSRV01_AdminFULL_20170530_003001.bak' WITH CHECKSUM  The backup set on file 1 is valid.  Outcome: Succeeded  Duration: 00:00:06  Date and time: 2017-05-30 00:30:20     Date and time: 2017-05-30 00:30:20  Command: DECLARE @ReturnCode int EXECUTE @ReturnCode = [master].dbo.xp_delete_file 0, N'\\prodsrv01\W$\Backups\PRODSRV01\Admin\FULL', 'bak', '2017-05-27T02:30:20' IF @ReturnCode <> 0 RAISERROR('Error deleting files.', 16, 1)  Outcome: Succeeded  Duration: 00:00:00  Date and time: 2017-05-30 00:30:20     Date and time: 2017-05-30 00:30:20  Database: [Prod_Accounts_Archived]  Status: ONLINE  Standby: No  Updateability: READ_WRITE  User access: MULTI_USER  Is accessible: Yes  Recovery model: FULL  Encrypted: No  Differential base LSN: 10808000017447700037  Last log backup LSN: 10808000017457700001     Date and time: 2017-05-30 00:30:20  Command: DECLARE @ReturnCode int EXECUTE @ReturnCode = [master].dbo.xp_create_subdir N'\\prodsrv01\W$\Backups\PRODSRV01\Prod_Accounts_Archived\FULL' IF @ReturnCode <> 0 RAISERROR('Error creating directory.', 16, 1)  Outcome: Succeeded  Duration: 00:00:00  Date and time: 2017-05-30 00:30:20     Date and time: 2017-05-30 00:30:20  Command: BACKUP DATABASE [Prod_Accounts_Archived] TO DISK = N'\\prodsrv01\W$\Backups\PRODSRV01\Prod_Accounts_Archived\FULL\PRODSRV01_Prod_Accounts_Archived_FULL_20170530_003020.bak' WITH CHECKSUM, COMPRESSION  Processed 67744 pages for database 'Prod_Accounts_Archived', file 'acctRe...  Process Exit Code 0.  The step succeeded.                                                                 | Enabled      | 2017-04-19 21:17:02.956 | 2017-05-16 01:58:22.846 | No description available. |         1 | May              |                       5 | Wk22                    |                             22 |                          101 |                         446 |            2017 | Current Calendar Year  | Other Calendar Month      | Other Calendar Week    | 2017-May         | 2017-Q2           |                             34 | 2017-Wk22        | 2017-05-30 00:00:00.000 | 2016-05-30 00:00:00.000    | 2017-04-30 00:00:00.000     |   20170530 |          3072 | Q2               |               5 | 2017-06-03 00:00:00.000     |              3 | Tue           | Tuesday   |                 440 | 2017-Wk18      | 2017-Q2         | 2017-P5            |                     111 |          2017 |                 18 |                   35 | 2016-05-31 00:00:00.000 |                    486 |                       2 | May 30, 2017            |                             30 |                           150 | Q2                         |                                 2 | Weekday             | Non-Holiday         |                        5 | 2016-09-11 00:00:00.000 | DST        |
| PRODSRV01 | Match Accounts                           | (Job outcome)                                                 | Succeeded          | 2017-07-05 00:00:00.000 | 1899-12-30 01:00:00.000 |                    115 | The job succeeded.  The Job was invoked by Schedule 51 (FixAccounts).  The last step to run was step 1 (FixAccounts).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         | Enabled      | 2017-04-22 04:24:43.666 | 2017-04-22 23:59:54.933 | No description available. |         0 | Jul              |                       7 | Wk27                    |                             27 |                          103 |                         451 |            2017 | Current Calendar Year  | 2 Mo Prior Calendar Month | Other Calendar Week    | 2017-Jul         | 2017-Q3           |                             35 | 2017-Wk27        | 2017-07-05 00:00:00.000 | 2016-07-05 00:00:00.000    | 2017-06-05 00:00:00.000     |   20170705 |          3108 | Q2               |               6 | 2017-07-08 00:00:00.000     |              4 | Wed           | Wednesday |                 445 | 2017-Wk23      | 2017-Q2         | 2017-P6            |                     112 |          2017 |                 23 |                   35 | 2016-07-06 00:00:00.000 |                    491 |                       3 | July 5, 2017            |                              5 |                           186 | Q3                         |                                 3 | Weekday             | Non-Holiday         |                        2 | 2016-09-11 00:00:00.000 | DST        |
| PRODSRV01 | DBMaint_IntegrityCheck                   | (Job outcome)                                                 | Succeeded          | 2017-07-08 00:00:00.000 | 1899-12-30 04:00:00.000 |                     19 | The job succeeded.  The Job was invoked by Schedule 59 (Weekly - User DB Integrity Check).  The last step to run was step 1 (DatabaseIntegrityCheck - USER_DATABASES_AG).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | Enabled      | 2017-05-17 17:04:02.040 | 2017-05-17 17:04:02.050 | No description available. |         0 | Jul              |                       7 | Wk27                    |                             27 |                          103 |                         451 |            2017 | Current Calendar Year  | 2 Mo Prior Calendar Month | Other Calendar Week    | 2017-Jul         | 2017-Q3           |                             35 | 2017-Wk27        | 2017-07-08 00:00:00.000 | 2016-07-08 00:00:00.000    | 2017-06-08 00:00:00.000     |   20170708 |          3111 | Q2               |               6 | 2017-07-08 00:00:00.000     |              7 | Sat           | Saturday  |                 445 | 2017-Wk23      | 2017-Q2         | 2017-P6            |                     112 |          2017 |                 23 |                   35 | 2016-07-09 00:00:00.000 |                    491 |                       3 | July 8, 2017            |                              8 |                           189 | Q3                         |                                 3 | Weekend             | Non-Holiday         |                        2 | 2016-09-11 00:00:00.000 | DST        |
| PRODSRV01 | Capture Perf Stats                       | Find report info and log it                                   | Succeeded          | 2017-07-14 00:00:00.000 | 1899-12-30 18:30:00.000 |                      4 | Executed as user: ProdAccount\DBA. The step succeeded.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        | Enabled      | 2017-04-22 04:24:31.260 | 2017-05-17 19:44:45.240 | No description available. |         1 | Jul              |                       7 | Wk28                    |                             28 |                          103 |                         452 |            2017 | Current Calendar Year  | 2 Mo Prior Calendar Month | Other Calendar Week    | 2017-Jul         | 2017-Q3           |                             35 | 2017-Wk28        | 2017-07-14 00:00:00.000 | 2016-07-14 00:00:00.000    | 2017-06-14 00:00:00.000     |   20170714 |          3117 | Q2               |               6 | 2017-07-15 00:00:00.000     |              6 | Fri           | Friday    |                 446 | 2017-Wk24      | 2017-Q2         | 2017-P6            |                     112 |          2017 |                 24 |                   35 | 2016-07-15 00:00:00.000 |                    492 |                       4 | July 14, 2017           |                             14 |                           195 | Q3                         |                                 3 | Weekday             | Non-Holiday         |                        3 | 2016-09-11 00:00:00.000 | DST        |
| PRODSRV01 | Capture Hourly Baselines                 | Capture Stats                                                 | Succeeded          | 2017-05-23 00:00:00.000 | 1899-12-30 13:30:26.000 |                      2 | Executed as user: ProdAccount\DBA. The step succeeded.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        | Disabled     | 2017-04-22 04:24:25.020 | 2017-04-22 04:25:07.640 | No description available. |         4 | May              |                       5 | Wk21                    |                             21 |                          101 |                         445 |            2017 | Current Calendar Year  | Other Calendar Month      | Other Calendar Week    | 2017-May         | 2017-Q2           |                             34 | 2017-Wk21        | 2017-05-23 00:00:00.000 | 2016-05-23 00:00:00.000    | 2017-04-23 00:00:00.000     |   20170523 |          3065 | Q2               |               5 | 2017-05-27 00:00:00.000     |              3 | Tue           | Tuesday   |                 439 | 2017-Wk17      | 2017-Q2         | 2017-P5            |                     111 |          2017 |                 17 |                   35 | 2016-05-24 00:00:00.000 |                    485 |                       1 | May 23, 2017            |                             23 |                           143 | Q2                         |                                 2 | Weekday             | Non-Holiday         |                        4 | 2016-09-11 00:00:00.000 | DST        |
| PRODSRV01 | Backup_USER_DATABASES - FULL             | (Job outcome)                                                 | Succeeded          | 2017-06-22 00:00:00.000 | 1899-12-30 00:30:00.000 |                     97 | The job succeeded.  The Job was invoked by Schedule 14 (Daily - Full Backups of User Databases).  The last step to run was step 1 (DatabaseBackup - USER_DATABASES - FULL).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | Enabled      | 2017-04-19 21:17:02.956 | 2017-05-16 01:58:22.846 | No description available. |         0 | Jun              |                       6 | Wk25                    |                             25 |                          102 |                         449 |            2017 | Current Calendar Year  | 3 Mo Prior Calendar Month | Other Calendar Week    | 2017-Jun         | 2017-Q2           |                             34 | 2017-Wk25        | 2017-06-22 00:00:00.000 | 2016-06-22 00:00:00.000    | 2017-05-22 00:00:00.000     |   20170622 |          3095 | Q2               |               6 | 2017-06-24 00:00:00.000     |              5 | Thu           | Thursday  |                 443 | 2017-Wk21      | 2017-Q2         | 2017-P6            |                     112 |          2017 |                 21 |                   35 | 2016-06-23 00:00:00.000 |                    489 |                       1 | June 22, 2017           |                             22 |                           173 | Q2                         |                                 2 | Weekday             | Non-Holiday         |                        4 | 2016-09-11 00:00:00.000 | DST        |
| PRODSRV01 | DBMaint_IntegrityCheck - USER_DATABASES1 | (Job outcome)                                                 | Succeeded          | 2017-07-01 00:00:00.000 | 1899-12-30 04:00:00.000 |                     45 | The job succeeded.  The Job was invoked by Schedule 59 (Weekly - User DB Integrity Check).  The last step to run was step 1 (DatabaseIntegrityCheck - USER_DATABASES).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        | Enabled      | 2017-04-19 21:17:03.016 | 2017-05-17 17:01:32.346 | No description available. |         0 | Jul              |                       7 | Wk26                    |                             26 |                          103 |                         450 |            2017 | Current Calendar Year  | 2 Mo Prior Calendar Month | Other Calendar Week    | 2017-Jul         | 2017-Q3           |                             35 | 2017-Wk26        | 2017-07-01 00:00:00.000 | 2016-07-01 00:00:00.000    | 2017-06-01 00:00:00.000     |   20170701 |          3104 | Q2               |               6 | 2017-07-01 00:00:00.000     |              7 | Sat           | Saturday  |                 444 | 2017-Wk22      | 2017-Q2         | 2017-P6            |                     112 |          2017 |                 22 |                   35 | 2016-07-02 00:00:00.000 |                    490 |                       2 | July 1, 2017            |                              1 |                           182 | Q3                         |                                 3 | Weekend             | Non-Holiday         |                        1 | 2016-09-11 00:00:00.000 | DST        |
| PRODSRV01 | Match Accounts                           | Process Billing                                               | Succeeded          | 2017-07-08 00:00:00.000 | 1899-12-30 19:00:00.000 |                    112 | Executed as user: ProdAccount\DBA. The step succeeded.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        | Enabled      | 2017-04-22 04:24:43.666 | 2017-04-22 23:59:54.933 | No description available. |         1 | Jul              |                       7 | Wk27                    |                             27 |                          103 |                         451 |            2017 | Current Calendar Year  | 2 Mo Prior Calendar Month | Other Calendar Week    | 2017-Jul         | 2017-Q3           |                             35 | 2017-Wk27        | 2017-07-08 00:00:00.000 | 2016-07-08 00:00:00.000    | 2017-06-08 00:00:00.000     |   20170708 |          3111 | Q2               |               6 | 2017-07-08 00:00:00.000     |              7 | Sat           | Saturday  |                 445 | 2017-Wk23      | 2017-Q2         | 2017-P6            |                     112 |          2017 |                 23 |                   35 | 2016-07-09 00:00:00.000 |                    491 |                       3 | July 8, 2017            |                              8 |                           189 | Q3                         |                                 3 | Weekend             | Non-Holiday         |                        2 | 2016-09-11 00:00:00.000 | DST        |
| PRODSRV01 | DBMaint_UpdateStats_Manual               | Update stats with FULLSCAN for select tables                  | Succeeded          | 2017-06-04 00:00:00.000 | 1899-12-30 20:00:00.000 |                      3 | Executed as user: ProdAccount\DBA. The step succeeded.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        | Enabled      | 2017-04-22 04:22:08.163 | 2017-07-13 00:54:41.016 | No description available. |         1 | Jun              |                       6 | Wk23                    |                             23 |                          102 |                         447 |            2017 | Current Calendar Year  | 3 Mo Prior Calendar Month | Other Calendar Week    | 2017-Jun         | 2017-Q2           |                             34 | 2017-Wk23        | 2017-06-04 00:00:00.000 | 2016-06-04 00:00:00.000    | 2017-05-04 00:00:00.000     |   20170604 |          3077 | Q2               |               5 | 2017-06-10 00:00:00.000     |              1 | Sun           | Sunday    |                 441 | 2017-Wk19      | 2017-Q2         | 2017-P5            |                     111 |          2017 |                 19 |                   35 | 2016-06-05 00:00:00.000 |                    487 |                       3 | June 4, 2017            |                              4 |                           155 | Q2                         |                                 2 | Weekend             | Non-Holiday         |                        2 | 2016-09-11 00:00:00.000 | DST        |
| PRODSRV01 | DBMaint_OptimizeIndexes                  | (Job outcome)                                                 | Succeeded          | 2017-06-22 00:00:00.000 | 1899-12-30 20:00:00.000 |                    248 | The job succeeded.  The Job was invoked by Schedule 30 (Daily Index and Stats Maintenance_New).  The last step to run was step 3 (Update stats for selected tables).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | Enabled      | 2017-04-22 04:22:14.693 | 2017-06-14 00:54:16.890 | No description available. |         0 | Jun              |                       6 | Wk25                    |                             25 |                          102 |                         449 |            2017 | Current Calendar Year  | 3 Mo Prior Calendar Month | Other Calendar Week    | 2017-Jun         | 2017-Q2           |                             34 | 2017-Wk25        | 2017-06-22 00:00:00.000 | 2016-06-22 00:00:00.000    | 2017-05-22 00:00:00.000     |   20170622 |          3095 | Q2               |               6 | 2017-06-24 00:00:00.000     |              5 | Thu           | Thursday  |                 443 | 2017-Wk21      | 2017-Q2         | 2017-P6            |                     112 |          2017 |                 21 |                   35 | 2016-06-23 00:00:00.000 |                    489 |                       1 | June 22, 2017           |                             22 |                           173 | Q2                         |                                 2 | Weekday             | Non-Holiday         |                        4 | 2016-09-11 00:00:00.000 | DST        |
| PRODSRV01 | Capture Hourly Baselines                 | (Job outcome)                                                 | Succeeded          | 2017-06-02 00:00:00.000 | 1899-12-30 15:33:59.000 |                      2 | The job succeeded.  The Job was invoked by User ProdAccount\DBA.  The last step to run was step 4 (Capture Wait stats).  The job was requested to start at step 4 (Capture Wait stats).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       | Disabled     | 2017-04-22 04:24:25.020 | 2017-04-22 04:25:07.640 | No description available. |         0 | Jun              |                       6 | Wk22                    |                             22 |                          102 |                         446 |            2017 | Current Calendar Year  | 3 Mo Prior Calendar Month | Other Calendar Week    | 2017-Jun         | 2017-Q2           |                             34 | 2017-Wk22        | 2017-06-02 00:00:00.000 | 2016-06-02 00:00:00.000    | 2017-05-02 00:00:00.000     |   20170602 |          3075 | Q2               |               5 | 2017-06-03 00:00:00.000     |              6 | Fri           | Friday    |                 440 | 2017-Wk18      | 2017-Q2         | 2017-P5            |                     111 |          2017 |                 18 |                   35 | 2016-06-03 00:00:00.000 |                    486 |                       2 | June 2, 2017            |                              2 |                           153 | Q2                         |                                 2 | Weekday             | Non-Holiday         |                        1 | 2016-09-11 00:00:00.000 | DST        |
| PRODSRV01 | Match Accounts                           | (Job outcome)                                                 | Succeeded          | 2017-07-03 00:00:00.000 | 1899-12-30 13:00:00.000 |                    116 | The job succeeded.  The Job was invoked by Schedule 51 (FixAccounts).  The last step to run was step 1 (FixAccounts).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         | Enabled      | 2017-04-22 04:24:43.666 | 2017-04-22 23:59:54.933 | No description available. |         0 | Jul              |                       7 | Wk27                    |                             27 |                          103 |                         451 |            2017 | Current Calendar Year  | 2 Mo Prior Calendar Month | Other Calendar Week    | 2017-Jul         | 2017-Q3           |                             35 | 2017-Wk27        | 2017-07-03 00:00:00.000 | 2016-07-03 00:00:00.000    | 2017-06-03 00:00:00.000     |   20170703 |          3106 | Q2               |               6 | 2017-07-08 00:00:00.000     |              2 | Mon           | Monday    |                 445 | 2017-Wk23      | 2017-Q2         | 2017-P6            |                     112 |          2017 |                 23 |                   35 | 2016-07-04 00:00:00.000 |                    491 |                       3 | July 3, 2017            |                              3 |                           184 | Q3                         |                                 3 | Weekday             | Non-Holiday         |                        2 | 2016-09-11 00:00:00.000 | DST        |
| PRODSRV01 | Backup_USER_DATABASES - FULL             | (Job outcome)                                                 | Succeeded          | 2017-07-01 00:00:00.000 | 1899-12-30 00:30:00.000 |                     92 | The job succeeded.  The Job was invoked by Schedule 14 (Daily - Full Backups of User Databases).  The last step to run was step 1 (DatabaseBackup - USER_DATABASES - FULL).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | Enabled      | 2017-04-19 21:17:02.956 | 2017-05-16 01:58:22.846 | No description available. |         0 | Jul              |                       7 | Wk26                    |                             26 |                          103 |                         450 |            2017 | Current Calendar Year  | 2 Mo Prior Calendar Month | Other Calendar Week    | 2017-Jul         | 2017-Q3           |                             35 | 2017-Wk26        | 2017-07-01 00:00:00.000 | 2016-07-01 00:00:00.000    | 2017-06-01 00:00:00.000     |   20170701 |          3104 | Q2               |               6 | 2017-07-01 00:00:00.000     |              7 | Sat           | Saturday  |                 444 | 2017-Wk22      | 2017-Q2         | 2017-P6            |                     112 |          2017 |                 22 |                   35 | 2016-07-02 00:00:00.000 |                    490 |                       2 | July 1, 2017            |                              1 |                           182 | Q3                         |                                 3 | Weekend             | Non-Holiday         |                        1 | 2016-09-11 00:00:00.000 | DST        |
| PRODSRV01 | Backup_USER_DATABASES - FULL             | (Job outcome)                                                 | Succeeded          | 2017-07-07 00:00:00.000 | 1899-12-30 04:00:00.000 |                      2 | The job succeeded.  The Job was invoked by Schedule 15 (Every 4 hours - Transaction Log Backups User Databases).  The last step to run was step 1 (DatabaseBackup - USER_DATABASES_AG - LOG).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | Enabled      | 2017-05-01 17:27:00.380 | 2017-05-26 23:13:35.970 | No description available. |         0 | Jul              |                       7 | Wk27                    |                             27 |                          103 |                         451 |            2017 | Current Calendar Year  | 2 Mo Prior Calendar Month | Other Calendar Week    | 2017-Jul         | 2017-Q3           |                             35 | 2017-Wk27        | 2017-07-07 00:00:00.000 | 2016-07-07 00:00:00.000    | 2017-06-07 00:00:00.000     |   20170707 |          3110 | Q2               |               6 | 2017-07-08 00:00:00.000     |              6 | Fri           | Friday    |                 445 | 2017-Wk23      | 2017-Q2         | 2017-P6            |                     112 |          2017 |                 23 |                   35 | 2016-07-08 00:00:00.000 |                    491 |                       3 | July 7, 2017            |                              7 |                           188 | Q3                         |                                 3 | Weekday             | Non-Holiday         |                        2 | 2016-09-11 00:00:00.000 | DST        |
| PRODSRV01 | DBMaint_OptimizeIndexes                  | Remove fragmentation and update statistics for most tables    | Succeeded          | 2017-07-01 00:00:00.000 | 1899-12-30 20:00:00.000 |                    190 | Executed as user: ProdAccount\DBA. ...13.0.4435.0  Edition: Enterprise Edition: Core-based Licensing (64-bit)  Procedure: [master].[dbo].[IndexOptimize]  Parameters: @Databases = 'Prod_Accounts', @FragmentationLow = NULL, @FragmentationMedium = 'INDEX_REORGANIZE', @FragmentationHigh = 'INDEX_REORGANIZE', @FragmentationLevel1 = 5, @FragmentationLevel2 = 30, @PageCountLevel = 1000, @SortInTempdb = 'Y', @MaxDOP = 8, @FillFactor = NULL, @PadIndex = NULL, @LOBCompaction = 'N', @UpdateStatistics = 'ALL', @OnlyModifiedStatistics = 'Y', @StatisticsSample = NULL, @StatisticsResample = 'N', @PartitionLevel = 'Y', @MSShippedObjects = 'N', @Indexes = 'ALL_INDEXES,-Prod_Accounts.dbo.AccountData,-Prod_Accounts.dbo.AccountDataHistory,-Prod_Accounts.dbo.AccountDataOwner,-Prod_Accounts.dbo.OldAccount,-Prod_Accounts.dbo.CompanyData,-Prod_Accounts.dbo.Archived_OldAccount, -Prod_Accounts.dbo.AccountStatus, -Prod_Accounts.dbo.History,-Prod_Accounts.dbo.Customers,-Prod_Accounts.dbo.Banks,-Prod_Accounts.dbo.Billing,-Prod_Accounts.dbo.BillingCharacteristic,-Prod_Accounts.dbo.BankHistory', @TimeLimit = 3600, @Delay = NULL, @WaitAtLowPriorityMaxDuration = NULL, @WaitAtLowPriorityAbortAfterWait = NULL, @AvailabilityGroups = NULL, @LockTimeout = NULL, @LogToTable = 'Y', @Execute = 'Y'  Source: https://ola.hallengren.com [SQLSTATE 01000] (Message 50000)  Date and time: 2017-07-01 20:00:01  Database: [Prod_Accounts]  Status: ONLINE  Standby: No  Updateability: READ_WRITE  User access: MULTI_USER  Is accessible: Yes  Recovery model: FULL  Availability group: AccountingAG  Availability group role: PRIMARY [SQLSTATE 01000] (Message 50000)  Date and time: 2017-07-01 20:00:14  Command: UPDATE STATISTICS [Prod_Accounts].[dbo].[_dta_mv_6] [_dta_index__dta_mv_6_c_7_1641629487__K1_K4_K6_K7] [SQLSTATE 01000] (Message 50000)  Outcome: Succeeded  Duration: 00:00:01  Date and time: 2017-07-01 20:00:15 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-07-01 20:00:21  Command: ALTER INDEX [_dta_index__dta_mv_6_7_1641629487__K2] ON [Prod_Accounts].[dbo].[_dta_mv_6] REORGANIZE WITH (LOB_COMPACTION = OFF)  Comment: ObjectType: View, IndexType: NonClustered, ImageText: N/A, NewLOB: No, FileStream: N/A, ColumnStore: No, AllowPageLocks: Yes, PageCount: 138528, Fragmentation: 6.14749 [SQLSTATE 01000] (Message 50000)  Outcome: Succeeded  Duration: 00:02:08  Date and time: 2017-07-01 20:02:29 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-07-01 20:02:29  Command: UPDATE STATISTICS [Prod_Accounts].[dbo].[_dta_mv_6] [_dta_index__dta_mv_6_7_1641629487__K2] [SQLSTATE 01000] (Message 50000)  Outcome: Succeeded  Duration: 00:00:01  Date and time: 2017-07-01 20:02:30 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-07-01 20:02:31  Command: UPDATE STATISTICS [Prod_Accounts].[dbo].[AccountDataNullUpdate] [_WA_Sys_00000002_0597B782] [SQLSTATE 01000] (Message 50000)  Outcome: Succeeded  Duration: 00:00:00  Date and time: 2017-07-01 20:02:31 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-07-01 20:02:31  Command: UPDATE STATISTICS [Prod_Accounts].[dbo].[AccountDataNullUpdate] [_WA_Sys_00000003_0597B782] [SQLSTATE 01000] (Message 50000)  Outcome: Succeeded  Duration: 00:00:01  Date and time: 2017-07-01 20:02:32 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-07-01 20:02:32  Command: UPDATE STATISTICS [Prod_Accounts].[dbo].[tblAuthorizedAgent] [PK_tblAuthorizedAgent] [SQLSTATE 01000] (Message 50000)  Outcome: Succeeded  Duration: 00:00:00  Date and time: 2017-07-01 20:02:32 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-07-01 20:02:32  Command: UPDATE STATISTICS [Prod_Accounts].[dbo].[tblAuthorizedAgent] [_dta_index_tblAuthorizedAgent_5_69575286__K1_K2_K5] [SQLSTATE 01000] (Message 50000)  Outcome: Succeeded  Dur...  The step succeeded.                                                                                                 | Enabled      | 2017-04-22 04:22:14.693 | 2017-06-14 00:54:16.890 | No description available. |         1 | Jul              |                       7 | Wk26                    |                             26 |                          103 |                         450 |            2017 | Current Calendar Year  | 2 Mo Prior Calendar Month | Other Calendar Week    | 2017-Jul         | 2017-Q3           |                             35 | 2017-Wk26        | 2017-07-01 00:00:00.000 | 2016-07-01 00:00:00.000    | 2017-06-01 00:00:00.000     |   20170701 |          3104 | Q2               |               6 | 2017-07-01 00:00:00.000     |              7 | Sat           | Saturday  |                 444 | 2017-Wk22      | 2017-Q2         | 2017-P6            |                     112 |          2017 |                 22 |                   35 | 2016-07-02 00:00:00.000 |                    490 |                       2 | July 1, 2017            |                              1 |                           182 | Q3                         |                                 3 | Weekend             | Non-Holiday         |                        1 | 2016-09-11 00:00:00.000 | DST        |
| PRODSRV01 | DBMaint_OptimizeIndexes                  | Remove fragmentation and update statistics for largest tables | Cancelled          | 2017-06-19 00:00:00.000 | 1899-12-30 20:05:00.000 |                    334 | Executed as user: ProdAccount\DBA. The step was cancelled (stopped) as the result of a stop job request.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      | Enabled      | 2017-04-22 04:22:10.036 | 2017-06-18 00:44:42.100 | No description available. |         1 | Jun              |                       6 | Wk25                    |                             25 |                          102 |                         449 |            2017 | Current Calendar Year  | 3 Mo Prior Calendar Month | Other Calendar Week    | 2017-Jun         | 2017-Q2           |                             34 | 2017-Wk25        | 2017-06-19 00:00:00.000 | 2016-06-19 00:00:00.000    | 2017-05-19 00:00:00.000     |   20170619 |          3092 | Q2               |               6 | 2017-06-24 00:00:00.000     |              2 | Mon           | Monday    |                 443 | 2017-Wk21      | 2017-Q2         | 2017-P6            |                     112 |          2017 |                 21 |                   35 | 2016-06-20 00:00:00.000 |                    489 |                       1 | June 19, 2017           |                             19 |                           170 | Q2                         |                                 2 | Weekday             | Non-Holiday         |                        4 | 2016-09-11 00:00:00.000 | DST        |
| PRODSRV01 | DBMaint_IntegrityCheck - USER_DATABASES1 | (Job outcome)                                                 | Succeeded          | 2017-05-27 00:00:00.000 | 1899-12-30 04:00:00.000 |                     52 | The job succeeded.  The Job was invoked by Schedule 59 (Weekly - User DB Integrity Check).  The last step to run was step 1 (DatabaseIntegrityCheck - USER_DATABASES).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        | Enabled      | 2017-04-19 21:17:03.016 | 2017-05-17 17:01:32.346 | No description available. |         0 | May              |                       5 | Wk21                    |                             21 |                          101 |                         445 |            2017 | Current Calendar Year  | Other Calendar Month      | Other Calendar Week    | 2017-May         | 2017-Q2           |                             34 | 2017-Wk21        | 2017-05-27 00:00:00.000 | 2016-05-27 00:00:00.000    | 2017-04-27 00:00:00.000     |   20170527 |          3069 | Q2               |               5 | 2017-05-27 00:00:00.000     |              7 | Sat           | Saturday  |                 439 | 2017-Wk17      | 2017-Q2         | 2017-P5            |                     111 |          2017 |                 17 |                   35 | 2016-05-28 00:00:00.000 |                    485 |                       1 | May 27, 2017            |                             27 |                           147 | Q2                         |                                 2 | Weekend             | Non-Holiday         |                        4 | 2016-09-11 00:00:00.000 | DST        |
| PRODSRV01 | DBMaint_OptimizeIndexes                  | Remove fragmentation and update statistics for largest tables | Succeeded          | 2017-06-25 00:00:00.000 | 1899-12-30 20:05:00.000 |                     20 | Executed as user: ProdAccount\DBA. ...13.0.4435.0  Edition: Enterprise Edition: Core-based Licensing (64-bit)  Procedure: [master].[dbo].[IndexOptimize]  Parameters: @Databases = 'Prod_Accounts', @FragmentationLow = NULL, @FragmentationMedium = 'INDEX_REORGANIZE', @FragmentationHigh = 'INDEX_REORGANIZE', @FragmentationLevel1 = 5, @FragmentationLevel2 = 30, @PageCountLevel = 1000, @SortInTempdb = 'Y', @MaxDOP = 8, @FillFactor = NULL, @PadIndex = NULL, @LOBCompaction = 'N', @UpdateStatistics = 'ALL', @OnlyModifiedStatistics = 'Y', @StatisticsSample = NULL, @StatisticsResample = 'N', @PartitionLevel = 'Y', @MSShippedObjects = 'N', @Indexes = 'Prod_Accounts.dbo.Archived_OldAccount, Prod_Accounts.dbo.AccountStatus, Prod_Accounts.dbo.History, Prod_Accounts.dbo.Billing, Prod_Accounts.dbo.BillingCharacteristic', @TimeLimit = 14400, @Delay = NULL, @WaitAtLowPriorityMaxDuration = NULL, @WaitAtLowPriorityAbortAfterWait = NULL, @AvailabilityGroups = NULL, @LockTimeout = NULL, @LogToTable = 'Y', @Execute = 'Y'  Source: https://ola.hallengren.com [SQLSTATE 01000] (Message 50000)  Date and time: 2017-06-25 20:05:00  Database: [Prod_Accounts]  Status: ONLINE  Standby: No  Updateability: READ_WRITE  User access: MULTI_USER  Is accessible: Yes  Recovery model: FULL  Availability group: AccountingAG  Availability group role: PRIMARY [SQLSTATE 01000] (Message 50000)  Date and time: 2017-06-25 20:05:18  Command: UPDATE STATISTICS [Prod_Accounts].[dbo].[History] [PK_History] [SQLSTATE 01000] (Message 50000)  Outcome: Succeeded  Duration: 00:00:00  Date and time: 2017-06-25 20:05:18 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-06-25 20:05:19  Command: UPDATE STATISTICS [Prod_Accounts].[dbo].[History] [IX_OrgID_TrxType] [SQLSTATE 01000] (Message 50000)  Outcome: Succeeded  Duration: 00:00:00  Date and time: 2017-06-25 20:05:19 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-06-25 20:05:20  Command: UPDATE STATISTICS [Prod_Accounts].[dbo].[History] [IX_History] [SQLSTATE 01000] (Message 50000)  Outcome: Succeeded  Duration: 00:00:00  Date and time: 2017-06-25 20:05:20 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-06-25 20:05:21  Command: UPDATE STATISTICS [Prod_Accounts].[dbo].[History] [IX_History_1] [SQLSTATE 01000] (Message 50000)  Outcome: Succeeded  Duration: 00:00:01  Date and time: 2017-06-25 20:05:22 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-06-25 20:05:22  Command: UPDATE STATISTICS [Prod_Accounts].[dbo].[History] [IX_History_2] [SQLSTATE 01000] (Message 50000)  Outcome: Succeeded  Duration: 00:00:00  Date and time: 2017-06-25 20:05:22 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-06-25 20:05:23  Command: ALTER INDEX [IX_History_3] ON [Prod_Accounts].[dbo].[History] REORGANIZE WITH (LOB_COMPACTION = OFF)  Comment: ObjectType: Table, IndexType: NonClustered, ImageText: N/A, NewLOB: No, FileStream: N/A, ColumnStore: No, AllowPageLocks: Yes, PageCount: 139958, Fragmentation: 39.424 [SQLSTATE 01000] (Message 50000)  Outcome: Succeeded  Duration: 00:09:42  Date and time: 2017-06-25 20:15:05 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-06-25 20:15:05  Command: UPDATE STATISTICS [Prod_Accounts].[dbo].[History] [IX_History_3] [SQLSTATE 01000] (Message 50000)  Outcome: Succeeded  Duration: 00:00:01  Date and time: 2017-06-25 20:15:06 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-06-25 20:15:07  Command: UPDATE STATISTICS [Prod_Accounts].[dbo].[History] [IX_History_4] [SQLSTATE 01000] (Message 50000)  Outcome: Succeeded  Duration: 00:00:01  Date and time: 2017-06-25 20:15:08 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-06-25 20:15:08  Command: UPDATE STATISTICS [Prod_Accounts].[dbo].[History] [IX_History_5] [SQLSTATE 01000] (Message 50000)  Outcome: Suc...  The step succeeded.                                                                                  | Enabled      | 2017-04-22 04:22:10.036 | 2017-06-18 00:44:42.100 | No description available. |         1 | Jun              |                       6 | Wk26                    |                             26 |                          102 |                         450 |            2017 | Current Calendar Year  | 3 Mo Prior Calendar Month | Other Calendar Week    | 2017-Jun         | 2017-Q2           |                             34 | 2017-Wk26        | 2017-06-25 00:00:00.000 | 2016-06-25 00:00:00.000    | 2017-05-25 00:00:00.000     |   20170625 |          3098 | Q2               |               6 | 2017-07-01 00:00:00.000     |              1 | Sun           | Sunday    |                 444 | 2017-Wk22      | 2017-Q2         | 2017-P6            |                     112 |          2017 |                 22 |                   35 | 2016-06-26 00:00:00.000 |                    490 |                       2 | June 25, 2017           |                             25 |                           176 | Q2                         |                                 2 | Weekend             | Non-Holiday         |                        5 | 2016-09-11 00:00:00.000 | DST        |
| PRODSRV01 | Backup_USER_DATABASES - FULL             | DatabaseBackup - USER_DATBASES - FULL                         | Succeeded          | 2017-06-22 00:00:00.000 | 1899-12-30 01:00:00.000 |                    275 | Executed as user: ProdAccount\DBA. ...13.0.4435.0  Edition: Enterprise Edition: Core-based Licensing (64-bit)  Procedure: [master].[dbo].[DatabaseBackup]  Parameters: @Databases = NULL, @Directory = '\\prodsrv01\W$\Backups', @BackupType = 'FULL', @Verify = 'Y', @CleanupTime = 96, @CleanupMode = 'AFTER_BACKUP', @Compress = NULL, @CopyOnly = 'N', @ChangeBackupType = 'N', @BackupSoftware = NULL, @CheckSum = 'Y', @BlockSize = NULL, @BufferCount = NULL, @MaxTransferSize = NULL, @NumberOfFiles = NULL, @CompressionLevel = NULL, @Description = NULL, @Threads = NULL, @Throttle = NULL, @Encrypt = 'N', @EncryptionAlgorithm = NULL, @ServerCertificate = NULL, @ServerAsymmetricKey = NULL, @EncryptionKey = NULL, @ReadWriteFileGroups = 'N', @OverrideBackupPreference = 'N', @NoRecovery = 'N', @URL = NULL, @Credential = NULL, @MirrorDirectory = NULL, @MirrorCleanupTime = NULL, @MirrorCleanupMode = 'AFTER_BACKUP', @AvailabilityGroups = 'ALL_AVAILABILITY_GROUPS', @Updateability = 'ALL', @LogToTable = 'Y', @Execute = 'Y'  Source: https://ola.hallengren.com [SQLSTATE 01000] (Message 50000)  Date and time: 2017-06-22 01:00:02  Database: [HR]  Status: ONLINE  Standby: No  Updateability: READ_WRITE  User access: MULTI_USER  Is accessible: Yes  Recovery model: FULL  Encrypted: No  Availability group: AccountingAG  Availability group role: PRIMARY  Availability group backup preference: PRIMARY  Is preferred backup replica: Yes  Differential base LSN: 36000000211800037  Last log backup LSN: 36000000218600001 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-06-22 01:00:02  Command: DECLARE @ReturnCode int EXECUTE @ReturnCode = [master].dbo.xp_create_subdir N'\\prodsrv01\W$\Backups\prodsrv01\W$\\HR\FULL' IF @ReturnCode <> 0 RAISERROR('Error creating directory.', 16, 1) [SQLSTATE 01000] (Message 50000)  Outcome: Succeeded  Duration: 00:00:00  Date and time: 2017-06-22 01:00:02 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-06-22 01:00:02  Command: BACKUP DATABASE [HR] TO DISK = N'\\prodsrv01\W$\Backups\prodsrv01\W$\\HR\FULL\prodsrv01\W$\_HR_FULL_20170622_010002.bak' WITH CHECKSUM, COMPRESSION [SQLSTATE 01000] (Message 50000)  Processed 360 pages for database 'HR', file 'HR' on file 1. [SQLSTATE 01000] (Message 4035)  Processed 2 pages for database 'HR', file 'HR_log' on file 1. [SQLSTATE 01000] (Message 4035)  BACKUP DATABASE successfully processed 362 pages in 0.902 seconds (3.131 MB/sec). [SQLSTATE 01000] (Message 3014)  Outcome: Succeeded  Duration: 00:00:02  Date and time: 2017-06-22 01:00:04 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-06-22 01:00:04  Command: RESTORE VERIFYONLY FROM DISK = N'\\prodsrv01\W$\Backups\prodsrv01\W$\\HR\FULL\prodsrv01\W$\_HR_FULL_20170622_010002.bak' WITH CHECKSUM [SQLSTATE 01000] (Message 50000)  The backup set on file 1 is valid. [SQLSTATE 01000] (Message 3262)  Outcome: Succeeded  Duration: 00:00:00  Date and time: 2017-06-22 01:00:04 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-06-22 01:00:04  Command: DECLARE @ReturnCode int EXECUTE @ReturnCode = [master].dbo.xp_delete_file 0, N'\\prodsrv01\W$\Backups\prodsrv01\W$\\HR\FULL', 'bak', '2017-06-18T01:00:04' IF @ReturnCode <> 0 RAISERROR('Error deleting files.', 16, 1) [SQLSTATE 01000] (Message 50000)  Outcome: Succeeded  Duration: 00:00:00  Date and time: 2017-06-22 01:00:04 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-06-22 01:00:04  Database: [ETL]  Status: ONLINE  Standby: No  Updateability: READ_WRITE  User access: MULTI_USER  Is accessible: Yes  Recovery model: FULL  Encrypted: No  Availability group: AccountingAG  Availability group role: PRIMARY  Availability group backup preference: PRIMARY  Is preferred backup replica: Yes  Differential base LSN: 31331000006787500059  Last log backup LSN: 31331000006840300001 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-0...  The step succeeded.           | Enabled      | 2017-04-24 17:10:45.000 | 2017-06-18 01:26:21.536 | No description available. |         1 | Jun              |                       6 | Wk25                    |                             25 |                          102 |                         449 |            2017 | Current Calendar Year  | 3 Mo Prior Calendar Month | Other Calendar Week    | 2017-Jun         | 2017-Q2           |                             34 | 2017-Wk25        | 2017-06-22 00:00:00.000 | 2016-06-22 00:00:00.000    | 2017-05-22 00:00:00.000     |   20170622 |          3095 | Q2               |               6 | 2017-06-24 00:00:00.000     |              5 | Thu           | Thursday  |                 443 | 2017-Wk21      | 2017-Q2         | 2017-P6            |                     112 |          2017 |                 21 |                   35 | 2016-06-23 00:00:00.000 |                    489 |                       1 | June 22, 2017           |                             22 |                           173 | Q2                         |                                 2 | Weekday             | Non-Holiday         |                        4 | 2016-09-11 00:00:00.000 | DST        |
| PRODSRV01 | Backup_USER_DATABASES - FULL             | (Job outcome)                                                 | Succeeded          | 2017-07-05 00:00:00.000 | 1899-12-30 01:00:00.000 |                    285 | The job succeeded.  The Job was invoked by Schedule 27 (Prod_Accounts_FullBackup).  The last step to run was step 1 (DatabaseBackup - USER_DATBASES_AG - FULL).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | Enabled      | 2017-04-24 17:10:45.000 | 2017-06-18 01:26:21.536 | No description available. |         0 | Jul              |                       7 | Wk27                    |                             27 |                          103 |                         451 |            2017 | Current Calendar Year  | 2 Mo Prior Calendar Month | Other Calendar Week    | 2017-Jul         | 2017-Q3           |                             35 | 2017-Wk27        | 2017-07-05 00:00:00.000 | 2016-07-05 00:00:00.000    | 2017-06-05 00:00:00.000     |   20170705 |          3108 | Q2               |               6 | 2017-07-08 00:00:00.000     |              4 | Wed           | Wednesday |                 445 | 2017-Wk23      | 2017-Q2         | 2017-P6            |                     112 |          2017 |                 23 |                   35 | 2016-07-06 00:00:00.000 |                    491 |                       3 | July 5, 2017            |                              5 |                           186 | Q3                         |                                 3 | Weekday             | Non-Holiday         |                        2 | 2016-09-11 00:00:00.000 | DST        |
| PRODSRV01 | DBMaint_OptimizeIndexes                  | Remove fragmentation and update statistics for largest tables | Succeeded          | 2017-06-27 00:00:00.000 | 1899-12-30 20:05:00.000 |                     21 | Executed as user: ProdAccount\DBA. ...13.0.4435.0  Edition: Enterprise Edition: Core-based Licensing (64-bit)  Procedure: [master].[dbo].[IndexOptimize]  Parameters: @Databases = 'Prod_Accounts', @FragmentationLow = NULL, @FragmentationMedium = 'INDEX_REORGANIZE', @FragmentationHigh = 'INDEX_REORGANIZE', @FragmentationLevel1 = 5, @FragmentationLevel2 = 30, @PageCountLevel = 1000, @SortInTempdb = 'Y', @MaxDOP = 8, @FillFactor = NULL, @PadIndex = NULL, @LOBCompaction = 'N', @UpdateStatistics = 'ALL', @OnlyModifiedStatistics = 'Y', @StatisticsSample = NULL, @StatisticsResample = 'N', @PartitionLevel = 'Y', @MSShippedObjects = 'N', @Indexes = 'Prod_Accounts.dbo.Archived_OldAccount, Prod_Accounts.dbo.AccountStatus, Prod_Accounts.dbo.History, Prod_Accounts.dbo.Billing, Prod_Accounts.dbo.BillingCharacteristic', @TimeLimit = 14400, @Delay = NULL, @WaitAtLowPriorityMaxDuration = NULL, @WaitAtLowPriorityAbortAfterWait = NULL, @AvailabilityGroups = NULL, @LockTimeout = NULL, @LogToTable = 'Y', @Execute = 'Y'  Source: https://ola.hallengren.com [SQLSTATE 01000] (Message 50000)  Date and time: 2017-06-27 20:05:01  Database: [Prod_Accounts]  Status: ONLINE  Standby: No  Updateability: READ_WRITE  User access: MULTI_USER  Is accessible: Yes  Recovery model: FULL  Availability group: AccountingAG  Availability group role: PRIMARY [SQLSTATE 01000] (Message 50000)  Date and time: 2017-06-27 20:05:02  Command: UPDATE STATISTICS [Prod_Accounts].[dbo].[Archived_OldAccount] [IX_Archived_OldAccount] [SQLSTATE 01000] (Message 50000)  Outcome: Succeeded  Duration: 00:00:01  Date and time: 2017-06-27 20:05:03 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-06-27 20:05:04  Command: UPDATE STATISTICS [Prod_Accounts].[dbo].[Archived_OldAccount] [IX_Archived_OldAccount_11] [SQLSTATE 01000] (Message 50000)  Outcome: Succeeded  Duration: 00:00:02  Date and time: 2017-06-27 20:05:06 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-06-27 20:05:06  Command: UPDATE STATISTICS [Prod_Accounts].[dbo].[Archived_OldAccount] [_WA_Sys_00000002_1F63A897] [SQLSTATE 01000] (Message 50000)  Outcome: Succeeded  Duration: 00:00:02  Date and time: 2017-06-27 20:05:08 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-06-27 20:05:08  Command: UPDATE STATISTICS [Prod_Accounts].[dbo].[Archived_OldAccount] [_WA_Sys_00000003_1F63A897] [SQLSTATE 01000] (Message 50000)  Outcome: Succeeded  Duration: 00:00:02  Date and time: 2017-06-27 20:05:10 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-06-27 20:05:22  Command: UPDATE STATISTICS [Prod_Accounts].[dbo].[History] [PK_History] [SQLSTATE 01000] (Message 50000)  Outcome: Succeeded  Duration: 00:00:01  Date and time: 2017-06-27 20:05:23 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-06-27 20:05:23  Command: UPDATE STATISTICS [Prod_Accounts].[dbo].[History] [IX_OrgID_TrxType] [SQLSTATE 01000] (Message 50000)  Outcome: Succeeded  Duration: 00:00:00  Date and time: 2017-06-27 20:05:23 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-06-27 20:05:24  Command: UPDATE STATISTICS [Prod_Accounts].[dbo].[History] [IX_History] [SQLSTATE 01000] (Message 50000)  Outcome: Succeeded  Duration: 00:00:00  Date and time: 2017-06-27 20:05:24 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-06-27 20:05:24  Command: UPDATE STATISTICS [Prod_Accounts].[dbo].[History] [IX_History_1] [SQLSTATE 01000] (Message 50000)  Outcome: Succeeded  Duration: 00:00:01  Date and time: 2017-06-27 20:05:25 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-06-27 20:05:25  Command: UPDATE STATISTICS [Prod_Accounts].[dbo].[History] [IX_History_2] [SQLSTATE 01000] (Message 50000)  Outcome: Succeeded  Duration: 00:00:01  Date and time: 2017-06-27 20:05:26 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-06-27 20:05:26  Co...  The step succeeded.                                                                | Enabled      | 2017-04-22 04:22:10.036 | 2017-06-18 00:44:42.100 | No description available. |         1 | Jun              |                       6 | Wk26                    |                             26 |                          102 |                         450 |            2017 | Current Calendar Year  | 3 Mo Prior Calendar Month | Other Calendar Week    | 2017-Jun         | 2017-Q2           |                             34 | 2017-Wk26        | 2017-06-27 00:00:00.000 | 2016-06-27 00:00:00.000    | 2017-05-27 00:00:00.000     |   20170627 |          3100 | Q2               |               6 | 2017-07-01 00:00:00.000     |              3 | Tue           | Tuesday   |                 444 | 2017-Wk22      | 2017-Q2         | 2017-P6            |                     112 |          2017 |                 22 |                   35 | 2016-06-28 00:00:00.000 |                    490 |                       2 | June 27, 2017           |                             27 |                           178 | Q2                         |                                 2 | Weekday             | Non-Holiday         |                        5 | 2016-09-11 00:00:00.000 | DST        |
| PRODSRV01 | Backup_USER_DATABASES - FULL             | (Job outcome)                                                 | Succeeded          | 2017-07-03 00:00:00.000 | 1899-12-30 01:00:00.000 |                    268 | The job succeeded.  The Job was invoked by Schedule 27 (Prod_Accounts_FullBackup).  The last step to run was step 1 (DatabaseBackup - USER_DATBASES_AG - FULL).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | Enabled      | 2017-04-24 17:10:45.000 | 2017-06-18 01:26:21.536 | No description available. |         0 | Jul              |                       7 | Wk27                    |                             27 |                          103 |                         451 |            2017 | Current Calendar Year  | 2 Mo Prior Calendar Month | Other Calendar Week    | 2017-Jul         | 2017-Q3           |                             35 | 2017-Wk27        | 2017-07-03 00:00:00.000 | 2016-07-03 00:00:00.000    | 2017-06-03 00:00:00.000     |   20170703 |          3106 | Q2               |               6 | 2017-07-08 00:00:00.000     |              2 | Mon           | Monday    |                 445 | 2017-Wk23      | 2017-Q2         | 2017-P6            |                     112 |          2017 |                 23 |                   35 | 2016-07-04 00:00:00.000 |                    491 |                       3 | July 3, 2017            |                              3 |                           184 | Q3                         |                                 3 | Weekday             | Non-Holiday         |                        2 | 2016-09-11 00:00:00.000 | DST        |
| PRODSRV01 | Backup_USER_DATABASES - FULL             | DatabaseBackup - USER_DATABASES - FULL                        | Succeeded          | 2017-07-13 00:00:00.000 | 1899-12-30 00:30:00.000 |                     58 | Executed as user: ProdAccount\DBA. ...13.0.4435.0  Edition: Enterprise Edition: Core-based Licensing (64-bit)  Procedure: [master].[dbo].[DatabaseBackup]  Parameters: @Databases = 'USER_DATABASES, -AVAILABILITY_GROUP_DATABASES', @Directory = '\\prodsrv01\W$\Backups', @BackupType = 'FULL', @Verify = 'Y', @CleanupTime = 70, @CleanupMode = 'AFTER_BACKUP', @Compress = NULL, @CopyOnly = 'N', @ChangeBackupType = 'N', @BackupSoftware = NULL, @CheckSum = 'Y', @BlockSize = NULL, @BufferCount = NULL, @MaxTransferSize = NULL, @NumberOfFiles = NULL, @CompressionLevel = NULL, @Description = NULL, @Threads = NULL, @Throttle = NULL, @Encrypt = 'N', @EncryptionAlgorithm = NULL, @ServerCertificate = NULL, @ServerAsymmetricKey = NULL, @EncryptionKey = NULL, @ReadWriteFileGroups = 'N', @OverrideBackupPreference = 'N', @NoRecovery = 'N', @URL = NULL, @Credential = NULL, @MirrorDirectory = NULL, @MirrorCleanupTime = NULL, @MirrorCleanupMode = 'AFTER_BACKUP', @AvailabilityGroups = NULL, @Updateability = 'ALL', @LogToTable = 'Y', @Execute = 'Y'  Source: https://ola.hallengren.com     Date and time: 2017-07-13 00:30:00  Database: [Admin]  Status: ONLINE  Standby: No  Updateability: READ_WRITE  User access: MULTI_USER  Is accessible: Yes  Recovery model: FULL  Encrypted: No  Differential base LSN: 2480000001144200037  Last log backup LSN: 2481000004253200001     Date and time: 2017-07-13 00:30:00  Command: DECLARE @ReturnCode int EXECUTE @ReturnCode = [master].dbo.xp_create_subdir N'\\prodsrv01\W$\Backups\PRODSRV01\Admin\FULL' IF @ReturnCode <> 0 RAISERROR('Error creating directory.', 16, 1)  Outcome: Succeeded  Duration: 00:00:00  Date and time: 2017-07-13 00:30:00     Date and time: 2017-07-13 00:30:00  Command: BACKUP DATABASE [Admin] TO DISK = N'\\prodsrv01\W$\Backups\PRODSRV01\Admin\FULL\PRODSRV01_AdminFULL_20170713_003000.bak' WITH CHECKSUM, COMPRESSION  Processed 334192 pages for database 'Admin', file 'Admin' on file 1.  Processed 4 pages for database 'Admin', file 'Adminlog' on file 1.  BACKUP DATABASE successfully processed 334196 pages in 12.093 seconds (215.901 MB/sec).  Outcome: Succeeded  Duration: 00:00:14  Date and time: 2017-07-13 00:30:14     Date and time: 2017-07-13 00:30:14  Command: RESTORE VERIFYONLY FROM DISK = N'\\prodsrv01\W$\Backups\PRODSRV01\Admin\FULL\PRODSRV01_AdminFULL_20170713_003000.bak' WITH CHECKSUM  The backup set on file 1 is valid.  Outcome: Succeeded  Duration: 00:00:03  Date and time: 2017-07-13 00:30:17     Date and time: 2017-07-13 00:30:17  Command: DECLARE @ReturnCode int EXECUTE @ReturnCode = [master].dbo.xp_delete_file 0, N'\\prodsrv01\W$\Backups\PRODSRV01\Admin\FULL', 'bak', '2017-07-10T02:30:17' IF @ReturnCode <> 0 RAISERROR('Error deleting files.', 16, 1)  Outcome: Succeeded  Duration: 00:00:00  Date and time: 2017-07-13 00:30:17     Date and time: 2017-07-13 00:30:17  Database: [Prod_Accounts_Archived]  Status: ONLINE  Standby: No  Updateability: READ_WRITE  User access: MULTI_USER  Is accessible: Yes  Recovery model: FULL  Encrypted: No  Differential base LSN: 10893000021547300037  Last log backup LSN: 10893000021557600001     Date and time: 2017-07-13 00:30:17  Command: DECLARE @ReturnCode int EXECUTE @ReturnCode = [master].dbo.xp_create_subdir N'\\prodsrv01\W$\Backups\PRODSRV01\Prod_Accounts_Archived\FULL' IF @ReturnCode <> 0 RAISERROR('Error creating directory.', 16, 1)  Outcome: Succeeded  Duration: 00:00:00  Date and time: 2017-07-13 00:30:17     Date and time: 2017-07-13 00:30:17  Command: BACKUP DATABASE [Prod_Accounts_Archived] TO DISK = N'\\prodsrv01\W$\Backups\PRODSRV01\Prod_Accounts_Archived\FULL\PRODSRV01_Prod_Accounts_Archived_FULL_20170713_003017.bak' WITH CHECKSUM, COMPRESSION  Processed 67768 pages for database 'Prod_Accounts_Archived', file 'acctRe...  Process Exit Code 0.  The step succeeded.                                                                 | Enabled      | 2017-04-19 21:17:02.956 | 2017-05-16 01:58:22.846 | No description available. |         1 | Jul              |                       7 | Wk28                    |                             28 |                          103 |                         452 |            2017 | Current Calendar Year  | 2 Mo Prior Calendar Month | Other Calendar Week    | 2017-Jul         | 2017-Q3           |                             35 | 2017-Wk28        | 2017-07-13 00:00:00.000 | 2016-07-13 00:00:00.000    | 2017-06-13 00:00:00.000     |   20170713 |          3116 | Q2               |               6 | 2017-07-15 00:00:00.000     |              5 | Thu           | Thursday  |                 446 | 2017-Wk24      | 2017-Q2         | 2017-P6            |                     112 |          2017 |                 24 |                   35 | 2016-07-14 00:00:00.000 |                    492 |                       4 | July 13, 2017           |                             13 |                           194 | Q3                         |                                 3 | Weekday             | Non-Holiday         |                        3 | 2016-09-11 00:00:00.000 | DST        |
| PRODSRV01 | DBMaint_IntegrityCheck - USER_DATABASES1 | (Job outcome)                                                 | Succeeded          | 2017-06-03 00:00:00.000 | 1899-12-30 04:00:00.000 |                     52 | The job succeeded.  The Job was invoked by Schedule 59 (Weekly - User DB Integrity Check).  The last step to run was step 1 (DatabaseIntegrityCheck - USER_DATABASES).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        | Enabled      | 2017-04-19 21:17:03.016 | 2017-05-17 17:01:32.346 | No description available. |         0 | Jun              |                       6 | Wk22                    |                             22 |                          102 |                         446 |            2017 | Current Calendar Year  | 3 Mo Prior Calendar Month | Other Calendar Week    | 2017-Jun         | 2017-Q2           |                             34 | 2017-Wk22        | 2017-06-03 00:00:00.000 | 2016-06-03 00:00:00.000    | 2017-05-03 00:00:00.000     |   20170603 |          3076 | Q2               |               5 | 2017-06-03 00:00:00.000     |              7 | Sat           | Saturday  |                 440 | 2017-Wk18      | 2017-Q2         | 2017-P5            |                     111 |          2017 |                 18 |                   35 | 2016-06-04 00:00:00.000 |                    486 |                       2 | June 3, 2017            |                              3 |                           154 | Q2                         |                                 2 | Weekend             | Non-Holiday         |                        1 | 2016-09-11 00:00:00.000 | DST        |
| PRODSRV01 | DBMaint_UpdateStats_Manual               | Update stats with DEFAULT sample for reamaining tables        | Succeeded          | 2017-05-28 00:00:00.000 | 1899-12-30 20:12:25.000 |                     14 | Executed as user: ProdAccount\DBA. The step succeeded.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        | Enabled      | 2017-04-22 04:22:08.163 | 2017-07-13 00:54:41.016 | No description available. |         2 | May              |                       5 | Wk22                    |                             22 |                          101 |                         446 |            2017 | Current Calendar Year  | Other Calendar Month      | Other Calendar Week    | 2017-May         | 2017-Q2           |                             34 | 2017-Wk22        | 2017-05-28 00:00:00.000 | 2016-05-28 00:00:00.000    | 2017-04-28 00:00:00.000     |   20170528 |          3070 | Q2               |               5 | 2017-06-03 00:00:00.000     |              1 | Sun           | Sunday    |                 440 | 2017-Wk18      | 2017-Q2         | 2017-P5            |                     111 |          2017 |                 18 |                   35 | 2016-05-29 00:00:00.000 |                    486 |                       2 | May 28, 2017            |                             28 |                           148 | Q2                         |                                 2 | Weekend             | Non-Holiday         |                        5 | 2016-09-11 00:00:00.000 | DST        |
| PRODSRV01 | Remove archived data                     | (Job outcome)                                                 | Succeeded          | 2017-06-02 00:00:00.000 | 1899-12-30 23:05:00.000 |                     21 | The job succeeded.  The Job was invoked by Schedule 41 (Weekly - Remove rows from History in Prod_Accounts).  The last step to run was step 1 (Delete rows from History).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | Enabled      | 2017-04-22 04:24:17.550 | 2017-05-17 19:45:52.860 | No description available. |         0 | Jun              |                       6 | Wk22                    |                             22 |                          102 |                         446 |            2017 | Current Calendar Year  | 3 Mo Prior Calendar Month | Other Calendar Week    | 2017-Jun         | 2017-Q2           |                             34 | 2017-Wk22        | 2017-06-02 00:00:00.000 | 2016-06-02 00:00:00.000    | 2017-05-02 00:00:00.000     |   20170602 |          3075 | Q2               |               5 | 2017-06-03 00:00:00.000     |              6 | Fri           | Friday    |                 440 | 2017-Wk18      | 2017-Q2         | 2017-P5            |                     111 |          2017 |                 18 |                   35 | 2016-06-03 00:00:00.000 |                    486 |                       2 | June 2, 2017            |                              2 |                           153 | Q2                         |                                 2 | Weekday             | Non-Holiday         |                        1 | 2016-09-11 00:00:00.000 | DST        |
| PRODSRV01 | DBMaint_UpdateStats_Manual               | Update stats with FULLSCAN for select tables                  | Succeeded          | 2017-05-27 00:00:00.000 | 1899-12-30 20:00:00.000 |                     36 | Executed as user: ProdAccount\DBA. The step succeeded.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        | Enabled      | 2017-04-22 04:22:08.163 | 2017-07-13 00:54:41.016 | No description available. |         1 | May              |                       5 | Wk21                    |                             21 |                          101 |                         445 |            2017 | Current Calendar Year  | Other Calendar Month      | Other Calendar Week    | 2017-May         | 2017-Q2           |                             34 | 2017-Wk21        | 2017-05-27 00:00:00.000 | 2016-05-27 00:00:00.000    | 2017-04-27 00:00:00.000     |   20170527 |          3069 | Q2               |               5 | 2017-05-27 00:00:00.000     |              7 | Sat           | Saturday  |                 439 | 2017-Wk17      | 2017-Q2         | 2017-P5            |                     111 |          2017 |                 17 |                   35 | 2016-05-28 00:00:00.000 |                    485 |                       1 | May 27, 2017            |                             27 |                           147 | Q2                         |                                 2 | Weekend             | Non-Holiday         |                        4 | 2016-09-11 00:00:00.000 | DST        |
| PRODSRV01 | DBMaint_UpdateStats_Manual               | Update stats with FULLSCAN for select tables                  | Succeeded          | 2017-06-12 00:00:00.000 | 1899-12-30 20:00:00.000 |                     28 | Executed as user: ProdAccount\DBA. The step succeeded.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        | Enabled      | 2017-04-22 04:22:08.163 | 2017-07-13 00:54:41.016 | No description available. |         1 | Jun              |                       6 | Wk24                    |                             24 |                          102 |                         448 |            2017 | Current Calendar Year  | 3 Mo Prior Calendar Month | Other Calendar Week    | 2017-Jun         | 2017-Q2           |                             34 | 2017-Wk24        | 2017-06-12 00:00:00.000 | 2016-06-12 00:00:00.000    | 2017-05-12 00:00:00.000     |   20170612 |          3085 | Q2               |               5 | 2017-06-17 00:00:00.000     |              2 | Mon           | Monday    |                 442 | 2017-Wk20      | 2017-Q2         | 2017-P5            |                     111 |          2017 |                 20 |                   35 | 2016-06-13 00:00:00.000 |                    488 |                       4 | June 12, 2017           |                             12 |                           163 | Q2                         |                                 2 | Weekday             | Non-Holiday         |                        3 | 2016-09-11 00:00:00.000 | DST        |
| PRODSRV01 | DW Daily Load                            | (Job outcome)                                                 | Succeeded          | 2017-07-07 00:00:00.000 | 1899-12-30 00:00:00.000 |                     33 | The job succeeded.  The Job was invoked by Schedule 65 (DW Daily Load).  The last step to run was step 2 (ETL).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | Enabled      | 2017-06-28 13:22:39.803 | 2017-06-28 13:22:40.026 | No description available. |         0 | Jul              |                       7 | Wk27                    |                             27 |                          103 |                         451 |            2017 | Current Calendar Year  | 2 Mo Prior Calendar Month | Other Calendar Week    | 2017-Jul         | 2017-Q3           |                             35 | 2017-Wk27        | 2017-07-07 00:00:00.000 | 2016-07-07 00:00:00.000    | 2017-06-07 00:00:00.000     |   20170707 |          3110 | Q2               |               6 | 2017-07-08 00:00:00.000     |              6 | Fri           | Friday    |                 445 | 2017-Wk23      | 2017-Q2         | 2017-P6            |                     112 |          2017 |                 23 |                   35 | 2016-07-08 00:00:00.000 |                    491 |                       3 | July 7, 2017            |                              7 |                           188 | Q3                         |                                 3 | Weekday             | Non-Holiday         |                        2 | 2016-09-11 00:00:00.000 | DST        |
| PRODSRV01 | Match Accounts                           | (Job outcome)                                                 | Succeeded          | 2017-07-01 00:00:00.000 | 1899-12-30 13:00:00.000 |                    123 | The job succeeded.  The Job was invoked by Schedule 51 (FixAccounts).  The last step to run was step 1 (FixAccounts).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         | Enabled      | 2017-04-22 04:24:43.666 | 2017-04-22 23:59:54.933 | No description available. |         0 | Jul              |                       7 | Wk26                    |                             26 |                          103 |                         450 |            2017 | Current Calendar Year  | 2 Mo Prior Calendar Month | Other Calendar Week    | 2017-Jul         | 2017-Q3           |                             35 | 2017-Wk26        | 2017-07-01 00:00:00.000 | 2016-07-01 00:00:00.000    | 2017-06-01 00:00:00.000     |   20170701 |          3104 | Q2               |               6 | 2017-07-01 00:00:00.000     |              7 | Sat           | Saturday  |                 444 | 2017-Wk22      | 2017-Q2         | 2017-P6            |                     112 |          2017 |                 22 |                   35 | 2016-07-02 00:00:00.000 |                    490 |                       2 | July 1, 2017            |                              1 |                           182 | Q3                         |                                 3 | Weekend             | Non-Holiday         |                        1 | 2016-09-11 00:00:00.000 | DST        |
| PRODSRV01 | Backup_USER_DATABASES - FULL             | (Job outcome)                                                 | Succeeded          | 2017-06-19 00:00:00.000 | 1899-12-30 01:00:00.000 |                    268 | The job succeeded.  The Job was invoked by Schedule 27 (Prod_Accounts_FullBackup).  The last step to run was step 1 (DatabaseBackup - USER_DATBASES_AG - FULL).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | Enabled      | 2017-04-24 17:10:45.000 | 2017-06-18 01:26:21.536 | No description available. |         0 | Jun              |                       6 | Wk25                    |                             25 |                          102 |                         449 |            2017 | Current Calendar Year  | 3 Mo Prior Calendar Month | Other Calendar Week    | 2017-Jun         | 2017-Q2           |                             34 | 2017-Wk25        | 2017-06-19 00:00:00.000 | 2016-06-19 00:00:00.000    | 2017-05-19 00:00:00.000     |   20170619 |          3092 | Q2               |               6 | 2017-06-24 00:00:00.000     |              2 | Mon           | Monday    |                 443 | 2017-Wk21      | 2017-Q2         | 2017-P6            |                     112 |          2017 |                 21 |                   35 | 2016-06-20 00:00:00.000 |                    489 |                       1 | June 19, 2017           |                             19 |                           170 | Q2                         |                                 2 | Weekday             | Non-Holiday         |                        4 | 2016-09-11 00:00:00.000 | DST        |
| PRODSRV01 | DBMaint_IntegrityCheck                   | DatabaseIntegrityCheck - USER_DATABASES                       | Succeeded          | 2017-06-03 00:00:00.000 | 1899-12-30 04:00:00.000 |                     22 | Executed as user: ProdAccount\DBA. Date and time: 2017-06-03 04:00:00  Server: PRODSRV01  Version: 13.0.4422.0  Edition: Enterprise Edition: Core-based Licensing (64-bit)  Procedure: [master].[dbo].[DatabaseIntegrityCheck]  Parameters: @Databases = 'AVAILABILITY_GROUP_DATABASES, -Prod_Accounts', @CheckCommands = 'CHECKDB', @PhysicalOnly = 'N', @NoIndex = 'N', @ExtendedLogicalChecks = 'N', @TabLock = 'N', @FileGroups = NULL, @Objects = NULL, @MaxDOP = NULL, @AvailabilityGroups = NULL, @AvailabilityGroupReplicas = 'ALL', @Updateability = 'ALL', @LockTimeout = NULL, @LogToTable = 'Y', @Execute = 'Y'  Source: https://ola.hallengren.com [SQLSTATE 01000] (Message 50000)  Date and time: 2017-06-03 04:00:01  Database: [HR]  Status: ONLINE  Standby: No  Updateability: READ_WRITE  User access: MULTI_USER  Is accessible: Yes  Recovery model: FULL  Availability group: AccountingAG  Availability group role: PRIMARY [SQLSTATE 01000] (Message 50000)  Date and time: 2017-06-03 04:00:01  Command: DBCC CHECKDB ([HR]) WITH NO_INFOMSGS, ALL_ERRORMSGS, DATA_PURITY [SQLSTATE 01000] (Message 50000)  Outcome: Succeeded  Duration: 00:00:05  Date and time: 2017-06-03 04:00:06 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-06-03 04:00:06  Database: [ETL]  Status: ONLINE  Standby: No  Updateability: READ_WRITE  User access: MULTI_USER  Is accessible: Yes  Recovery model: FULL  Availability group: AccountingAG  Availability group role: PRIMARY [SQLSTATE 01000] (Message 50000)  Date and time: 2017-06-03 04:00:06  Command: DBCC CHECKDB ([ETL]) WITH NO_INFOMSGS, ALL_ERRORMSGS, DATA_PURITY [SQLSTATE 01000] (Message 50000)  Outcome: Succeeded  Duration: 00:14:42  Date and time: 2017-06-03 04:14:48 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-06-03 04:14:48  Database: [Accounts_DW]  Status: ONLINE  Standby: No  Updateability: READ_WRITE  User access: MULTI_USER  Is accessible: Yes  Recovery model: FULL  Availability group: AccountingAG  Availability group role: PRIMARY [SQLSTATE 01000] (Message 50000)  Date and time: 2017-06-03 04:14:48  Command: DBCC CHECKDB ([Accounts_DW]) WITH NO_INFOMSGS, ALL_ERRORMSGS, DATA_PURITY [SQLSTATE 01000] (Message 50000)  Outcome: Succeeded  Duration: 00:07:21  Date and time: 2017-06-03 04:22:09 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-06-03 04:22:09  Database: [SSISDB]  Status: ONLINE  Standby: No  Updateability: READ_WRITE  User access: MULTI_USER  Is accessible: Yes  Recovery model: FULL  Availability group: AccountingAG  Availability group role: PRIMARY [SQLSTATE 01000] (Message 50000)  Date and time: 2017-06-03 04:22:09  Command: DBCC CHECKDB ([SSISDB]) WITH NO_INFOMSGS, ALL_ERRORMSGS, DATA_PURITY [SQLSTATE 01000] (Message 50000)  Outcome: Succeeded  Duration: 00:00:08  Date and time: 2017-06-03 04:22:17 [SQLSTATE 01000] (Message 50000)  Date and time: 2017-06-03 04:22:17 [SQLSTATE 01000] (Message 50000).  The step succeeded.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | Enabled      | 2017-05-17 17:04:02.040 | 2017-05-17 17:04:02.050 | No description available. |         1 | Jun              |                       6 | Wk22                    |                             22 |                          102 |                         446 |            2017 | Current Calendar Year  | 3 Mo Prior Calendar Month | Other Calendar Week    | 2017-Jun         | 2017-Q2           |                             34 | 2017-Wk22        | 2017-06-03 00:00:00.000 | 2016-06-03 00:00:00.000    | 2017-05-03 00:00:00.000     |   20170603 |          3076 | Q2               |               5 | 2017-06-03 00:00:00.000     |              7 | Sat           | Saturday  |                 440 | 2017-Wk18      | 2017-Q2         | 2017-P5            |                     111 |          2017 |                 18 |                   35 | 2016-06-04 00:00:00.000 |                    486 |                       2 | June 3, 2017            |                              3 |                           154 | Q2                         |                                 2 | Weekend             | Non-Holiday         |                        1 | 2016-09-11 00:00:00.000 | DST        |
| PRODSRV01 | Backup_USER_DATABASES - FULL             | DatabaseBackup - USER_DATABASES - FULL                        | Succeeded          | 2017-07-12 00:00:00.000 | 1899-12-30 00:30:00.000 |                     77 | Executed as user: ProdAccount\DBA. ...13.0.4435.0  Edition: Enterprise Edition: Core-based Licensing (64-bit)  Procedure: [master].[dbo].[DatabaseBackup]  Parameters: @Databases = 'USER_DATABASES, -AVAILABILITY_GROUP_DATABASES', @Directory = '\\prodsrv01\W$\Backups', @BackupType = 'FULL', @Verify = 'Y', @CleanupTime = 70, @CleanupMode = 'AFTER_BACKUP', @Compress = NULL, @CopyOnly = 'N', @ChangeBackupType = 'N', @BackupSoftware = NULL, @CheckSum = 'Y', @BlockSize = NULL, @BufferCount = NULL, @MaxTransferSize = NULL, @NumberOfFiles = NULL, @CompressionLevel = NULL, @Description = NULL, @Threads = NULL, @Throttle = NULL, @Encrypt = 'N', @EncryptionAlgorithm = NULL, @ServerCertificate = NULL, @ServerAsymmetricKey = NULL, @EncryptionKey = NULL, @ReadWriteFileGroups = 'N', @OverrideBackupPreference = 'N', @NoRecovery = 'N', @URL = NULL, @Credential = NULL, @MirrorDirectory = NULL, @MirrorCleanupTime = NULL, @MirrorCleanupMode = 'AFTER_BACKUP', @AvailabilityGroups = NULL, @Updateability = 'ALL', @LogToTable = 'Y', @Execute = 'Y'  Source: https://ola.hallengren.com     Date and time: 2017-07-12 00:30:03  Database: [Admin]  Status: ONLINE  Standby: No  Updateability: READ_WRITE  User access: MULTI_USER  Is accessible: Yes  Recovery model: FULL  Encrypted: No  Differential base LSN: 2480000001136800037  Last log backup LSN: 2480000001143500001     Date and time: 2017-07-12 00:30:03  Command: DECLARE @ReturnCode int EXECUTE @ReturnCode = [master].dbo.xp_create_subdir N'\\prodsrv01\W$\Backups\PRODSRV01\Admin\FULL' IF @ReturnCode <> 0 RAISERROR('Error creating directory.', 16, 1)  Outcome: Succeeded  Duration: 00:00:01  Date and time: 2017-07-12 00:30:04     Date and time: 2017-07-12 00:30:04  Command: BACKUP DATABASE [Admin] TO DISK = N'\\prodsrv01\W$\Backups\PRODSRV01\Admin\FULL\PRODSRV01_AdminFULL_20170712_003003.bak' WITH CHECKSUM, COMPRESSION  Processed 439128 pages for database 'Admin', file 'Admin' on file 1.  Processed 2 pages for database 'Admin', file 'Adminlog' on file 1.  BACKUP DATABASE successfully processed 439130 pages in 10.798 seconds (317.715 MB/sec).  Outcome: Succeeded  Duration: 00:00:18  Date and time: 2017-07-12 00:30:22     Date and time: 2017-07-12 00:30:22  Command: RESTORE VERIFYONLY FROM DISK = N'\\prodsrv01\W$\Backups\PRODSRV01\Admin\FULL\PRODSRV01_AdminFULL_20170712_003003.bak' WITH CHECKSUM  The backup set on file 1 is valid.  Outcome: Succeeded  Duration: 00:00:04  Date and time: 2017-07-12 00:30:26     Date and time: 2017-07-12 00:30:26  Command: DECLARE @ReturnCode int EXECUTE @ReturnCode = [master].dbo.xp_delete_file 0, N'\\prodsrv01\W$\Backups\PRODSRV01\Admin\FULL', 'bak', '2017-07-09T02:30:26' IF @ReturnCode <> 0 RAISERROR('Error deleting files.', 16, 1)  Outcome: Succeeded  Duration: 00:00:01  Date and time: 2017-07-12 00:30:27     Date and time: 2017-07-12 00:30:27  Database: [Prod_Accounts_Archived]  Status: ONLINE  Standby: No  Updateability: READ_WRITE  User access: MULTI_USER  Is accessible: Yes  Recovery model: FULL  Encrypted: No  Differential base LSN: 10893000021536100037  Last log backup LSN: 10893000021546400001     Date and time: 2017-07-12 00:30:27  Command: DECLARE @ReturnCode int EXECUTE @ReturnCode = [master].dbo.xp_create_subdir N'\\prodsrv01\W$\Backups\PRODSRV01\Prod_Accounts_Archived\FULL' IF @ReturnCode <> 0 RAISERROR('Error creating directory.', 16, 1)  Outcome: Succeeded  Duration: 00:00:00  Date and time: 2017-07-12 00:30:27     Date and time: 2017-07-12 00:30:27  Command: BACKUP DATABASE [Prod_Accounts_Archived] TO DISK = N'\\prodsrv01\W$\Backups\PRODSRV01\Prod_Accounts_Archived\FULL\PRODSRV01_Prod_Accounts_Archived_FULL_20170712_003027.bak' WITH CHECKSUM, COMPRESSION  Processed 67768 pages for database 'Prod_Accounts_Archived', file 'acctRe...  Process Exit Code 0.  The step succeeded.                                                                 | Enabled      | 2017-04-19 21:17:02.956 | 2017-05-16 01:58:22.846 | No description available. |         1 | Jul              |                       7 | Wk28                    |                             28 |                          103 |                         452 |            2017 | Current Calendar Year  | 2 Mo Prior Calendar Month | Other Calendar Week    | 2017-Jul         | 2017-Q3           |                             35 | 2017-Wk28        | 2017-07-12 00:00:00.000 | 2016-07-12 00:00:00.000    | 2017-06-12 00:00:00.000     |   20170712 |          3115 | Q2               |               6 | 2017-07-15 00:00:00.000     |              4 | Wed           | Wednesday |                 446 | 2017-Wk24      | 2017-Q2         | 2017-P6            |                     112 |          2017 |                 24 |                   35 | 2016-07-13 00:00:00.000 |                    492 |                       4 | July 12, 2017           |                             12 |                           193 | Q3                         |                                 3 | Weekday             | Non-Holiday         |                        3 | 2016-09-11 00:00:00.000 | DST        |
| PRODSRV01 | Match Accounts                           | (Job outcome)                                                 | Succeeded          | 2017-07-01 00:00:00.000 | 1899-12-30 19:00:00.000 |                    121 | The job succeeded.  The Job was invoked by Schedule 51 (FixAccounts).  The last step to run was step 1 (FixAccounts).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         | Enabled      | 2017-04-22 04:24:43.666 | 2017-04-22 23:59:54.933 | No description available. |         0 | Jul              |                       7 | Wk26                    |                             26 |                          103 |                         450 |            2017 | Current Calendar Year  | 2 Mo Prior Calendar Month | Other Calendar Week    | 2017-Jul         | 2017-Q3           |                             35 | 2017-Wk26        | 2017-07-01 00:00:00.000 | 2016-07-01 00:00:00.000    | 2017-06-01 00:00:00.000     |   20170701 |          3104 | Q2               |               6 | 2017-07-01 00:00:00.000     |              7 | Sat           | Saturday  |                 444 | 2017-Wk22      | 2017-Q2         | 2017-P6            |                     112 |          2017 |                 22 |                   35 | 2016-07-02 00:00:00.000 |                    490 |                       2 | July 1, 2017            |                              1 |                           182 | Q3                         |                                 3 | Weekend             | Non-Holiday         |                        1 | 2016-09-11 00:00:00.000 | DST        |
| PRODSRV01 | Backup_USER_DATABASES - FULL             | DatabaseBackup - USER_DATABASES - FULL                        | Succeeded          | 2017-06-10 00:00:00.000 | 1899-12-30 00:30:00.000 |                     59 | Executed as user: ProdAccount\DBA. ...13.0.4422.0  Edition: Enterprise Edition: Core-based Licensing (64-bit)  Procedure: [master].[dbo].[DatabaseBackup]  Parameters: @Databases = 'USER_DATABASES, -AVAILABILITY_GROUP_DATABASES', @Directory = '\\prodsrv01\W$\Backups', @BackupType = 'FULL', @Verify = 'Y', @CleanupTime = 70, @CleanupMode = 'AFTER_BACKUP', @Compress = NULL, @CopyOnly = 'N', @ChangeBackupType = 'N', @BackupSoftware = NULL, @CheckSum = 'Y', @BlockSize = NULL, @BufferCount = NULL, @MaxTransferSize = NULL, @NumberOfFiles = NULL, @CompressionLevel = NULL, @Description = NULL, @Threads = NULL, @Throttle = NULL, @Encrypt = 'N', @EncryptionAlgorithm = NULL, @ServerCertificate = NULL, @ServerAsymmetricKey = NULL, @EncryptionKey = NULL, @ReadWriteFileGroups = 'N', @OverrideBackupPreference = 'N', @NoRecovery = 'N', @URL = NULL, @Credential = NULL, @MirrorDirectory = NULL, @MirrorCleanupTime = NULL, @MirrorCleanupMode = 'AFTER_BACKUP', @AvailabilityGroups = NULL, @Updateability = 'ALL', @LogToTable = 'Y', @Execute = 'Y'  Source: https://ola.hallengren.com     Date and time: 2017-06-10 00:30:01  Database: [Admin]  Status: ONLINE  Standby: No  Updateability: READ_WRITE  User access: MULTI_USER  Is accessible: Yes  Recovery model: FULL  Encrypted: No  Differential base LSN: 2399000011174900039  Last log backup LSN: 2403000005406500001     Date and time: 2017-06-10 00:30:01  Command: DECLARE @ReturnCode int EXECUTE @ReturnCode = [master].dbo.xp_create_subdir N'\\prodsrv01\W$\Backups\PRODSRV01\Admin\FULL' IF @ReturnCode <> 0 RAISERROR('Error creating directory.', 16, 1)  Outcome: Succeeded  Duration: 00:00:00  Date and time: 2017-06-10 00:30:01     Date and time: 2017-06-10 00:30:01  Command: BACKUP DATABASE [Admin] TO DISK = N'\\prodsrv01\W$\Backups\PRODSRV01\Admin\FULL\PRODSRV01_AdminFULL_20170610_003001.bak' WITH CHECKSUM, COMPRESSION  Processed 409584 pages for database 'Admin', file 'Admin' on file 1.  Processed 2 pages for database 'Admin', file 'Adminlog' on file 1.  BACKUP DATABASE successfully processed 409586 pages in 12.645 seconds (253.055 MB/sec).  Outcome: Succeeded  Duration: 00:00:14  Date and time: 2017-06-10 00:30:15     Date and time: 2017-06-10 00:30:15  Command: RESTORE VERIFYONLY FROM DISK = N'\\prodsrv01\W$\Backups\PRODSRV01\Admin\FULL\PRODSRV01_AdminFULL_20170610_003001.bak' WITH CHECKSUM  The backup set on file 1 is valid.  Outcome: Succeeded  Duration: 00:00:12  Date and time: 2017-06-10 00:30:27     Date and time: 2017-06-10 00:30:27  Command: DECLARE @ReturnCode int EXECUTE @ReturnCode = [master].dbo.xp_delete_file 0, N'\\prodsrv01\W$\Backups\PRODSRV01\Admin\FULL', 'bak', '2017-06-07T02:30:27' IF @ReturnCode <> 0 RAISERROR('Error deleting files.', 16, 1)  Outcome: Succeeded  Duration: 00:00:00  Date and time: 2017-06-10 00:30:27     Date and time: 2017-06-10 00:30:27  Database: [Prod_Accounts_Archived]  Status: ONLINE  Standby: No  Updateability: READ_WRITE  User access: MULTI_USER  Is accessible: Yes  Recovery model: FULL  Encrypted: No  Differential base LSN: 10814000017452700037  Last log backup LSN: 10842000023021800001     Date and time: 2017-06-10 00:30:27  Command: DECLARE @ReturnCode int EXECUTE @ReturnCode = [master].dbo.xp_create_subdir N'\\prodsrv01\W$\Backups\PRODSRV01\Prod_Accounts_Archived\FULL' IF @ReturnCode <> 0 RAISERROR('Error creating directory.', 16, 1)  Outcome: Succeeded  Duration: 00:00:00  Date and time: 2017-06-10 00:30:27     Date and time: 2017-06-10 00:30:27  Command: BACKUP DATABASE [Prod_Accounts_Archived] TO DISK = N'\\prodsrv01\W$\Backups\PRODSRV01\Prod_Accounts_Archived\FULL\PRODSRV01_Prod_Accounts_Archived_FULL_20170610_003027.bak' WITH CHECKSUM, COMPRESSION  Processed 67744 pages for database 'Prod_Accounts_Archived', file 'acctRe...  Process Exit Code 0.  The step succeeded.                                                                 | Enabled      | 2017-04-19 21:17:02.956 | 2017-05-16 01:58:22.846 | No description available. |         1 | Jun              |                       6 | Wk23                    |                             23 |                          102 |                         447 |            2017 | Current Calendar Year  | 3 Mo Prior Calendar Month | Other Calendar Week    | 2017-Jun         | 2017-Q2           |                             34 | 2017-Wk23        | 2017-06-10 00:00:00.000 | 2016-06-10 00:00:00.000    | 2017-05-10 00:00:00.000     |   20170610 |          3083 | Q2               |               5 | 2017-06-10 00:00:00.000     |              7 | Sat           | Saturday  |                 441 | 2017-Wk19      | 2017-Q2         | 2017-P5            |                     111 |          2017 |                 19 |                   35 | 2016-06-11 00:00:00.000 |                    487 |                       3 | June 10, 2017           |                             10 |                           161 | Q2                         |                                 2 | Weekend             | Non-Holiday         |                        2 | 2016-09-11 00:00:00.000 | DST        |



label: Run Date
Calendar Month
Run Date
Calendar Month Number
Run Date
Calendar Week in Year
Run Date
Calendar Week Number in Year
Run Date
Calendar Year Month Number
Run Date
Calendar Year Week Number
Run Date
Calendar Year
Run Date
Calendar Year Status
Run Date
Calendar Month Status
Run Date
Calendar Week Status
Run Date
Calendar Yr-Mo
Run Date
Calendar Yr-Qtr
Run Date
Calendar Year Quarter Number
Run Date
Calendar Yr-Wk
Run Date
Date
Run Date
Prior Calendar Year Date
Run Date
Prior Calendar Month Date
Run Date
Date Key
Run Date
Date Number
Run Date
Fiscal Quarter
Run Date
Fiscal Period
Run Date
Calendar Week Ending Date
Run Date
Weekday Sort
Run Date
Weekday Abb
Run Date
Weekday
Run Date
Fiscal Yr-Wk Sort
Run Date
Fiscal Yr-Wk
Run Date
Fiscal Yr-Qtr
Run Date
Fiscal Yr-Period
Run Date
Fiscal Yr-Period Sort
Run Date
Fiscal Year
Run Date
Fiscal Week Sort
Run Date
Fiscal Yr-Qtr Sort
Run Date
Fiscal Date Last Year
Run Date
Fiscal Week Sequence
Run Date
Fiscal Week of Period
Run Date
Full Date Description
Run Date
Day Number in Calendar Month
Run Date
Day Number in Calendar Year
Run Date
Calendar Quarter in Year
Run Date
Calendar Quarter Number in Year
Run Date
Weekday Indicator
Run Date
Holiday Indicator
Run Date
Calendar Week in Month
Run Date
One Year Prior Date
Run Date
DST Flag
output: {"Functional-Dependency": [["Run Date", "Calendar Month"], ["Run Date", "Calendar Month Number"], ["Run Date", "Calendar Week in Year"], ["Run Date", "Calendar Week Number in Year"], ["Run Date", "Calendar Year Month Number"], ["Run Date", "Calendar Year Week Number"], ["Run Date", "Calendar Year"], ["Run Date", "Calendar Year Status"], ["Run Date", "Calendar Month Status"], ["Run Date", "Calendar Week Status"], ["Run Date", "Calendar Yr-Mo"], ["Run Date", "Calendar Yr-Qtr"], ["Run Date", "Calendar Year Quarter Number"], ["Run Date", "Calendar Yr-Wk"], ["Run Date", "Date"], ["Run Date", "Prior Calendar Year Date"], ["Run Date", "Prior Calendar Month Date"], ["Run Date", "Date Key"], ["Run Date", "Date Number"], ["Run Date", "Fiscal Quarter"], ["Run Date", "Fiscal Period"], ["Run Date", "Calendar Week Ending Date"], ["Run Date", "Weekday Sort"], ["Run Date", "Weekday Abb"], ["Run Date", "Weekday"], ["Run Date", "Fiscal Yr-Wk Sort"], ["Run Date", "Fiscal Yr-Wk"], ["Run Date", "Fiscal Yr-Qtr"], ["Run Date", "Fiscal Yr-Period"], ["Run Date", "Fiscal Yr-Period Sort"], ["Run Date", "Fiscal Year"], ["Run Date", "Fiscal Week Sort"], ["Run Date", "Fiscal Yr-Qtr Sort"], ["Run Date", "Fiscal Date Last Year"], ["Run Date", "Fiscal Week Sequence"], ["Run Date", "Fiscal Week of Period"], ["Run Date", "Full Date Description"], ["Run Date", "Day Number in Calendar Month"], ["Run Date", "Day Number in Calendar Year"], ["Run Date", "Calendar Quarter in Year"], ["Run Date", "Calendar Quarter Number in Year"], ["Run Date", "Weekday Indicator"], ["Run Date", "Holiday Indicator"], ["Run Date", "Calendar Week in Month"], ["Run Date", "One Year Prior Date"], ["Run Date", "DST Flag"]]}
labeled_fds: Run Date
Calendar Month
Run Date
Calendar Month Number
Run Date
Calendar Week in Year
Run Date
Calendar Week Number in Year
Run Date
Calendar Year Month Number
Run Date
Calendar Year Week Number
Run Date
Calendar Year
Run Date
Calendar Year Status
Run Date
Calendar Month Status
Run Date
Calendar Week Status
Run Date
Calendar Yr-Mo
Run Date
Calendar Yr-Qtr
Run Date
Calendar Year Quarter Number
Run Date
Calendar Yr-Wk
Run Date
Date
Run Date
Prior Calendar Year Date
Run Date
Prior Calendar Month Date
Run Date
Date Key
Run Date
Date Number
Run Date
Fiscal Quarter
Run Date
Fiscal Period
Run Date
Calendar Week Ending Date
Run Date
Weekday Sort
Run Date
Weekday Abb
Run Date
Weekday
Run Date
Fiscal Yr-Wk Sort
Run Date
Fiscal Yr-Wk
Run Date
Fiscal Yr-Qtr
Run Date
Fiscal Yr-Period
Run Date
Fiscal Yr-Period Sort
Run Date
Fiscal Year
Run Date
Fiscal Week Sort
Run Date
Fiscal Yr-Qtr Sort
Run Date
Fiscal Date Last Year
Run Date
Fiscal Week Sequence
Run Date
Fiscal Week of Period
Run Date
Full Date Description
Run Date
Day Number in Calendar Month
Run Date
Day Number in Calendar Year
Run Date
Calendar Quarter in Year
Run Date
Calendar Quarter Number in Year
Run Date
Weekday Indicator
Run Date
Holiday Indicator
Run Date
Calendar Week in Month
Run Date
One Year Prior Date
Run Date
DST Flag
Date Key
Job Status
Calendar Year Month Number
Holiday Indicator
source: $MMTU_HOME/resources/Relationship-finding/FD/184490602