Report of Job Activities

I need a report of all job monitoring activities. How can you run a report
out of SQL 2005 which list the reports by day, date and time
--
WPJLYou may want to be more specific on exactly what you'd like to accomplish.
Perhaps, an example would help.
Linchi
"WPJL" wrote:
> I need a report of all job monitoring activities. How can you run a report
> out of SQL 2005 which list the reports by day, date and time
> --
> WPJL|||WPJL
As Linchi said , to help you we need an exmaple
http://dimantdatabasesolutions.blogspot.com/2008/03/sql-server-agent-jobs-duration-report.html
"WPJL" <WPJL@.discussions.microsoft.com> wrote in message
news:CFA4269C-267E-4CE4-A53A-085FC22621B6@.microsoft.com...
>I need a report of all job monitoring activities. How can you run a report
> out of SQL 2005 which list the reports by day, date and time
> --
> WPJL|||I asked to create an analysis report of all jobs which run via SQL Service
Job Activity. The data that is needed is the day, date and time intervals
which each job runs. The requestors want a side by side analysis to view
specific jobs that run on the same day and time. We currently have
approximately 72 jobs which run via SQL server. To get the information into
a spread sheet, I had to open the job history and properties and manually
enter this information in an excel spreadsheet. This is very time consuming.
Examples of jobs â' Job A run everyday M-F at 6:00 a.m., Job B run M-F at
6:00 a.m., Job C may run everyday starting 12:00 a.m, until 12:00 midnight.
However, the job runs M_F, at time intervals of every 10 minutes. It starts
at 12:00, 12:10, 12:20 and so on.
I wanted to know if there was a way to query the Job Activity data out of
SQL query where I could create an analysis report which would show a
comparison of the days, dates and interval times that each report runs.
Thanks.
--
WPJL
"Linchi Shea" wrote:
> You may want to be more specific on exactly what you'd like to accomplish.
> Perhaps, an example would help.
> Linchi
> "WPJL" wrote:
> > I need a report of all job monitoring activities. How can you run a report
> > out of SQL 2005 which list the reports by day, date and time
> > --
> > WPJL