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 ...

Now, in addition to listing active SQL Server Agent jobs, the tool can be used to view alerts, operators and proxies, announced Alan Yu, a program manager at Microsoft SQL Server, in a July 19 blog.

We've all been in situations where we spend a great deal of time navigating the complicated Web of inter-server SQL Agent jobs to find resource contention and scheduling problems. When you add the ...

If you've worked with the SQL Server Agent to run jobs on your server, you already know that whenever you define a job step, you have to define a job step "type." In SQL Server 2008 and newer ...

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 ...

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 ...

Most people know that by highlighting an object (eg an SQL Agent job) and right-clicking, an option presents itself to generate a script of the said job. However it is only possible to script one ...