Automate SQL Server Task

When you running SQL Server, it is impossible for you to back up your database manually daily. Hence you will need some tool to schedule your SQL server to backed up daily.

With SQL server, you may easily backup your database without any extra tools but using the SQL Agent services to back up your task.

Step 1: Open SQL Server Agent and expand Job Activity Monitor.

Step 2: Right click and select new job. Enter the necessary information and click on the check box.

Step 3: Put your command into the command box and enter the necessary information.

Step 4: Schedule the date and time or routine time to run the task.

Published by

Mick Genie

Mick Genie is the founder of MickGenie.com and working at ExaBytes Network Sdn Bhd and WPWebHost web host company. He is expertise in Windows and Linux environment especially web hosting related information, tips and trick as well as the IT Information.