I was placed in an interesting situation where I needed to manage SQL Server jobs from a web application, which would sit on a completely different server and I was only allowed to use SQL Logins (not Windows logins) to perform any SQL task, I needed a way to use an SQL server login to manage SQL Server agent jobs.

NOTE: I will be writing a tutorial on managing SQL server jobs via C# but if you’d like me to put a rush on it please let me know in the comments below.

The steps needed to set up an SQL login with sufficient permissions to manage SQL Server jobs are mentioned below.
Read more “How to allow a user with an SQL login to manage SQL Server Agent”