MS SQL Server Agent

SQLServerCentral Article

Create an HTML Report on the Status of SQL Server Agent Jobs

  • Article

SQL Server jobs are an integral part of any SQL Server environment. These jobs run a predefined set of tasks and commands at specified intervals, ensuring the database is up-to-date and performing optimally. As a database administrator, it is essential to regularly monitor the status of SQL Server jobs. One way to do this is […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2023-05-03

8,613 reads

Technical Article

MSSQL Server AlwaysON: Get alerted for inconsistencies in logins, jobs and databases

  • Script

This script will create the necessary login and linked servers on a given availability replica. Please ensure that the script is executed on all the replicas.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(6)

You rated this post out of 5. Change rating

2022-02-22 (first published: )

7,965 reads

Blogs

Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?

By

Making Data AI-Ready, Part 3 (This is the final article in a three-part series...

Keeping Track of my ConEmu CLIs

By

I use ConEmu for my terminal interface. I’m still on Windows 10 at home,...

10 Decisions to Make Before You Create A Fabric Workspace

By

Creating a Fabric workspace takes about 30 seconds. Restructuring workspaces after people have built...

Read the latest Blogs

Forums

Alamat BCA KCP Mall Grand Indonesia Telp:08218520153

By layanan_Bca88

WhatsApp Cs 628218520153 Gedung Grand Indonesia Mall A, Lower Ground No. 20-21, Jl. M.H....

Alamat Kantor BCA KCP Senen Telp:08218520153

By R4nt4u

WhatsApp Cs 628218520153 Pusat Grosir Senen Jaya Blok A8-9, Lantai 2, RW.3, Senen, Kec....

BCA KCU PANGERAN JAYAKARTA Tlp:08218520153

By m4rt1n4

WhatsApp Cs 628218520153 Jl. P Jayakarta Komp. No.127, RT.7/RW.7, Mangga Dua Sel., Kecamatan Sawah...

Visit the forum

Question of the Day

Adding new column with DEFAULT II

Which number did the two COUNT(*) return: 

DROP TABLE IF EXISTS #tmp
CREATE TABLE #tmp (id INT NOT NULL)

INSERT INTO #tmp (id) 
SELECT gs.value
  FROM GENERATE_SERIES(1, 5) AS gs

ALTER TABLE #tmp ADD my_value INT NOT NULL CONSTRAINT df_tmp_my_value DEFAULT 1

SELECT COUNT(*)  FROM #tmp AS t WHERE my_value = 1

ALTER TABLE #tmp DROP CONSTRAINT df_tmp_my_value

ALTER TABLE #tmp ADD CONSTRAINT df_tmp_my_value DEFAULT 2 FOR my_value

SELECT COUNT(*)  FROM #tmp AS t WHERE my_value = 1

See possible answers