Documenting SQL Jobs

Does anyone know any tools or scripts to use for
documenting SQL Jobs. I need to take the results and
create an excel or word file for management. I would need
it to list the job name, schedule, frequency...so on.
Trying to script this is not easy in that the sysjobs and
sysjobschedules tables use numbers to represent everything
about the schedule and all.
Any help is appreciated.
Thanks,
Van JonesHow about a simple SQL Query, and put the output in Excel? The tables you
need to read from aren't that difficult to work with. Only mess is the
dateformat and frequency stuff, but there is some good stuff at
www.SQLDev.Net that help you with this.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Van Jones" <anonymous@.discussions.microsoft.com> wrote in message
news:0dbd01c3a485$acb49fb0$a401280a@.phx.gbl...
> Does anyone know any tools or scripts to use for
> documenting SQL Jobs. I need to take the results and
> create an excel or word file for management. I would need
> it to list the job name, schedule, frequency...so on.
> Trying to script this is not easy in that the sysjobs and
> sysjobschedules tables use numbers to represent everything
> about the schedule and all.
> Any help is appreciated.
> Thanks,
> Van Jones|||Hey thanks for the reply Tibor. I've been down that road
before a couple years ago and didn't have a great deal of
luck. I got it to work, but it wasn't very clean. I was
just hoping for a tool to do it for me. However, I saw a
reply from Sue under dbforums to the same question that
had the following article listed:
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=15560
It has a sp called usp_Scheduled_Jobs that will do it all
for you....extremely nice and useful.
Thanks,
Van Jones
MCDBA, MCSE, MCSA, MCAD
>--Original Message--
>How about a simple SQL Query, and put the output in
Excel? The tables you
>need to read from aren't that difficult to work with.
Only mess is the
>dateformat and frequency stuff, but there is some good
stuff at
>www.SQLDev.Net that help you with this.
>--
>Tibor Karaszi, SQL Server MVP
>Archive at:
>http://groups.google.com/groups?
oi=djq&as_ugroup=microsoft.public.sqlserver
>
>"Van Jones" <anonymous@.discussions.microsoft.com> wrote
in message
>news:0dbd01c3a485$acb49fb0$a401280a@.phx.gbl...
>> Does anyone know any tools or scripts to use for
>> documenting SQL Jobs. I need to take the results and
>> create an excel or word file for management. I would
need
>> it to list the job name, schedule, frequency...so on.
>> Trying to script this is not easy in that the sysjobs
and
>> sysjobschedules tables use numbers to represent
everything
>> about the schedule and all.
>> Any help is appreciated.
>> Thanks,
>> Van Jones
>
>.
>|||OK, I just wanted to point the option of using these tables, in case you
haven't used them already. Yes, some things aren't that easy to deal with
(mostly the freq- things, IMO). Hopefully Sue's proc will help you :-)
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Van Jones" <anonymous@.discussions.microsoft.com> wrote in message
news:0ded01c3a48e$787439a0$a601280a@.phx.gbl...
> Hey thanks for the reply Tibor. I've been down that road
> before a couple years ago and didn't have a great deal of
> luck. I got it to work, but it wasn't very clean. I was
> just hoping for a tool to do it for me. However, I saw a
> reply from Sue under dbforums to the same question that
> had the following article listed:
> http://www.sqlmag.com/Articles/Index.cfm?ArticleID=15560
> It has a sp called usp_Scheduled_Jobs that will do it all
> for you....extremely nice and useful.
> Thanks,
> Van Jones
> MCDBA, MCSE, MCSA, MCAD
> >--Original Message--
> >How about a simple SQL Query, and put the output in
> Excel? The tables you
> >need to read from aren't that difficult to work with.
> Only mess is the
> >dateformat and frequency stuff, but there is some good
> stuff at
> >www.SQLDev.Net that help you with this.
> >
> >--
> >Tibor Karaszi, SQL Server MVP
> >Archive at:
> >http://groups.google.com/groups?
> oi=djq&as_ugroup=microsoft.public.sqlserver
> >
> >
> >"Van Jones" <anonymous@.discussions.microsoft.com> wrote
> in message
> >news:0dbd01c3a485$acb49fb0$a401280a@.phx.gbl...
> >> Does anyone know any tools or scripts to use for
> >> documenting SQL Jobs. I need to take the results and
> >> create an excel or word file for management. I would
> need
> >> it to list the job name, schedule, frequency...so on.
> >> Trying to script this is not easy in that the sysjobs
> and
> >> sysjobschedules tables use numbers to represent
> everything
> >> about the schedule and all.
> >>
> >> Any help is appreciated.
> >>
> >> Thanks,
> >>
> >> Van Jones
> >
> >
> >.
> >|||It's a reference to an article in SQL mag a couple of years
or so ago that has a pretty nice script to grab the job,
schedule, avg run time, max run time, some other properties.
It's pretty good - I've used it quite a bit with just a
couple modifications.
-Sue
On Thu, 6 Nov 2003 18:58:09 +0100, "Tibor Karaszi"
<tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
wrote:
>OK, I just wanted to point the option of using these tables, in case you
>haven't used them already. Yes, some things aren't that easy to deal with
>(mostly the freq- things, IMO). Hopefully Sue's proc will help you :-)