Skip to content

SQL Canada (SQLCAN)

Data – Analytics – AI – Random Thoughts

  • Home
  • SQLOpDB
  • DBA Queries
  • Acclaim Badges
  • About

Tag: Set-ScheduledTask

Windows Task Scheduler for SQLOpsDB

December 14, 2022 Mohit

The Windows Task Scheduler executes the PowerShell script for data collection for both SQLOpsDB data collection and configuration health. These collections can be completed via

Continue reading

Rate this:

Contact Me

mohitkgupta@msn.com
Contact me if you need assistance with PTO, HADR, Automation, etc. :)
MCC 2012

Categories

  • Administration (44)
    • SQLOpDB (13)
  • Announcement (17)
  • Azure (1)
    • Azure Storage (1)
  • Best Practices (3)
  • Database Mirroring (5)
  • Disaster Recovery (5)
  • Documentation (1)
  • Dynamic Management Views/Functions (11)
  • Full Text Search (2)
  • High Availability and Disaster Recovery (18)
    • AlwaysOn Availability Groups (3)
    • Cluster Errors (1)
    • SQL Failover Cluster (2)
    • Windows 2003 Clustering (3)
    • Windows 2008 Clustering (9)
    • Windows 2008 R2 Clustering (3)
  • Interesting Reads (11)
  • Maintenance Plans (2)
  • Operating System Errors (2)
  • Performance Tuning (21)
  • Published Article (2)
  • Reporting (7)
    • Power BI (2)
    • Power BI Desktop (2)
    • Report Builder (1)
    • SSRS 2000 (1)
    • SSRS 2008 (1)
  • Security (10)
  • Smart Index Management (3)
  • SQL 2000 (5)
  • SQL 2005 (29)
  • SQL 2008 (18)
  • SQL 2008 R2 (11)
  • SQL 2012 (16)
  • SQL 2014 (11)
  • SQL 2016 (15)
  • SQL Bootstrap Errors (1)
  • SQL Embedded Edition (1)
  • SQL Errors (15)
  • SQL Internals (2)
  • SQL Protocols (1)
  • SQL Replication Errors (1)
  • SQL Server Tools (1)
    • SQL Server Configuration Manager (1)
  • T-SQL Reference (4)
  • Tinkering (1)
  • Tools (14)
  • Troubleshooting (30)
  • Windows 2008 (1)
  • Windows 2008 R2 (2)

Tags

ApexSQL Tools Authentication Automation Capacity Planning Central Management Server CMS Computed Columns Configuration Health CTE CTP Database Corruption DBA Queries DBCC CHECKDB Distributed Transactions DMF - sys.dm_exec_query_plan DMF - sys.dm_exec_sql_text DMF - sys.dm_io_virtual_file_stats DMV - sys.dm_exec_query_stats DMV - sys.dm_exec_requests DMV - sys.dm_os_waiting_tasks fn_dblog Hekaton in-doubt xact resolution In-Memory OLTP Index Management Jan 2019 Update KB Articles Kerberos Lazy Writer Linked Servers Maintenance Plans Microsoft Forever Modeling mofcomp M Query Language Multi-Server Management Named Pipes Non-Technical NUMA Configuration OBJECT_NAME Operating System Error 5 PAL perfmon Performance Counters Permissions Power Query Language PowerShell Presentation Processor Imbalance References Security Service Principal Names (SETSPN) Slicer Pane Smart Guides SQL Error 5172 SQL Error 18456 SQLOpDB Reports SQLOpsDB Reports SQLPASS SQL Patches & Hotfixes SQL Server Disaster Recovery SSIS SSMS SSMS 2008 SSPI Error SSRS Suspect Database Syntax Highlight sys.database_mirroring_endpoints sys.dm_tran_active_transactions sys.indexes sys.tables sys.tcp_endpoints Undocumented Functions Wait Types

Archives

Administration Links

  • Register
  • Log in
  • Entries feed
  • Comments feed
  • WordPress.com

Blog Stats

  • 142,725 hits
Website Powered by WordPress.com.
  • Follow Following
    • SQL Canada (SQLCAN)
    • Join 30 other followers
    • Already have a WordPress.com account? Log in now.
    • SQL Canada (SQLCAN)
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar