 |
|
| Computers Forum Index » Computer - Databases - MS SQL Server » Differences in SQL 2000/2005 jobs function... |
|
Page 1 of 1 |
|
| Author |
Message |
| dp... |
 Posted: Thu Oct 15, 2009 10:11 am |
|
|
|
Guest
|
Within the SQL Server Agent job function, there are some differences
between SQL 2000 and 2005 where the change in the new version is not
as useful as the earlier version, in my opinion.
To clarify:
In 2000 the scheduled jobs are listed under: Management - SQL Server
Agent - Jobs
in 2005 the scheduled jobs are listed under: SQL Server Agent - Jobs
The differences I am highlighting are:
1. When a job has failed in 2000, it is immediately noticable because
the job is listed with an indicator of a red cross, whereas in 2005
there is no such indicator and the only way to find a job failure is
to look in the job history (or of course use job alerting)
2. In the 2000 job listing there are some useful columns such as
"Category", "Last Run Status" and "Next Run Date" and from this it is
very easy to find which jobs are running next, to group jobs, etc. I
cannot see a way to add any such columns.
Are these differences correct or is there something I am missing or
not doing?
Any info or comments welcome.
thanks
Dipak |
|
|
| Back to top |
|
|
|
|
|
All times are GMT
The time now is Tue Nov 24, 2009 1:35 pm
|
|