Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Does MS SQL Maestro provide any automation of administrative tasks for Microsoft SQL Server?

April 26, 2017administrative automation Maestro Microsoft MS sql SQL Server tasks

0

Posted

Does MS SQL Maestro provide any automation of administrative tasks for Microsoft SQL Server?

1 Answer

0

Posted

MS SQL Maestro provides scheduled jobs and alerts to automate server administrative tasks. The job object exposes the attributes of a single SQL Server Agent job. Using SQL Server Agent jobs, you can automate administrative tasks and run them on a recurring basis. You can run a job manually or schedule it to run in response to schedules and alerts. Administrative jobs scheduling means defining a condition(s) that causes the job to begin running. Using these server objects you can schedule any type of job. More than one job can use the same job schedule. A user can attach and detach schedules from jobs. The object is available in Microsoft SQL server 2005 or higher. The Alert object represents a single SQL Server Agent alert. Alerts respond to either specific Microsoft SQL Server error messages or SQL Server errors of a specified severity. By default, only members of the sysadmin fixed server role can create alerts.