In Progress

SQL Server 2008 Maintenance Plan

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

See more: create maintenance plan, create sql maintenance plan, call maintenance plan, sql server maintenance plan, maintenance plan, call sql maintenance, sql server maintenance code, change jobs, server languages, maintenance supply, maintenance jobs, jobs sa, jobs disabled, input jobs, sql server gui, sql code, maintenance, catch, c maintenance, sql final, server log, call method, sql create maintenance plan, wizard gui, gui wizard

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

Project ID: #1247746

Awarded to:

ishan1988

I have excellent exposure in SQL Server and .NET windows/web application. I can do this job for you on time with quality and hope to make you feel happy the way my earlier clients were,with 100% completion rate

$100 USD in 4 days
(5 Reviews)
2.2

17 freelancers are bidding on average $157 for this job

thelogicgates1

Hi, Ready to start. Check PMB please.

$145 USD in 7 days
(15 Reviews)
5.9
tuyenvt

i have experience C#,sql server,Please check my profile for details.Thanls

$80 USD in 4 days
(13 Reviews)
4.7
E01011984

Hi, I have already made an application where I have to make a method for converting sql server database from one version to another and restore this. For this , I have to test that the database is exist or not, and ca More

$250 USD in 1 day
(1 Review)
4.4
DeoTech

Hi! I work with MS SQL since 1999. Kindly see PM Regards.

$200 USD in 3 days
(5 Reviews)
3.6
zeromaxsolution

Hi, 7 years experience in the Asp.net ( C# ) , Java script ,Ajax and Mssql field.i m Microsoft Certified Solution Developer. I can do it . i will complete this job in 10 days. i have team to develop the Software and We More

$100 USD in 10 days
(5 Reviews)
3.4
NightCoders

Hi I can Easily do this for You Kindly Go Through my Resume.I have This Kind of Work Before

$214 USD in 2 days
(1 Review)
3.0
TSFreelance

Sir, I am an expert in .net Technology. Please See your PMB Thanking You

$100 USD in 5 days
(2 Reviews)
2.7
technobright

I have excellent exposure in SQL Server and .NET windows/web application. I can do this job for you on time with quality

$100 USD in 7 days
(0 Reviews)
0.0
ManojKaniyal

as from your description i am able to understand you need. i assure you that the quality of work will be best according to your needs.

$222 USD in 5 days
(0 Reviews)
0.0
viswesh

hi, i have 4 years of experience in asp.net,c#,sqlserver,ajax,javascript. Ready to work with you.

$90 USD in 2 days
(0 Reviews)
0.0
mrat6ta8

plz see pmb

$140 USD in 6 days
(0 Reviews)
0.0
ksrihari

Please check PM

$250 USD in 3 days
(1 Review)
0.0
mylovemt

I am ready to do.

$230 USD in 5 days
(0 Reviews)
0.0
Sonika2011

Please check PM

$100 USD in 2 days
(0 Reviews)
0.0
shiv9586

hi sir we understand all kind of requirement which discuss . we will provide u a product which contain all functionlity at minimum cost at least time. thanks.

$250 USD in 15 days
(0 Reviews)
0.0
apanka

Hello, I have 16+ years of experience with programing and 6+ yers in programing in C#.NET and worked on many medium to marge projects. I'm working as hourly or fixed salary. I have 3 years of freelancer experience as More

$100 USD in 2 days
(0 Reviews)
0.0