Cancelled

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#.

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: C# Programming, SQL

See more: create sql maintenance plan, 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, change jobs, server languages, programming methods, programming sql, programming box requirements, maintenance supply, maintenance jobs, jobs sa, jobs programming, jobs disabled, jobs sharp, input jobs

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

Project ID: #1257944

9 freelancers are bidding on average $126 for this job

tejas34

Please check PMB.

$135 USD in 2 days
(34 Reviews)
6.1
tuyenvt

Hi Sir,I can do it,Thanks

$80 USD in 3 days
(12 Reviews)
4.7
bubloosoft

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

$225 USD in 7 days
(2 Reviews)
3.3
quoctuan04

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

$90 USD in 3 days
(1 Review)
1.9
gutenmorgen11

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

$50 USD in 1 day
(0 Reviews)
0.0
vishalp03

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

$160 USD in 20 days
(0 Reviews)
0.0
nghiendv

I can do it, Please send message for me

$150 USD in 7 days
(0 Reviews)
0.0
sarathchirayil

with regards sarath

$45 USD in 5 days
(0 Reviews)
0.0
NishatAhmed

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)
0.0