SQL, or the structured query language, is a specialized programming language designed for working with databases. There are a few different variations of SQL from different organizations and projects, ...

If you are an old hand at Microsoft SQL Server, you have probably used the SQL Server Agent (i.e., SQL Agent) service and MSDB database for the last 20 years. With a humble and largely unchanged ...

How do I assign permissions to users to see SQL Agent Jobs? Your email has been sent You can give your users rights to check if reports have run or jobs are complete without granting full admin rights ...

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. This article dives into the happens-before ...

We have Database Mirroring set up (SQL 2005), but what is the proper way to mirror SQL Agent Jobs? We have quite a few custom jobs. Is it just manually scripting out the jobs from the Principle and ...

I want to enable notifications for SQL Agent for my backup jobs.<BR><BR>I configured database mail and that works, it sent me a test message.<BR><BR>However, when I go to tell the SQL Agent to use it, ...