SQL Smart Solutions

Search This Blog

SCRIPT: How to start SQL Agent job?

on August 21, 2023

Get link
Facebook
X
Pinterest
Email
Other Apps

USE msdb
GO
EXEC dbo.sp_start_job N'Job_Name'

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Script: How to get SQL Server messages from Windows Event Viewer?

$startDate = '2024-08-10' $endDate = '2024-08-11' Get-EventLog -LogName "application" ` | Where-Object {$_.source -like "*SQL*" -and $_.TimeGenerated -ge $startDate -and $_.TimeGenerated -lt $endDate } ` | Select-Object source, EntryType, TimeGenerated, Message

SCRIPT: Check implicit transactions

SELECT trans . session_id AS [SESSION ID] , ESes . host_name AS [HOST NAME] , login_name AS [Login NAME] , trans . transaction_id AS [TRANSACTION ID] , tas . name AS [TRANSACTION NAME] , tas . transaction_begin_time AS [TRANSACTION BEGIN TIME] , tds . database_id AS [DATABASE ID] , DBs . name AS [DATABASE NAME] FROM sys . dm_tran_active_transactions tas JOIN sys . dm_tran_session_transactions trans ON ( trans . transaction_id = tas . transaction_id ) LEFT OUTER JOIN sys . dm_tran_database_transactions tds ON ( tas . transaction_id = tds . transaction_id ) LEFT OUTER JOIN sys . databases AS DBs ON tds . database_id = DBs . database_id LEFT OUTER JOIN sys . dm_exec_sessions AS ESes ON trans . session_id = ESes . session_id WHERE ESes . session_id IS NOT NULL

What is RBAR?

Row By Agonising Row. Loops, cursors, complex correlated subqueries, inline functions with data access, functions in the where clause... all are examples of RBAR.

Powered by Blogger

SCRIPT: How to start SQL Agent job?

Comments

Post a Comment