MS-SQL Server - Scheduled Agent Jobs, RTM Releases, Read XML, Estimates & Build Versions 2019

Scheduled Agent Jobs, RTM Releases, Read XML, Estimates & Build Versions 2019

Scheduled Agent Jobs

https://learn.microsoft.com/en-us/sql/ssms/agent/schedule-a-job?view=sql-server-ver16

RTM Releases

Read XML

https://learn.microsoft.com/en-us/sql/relational-databases/xml/openxml-sql-server?view=sql-server-ver16

Estimates

There are four types of Estimates

1. Backup Size

2. Execution Plan

3. Percentage of Completion time (Backup and Restore).

4. Query Execution Time

Build Versions

https://learn.microsoft.com/en-us/troubleshoot/sql/releases/sqlserver-2019/build-versions

Additionally,

[DEFAULT Port 1433,1434

SQL Server View definition Permissions

https://learn.microsoft.com/en-us/sql/relational-databases/security/permissions-database-engine?view=sql-server-ver16

Error : 33558

Permission/Role for sp_cycle_agent_errorlog

https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-cycle-agent-errorlog-transact-sql?view=sql-server-ver16

Agent's ENUM procedures

sp_enum_login_for_proxy

sp_enum_proxy_for_subsystem

sp_enum_sqlagent_subsystems

Error:- Backup file is not valid

https://learn.microsoft.com/en-us/troubleshoot/windows-server/backup-and-storage/database-backup-error-3266-3013

]

Any query will be considered.

T. Amit Vaid S.