maintance plan vs Sql job

Question

maintance plan vs Sql job

naveen.neerukattu1228

SSC Veteran

Points: 292
More actions
April 19, 2016 at 10:47 am

#315720

Hi All,
i am little bit confusion about Maintance plan and sql job.
i want to take backup in schedule basis. so which option will meet my requirements?
creating job in sql agent or creating a job in maintainceplan .
please help me on this

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

cphite SSCarpal Tunnel Points: 4272 More actions · Answer 1

naveen.neerukattu1228 (4/19/2016)
Hi All,
i am little bit confusion about Maintance plan and sql job.
i want to take backup in schedule basis. so which option will meet my requirements?
creating job in sql agent or creating a job in maintainceplan .
please help me on this

You will need both.

First, create your maintenance plan to do the backups. While you're still inside the maintenance plan, click on the icon to schedule it (top of the window) and when you create the schedule, it will create a job for you automatically.

Alternatively, if you already have a maintenance plan for the backups, you can create a new job and select that maintenance plan, and then schedule it however you like.

It is possible to do scheduled backups using a job alone, but it makes a lot more sense to do it via the maintenance plan - especially if you're new to this sort of thing.

Alan Burstein SSC Guru Points: 61136 More actions · Answer 2

Simpy put - when you create a maintenance plan and schedule it you are creating a new SQL Agent Job that runs your "maintenance plan" at a time of your choosing.

Alternatively you can simply create a new SQL Agent job and a step that backs up your databases using T-SQL.

"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

-- Itzik Ben-Gan 2001

naveen.neerukattu1228 SSC Veteran Points: 292 More actions · Answer 3

For job we can make alerts or notification if the job fails then what about Maintenance plan job. is there any alert or notification ? for maintenance job

cphite SSCarpal Tunnel Points: 4272 More actions · Answer 4

naveen.neerukattu1228 (4/19/2016)
For job we can make alerts or notification if the job fails then what about Maintenance plan job. is there any alert or notification ? for maintenance job

Either way is going to involve a job. You'll either have a job that runs a maintenance plan, or a job that does the backup itself via T-SQL.