SQL Server 2008 Maintenance Plan

IN PROGRESS
Bids
17
Avg Bid (USD)
$157
Project Budget (USD)
$30 - $250

Project Description:
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#.

Requirements:

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.

Skills required:
.NET, C# Programming, SQL
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


Hire thelogicgates1
$ 145
in 7 days
Hire tuyenvt
$ 80
in 4 days
$ 250
in 1 days
Hire DeoTech
$ 200
in 3 days
$ 100
in 10 days
$ 214
in 2 days
$ 100
in 5 days
Hire ishan1988
$ 100
in 4 days
Hire shiv9586
$ 250
in 15 days
Hire Sonika2011
$ 100
in 2 days