In today’s tip I looked at how you can allow users on your system to see the SQL Agent jobs on the database server. However, just because you are able to assign these permissions, doesn’t mean ...

--SQL Agent job to show SQL Server service details upon agent restart --This script is being offered for public use and as such is being offered as untested and unverified. --Please use this script at ...

In keeping with our goal to enable SQL Server features across all platforms supported by SQL Server, Microsoft is excited to announce the preview of SQL Server Agent on Linux in SQL Server vNext ...

Learn how to create and schedule a SQL Server Agent job that runs a SQL script to optimize your SQL performance in four steps. ... or view its history and status in the SQL Server Agent Jobs folder.

Scheduling with the SQL Server Agent. A few practical examples on setting up policies. This time, we PowerShell it. By Joshua Jones; 12/07/2009; It is possible to use the SQL Server Agent to ...

Periodically you might want to reduce the size of the tables and archive messages and events that are no longer needed. The following procedures create a SQL Server Agent job to automate the process.

View SQL Agent Jobs You can run an SQL Agent job schedule query that tells you what jobs are scheduled to run on an SQL Server system equipped with SQL Server Agent.

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

Note that SSMS is now allowing viewing (View button) an output_file whose name is tokenized (at least for the simple macros/tokens supported by SQL Agent that are not determined at runtime).