Looking for Easy SQL Job Manager for MS SQL Server (MSDE)

[Tom82]

hello there,
to provide customers an Easy-To-Use interface for creating Backup jobs i am looking for an configureable Application or Component. If possible it should be Open Source and written in .Net or COM :)

i want it to Use it this way: on installation this app Apears and you can define the parameters of the Job. this tool should also allow an easy Restore of the DB.
or does any Framework has allready such support ?


greeting tom.

[Krzemo]

U need 3 parts:

1) Schedule component.
http://www.codeproject.com/csharp/taskschedulerlibrary.asp#xx1195231xx

http://www.codeproject.com/csharp/scheduler.asp

... and google for more

2) Backup utility - Use connection/command object to execute SQL commands which will do the job (ie BACKUP command). The job should read params from registry (or INI OR XML config)

3) GUI part - U need to write some and store params in registry/config file

Hope it helps.

[Tom82]

thx for the answer.
but i don''t want to invent the Wheel again.
there is allready something existing that does the Sheduling Job - the SQL Server Agent.

there is also an Assistant available in the SQL Enterprise Manager.
[Extras -> Assistants... -> Administration -> Backup-Assistant]
but this Agent requires to much background knowledge for standart Custumors AND the Enterprise Manager is not shipped with the MSDE.

i think every developer who uses MSDE as Data Storage is confronted by the same problem - > so there must be allready an Wheel ;-)

i am looking for a Click - Click - "yes backup Daily" - click - "yeah backup on this location"- click solution.

[Krzemo]

there is allready something existing that does the Sheduling Job - the SQL Server Agent.
Sorry, I wasn't aware that SQL Server Agent is installed with MSDE. Im using the full versions (Developer Edition/Enterprice Edition). My mistake.

If U have it, all U need is to know proper SQL commands and write a very simple application in .NET which take inputs from users and change it to proper SQL commands (sp_add_job,sp_add_jobschedule for example). It is very easy now.

All info is available in SQL Server Books Online.

Best regards,
Krzemo.

[Tom82]

thx for your answer.
hmm you are allright - i am also unsure about if MSDE Supports an Sql Server Agent- - i will find out and reply

[Tom82]

MSDE is Shipped with the server agent.

[Krzemo]

Thanks for info.

:wave:

[Tom82]

got it now - but unfortunatly i can't share the source :(

There is a .Net Object Library provided by Microsoft called Server Managment Object (SMO) - it provides an easy access to most MS SQL Server functions.
There is another library available called SQL-DMO - but SMO made it obsolete ;-)
with the SMO it is possible (maybe the most easiest way) to manage Jobs, Backup and Restore operations, and much more.

best regards - tom