Tuesday, February 12, 2019

Interview Question : How to get a list of SQL Server Agent Jobs in SQL Server ?

Here i am writing  a simple query to find the list of all Jobs currently running on SQL Server. We can write below simple query to find the "sysjobs" on each server.

Friday, February 8, 2019

SQL | Distinct Clause

Definition :

In SQL, the DISTINCT keyword is used with the SELECT statement to remove all the duplicate records and fetching only unique records.