Shashi Kant Chauhan

MSSQL Job Monitoring Simplified using Simple Query

This query states the execution status of the job i.e. Executing, idle etc. you also modify and search the jobs by changing the search condition.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2008-12-02

1,031 reads

I wrote about learning today for the editorial: I Can’t Make You Learn. I...

Fabric has CI/CD built in, but if you've tried to use it for database...

attriage – n. the state of having lost all control over how you feel...

Comments posted to this topic are about the item SSRS Reminded Me of the...

I have a need to execute a stored procedure and return the results to...

Title pretty much says it all - can this be done? I've tried several...

In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:

UserID  UserPermissions
15
23
37
4       NULL

What is returned when I run this code:

select bit_count(UserPermissions) as PermissionCount
from dbo.UserPermission
where UserID = 4;