SQL Server 2008 Maintenance Plan in C#

You will use C# to communicate with SQL Server 2008 to create two Maintenance Plans. You can use other languages to obtain the desired results; however, the call will be originating from C#.


1. Create a simple GUI with at least a text box and a label and two buttons. The text box will be the input of the Server Name. The label will display which version of SQL Server you are running. Windows Authentication will be used to log into SQL Server, so login info is not necessary.

2. Write a method that retrieves the version of SQL Server. If you are unable to login to SQL Server, the label should display that it was unable to login, otherwise, it should display the version of SQL and if it is 2008 or not. (example: "You have SQL Server 2008" or "You are not using SQL Server 2008, you have SQL Server 2005")

3. Create 2 Maintenance plans. Button 1 will create the first maintenance plan and be disabled if it exists. Button 2 will create the second maintenance plan and be disabled if it exists. These should both be their own methods for me to call. First one should be called CreateMaintenancePlan(), second one should be called CreateOptiimizationPlan(). Add which ever parameters you need. Throw exceptions in methods if they fail, I'll catch them from my call.

4. Change the SQL Server Agent Jobs of these two plans to have Owner of "sa".

You final result should be 2 maintenance plans with "sa" owner as if you had gone through the maintenance plan wizard twice in SQL Server 2008. I'll supply images of each page of the wizard so you can see the relevant changes.

Please only bid if you know how to create Maintenance plans with code.

People with no feedback will NOT be considered as they have failed me on multiple occasions.

To make things a little easier, I just need a way to restore a maintenance plan, using C#, that I exported from Integration Services and have it set to SA. The only thing I'll need changed in here is the drive letters for the location of the bak files.

Skills: C# Programming, SQL

See more: create sql maintenance plan, maintenance plan, create sql server maintenance plan, add maintenance plan code, add maintenance plan, maintenance windows server 2008, code create maintenance plan, create maintenance plan sql, call sql maintenance plan, sql maintenance, sql maintenance plan, sql server maintenance plan, sql create maintenance plan, windows gui programming, should i change jobs, server languages, sa my name, programming sql, programming methods, programming in sql, programming box requirements, maintenance supply, maintenance jobs, jobs sa, jobs in sa

About the Employer:
( 8 reviews ) Link, United States

Project ID: #1257944

9 freelancers are bidding on average $126 for this job


Please check PMB.

$135 USD in 2 days
(34 Reviews)

Hi Sir,I can do it,Thanks

$80 USD in 3 days
(12 Reviews)

I can create scheduled job using code. Looking forward to your reply. Thanks

$225 USD in 7 days
(2 Reviews)

Hi, I'm very excited about this project. Hopefully soon be able to participate !

$90 USD in 3 days
(1 Review)

Hi. I'm sure that I can help you. Please check PM.

$50 USD in 1 day
(0 Reviews)

Hello I am a proficient,MSSQL Developer more than 3 yrs of development experience Please check PMB for details. Thanks Vishal Patwardhan

$160 USD in 20 days
(0 Reviews)

I can do it, Please send message for me

$150 USD in 7 days
(0 Reviews)

with regards sarath

$45 USD in 5 days
(0 Reviews)

Dear Sir, I am writing in the hopes of being accepted for this Job, in response to your advertisement. I am attaching my profile of company for your perusal to give you an idea of just how suitable I am for this jo More

$200 USD in 5 days
(0 Reviews)