October 12, 2001 at 4:07 pm
I schedule many jobs thru the Sql seheduler. I was looking for a way to build an APP using DMO that could monitor just this piece without giving someone EM. They nedd to be able to Start/Stop and monitor jobs in the schedule. Do you have any examples ?
October 12, 2001 at 4:22 pm
Not so far. Anyone else? I don't think it will be too difficult. I like the idea of a custom front end, eliminates a lot of headaches! Probably you need:
1) Retrieve the list of all jobs
2) Then for any job, start, stop
3) Also view history for any job
Would they be adding/removing jobs? Other requirements?
Andy
October 15, 2001 at 5:25 pm
There maybe a need to add/modify jobs.
October 15, 2001 at 5:51 pm
Adding jobs can be a fair sized headache. Well, adding the job is not bad, but getting the schedule done takes some work. If you're not going to be adding very many, I think I'd consider leaving that part out. The only alternative I can think of is maybe to use SQL-Namespace, but not well versed enough to know for sure.
What language/tool are you planning to use for your project?
Andy
October 16, 2001 at 10:06 am
Stored procedures (my favorite) exist for most every job item you need. It would be easy to also build a GUI interface in ASP/VB/.NET that would manage your jobs.
Personally I'd prefer this as it would be easier to change and modify than VB/DMO (sorry Andy).
Steve Jones
October 16, 2001 at 12:02 pm
Would be interesting to do both approaches, since how they compare. Depending on how efficent DMO is, it might be faster to use procs.
Andy
October 16, 2001 at 5:24 pm
I was thinking of using VB/DMO approach.
October 17, 2001 at 5:08 am
Either will work. Have you looked at the jobs collection and the job object yet?
Andy
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply