[dba-SQLServer] SQL Server 2005: When is a job scheduled to run next

Hewson, Jim JHewson at nciinc.com
Tue Feb 24 13:59:00 CST 2009


You should have the option to review the Job Activity Monitor.
It will give you the Last Run Outcome, Last Run Time and the Next Run.
HTH

Jim


-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Rojas,
Joe
Sent: Tuesday, February 24, 2009 1:46 PM
To: Discussion concerning MS SQL Server
Subject: [dba-SQLServer] SQL Server 2005: When is a job scheduled to run
next

Hi All,

This must be a case of me just being blind.

In SQL Server 7, when you look at the jobs under the SQL Agent, it would
should things like last run time and next run time.
In 2005, all I see is the job name and whether or not it is running.
How can I see the next time a job is going to run?

Joe

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com

################################################################################
If you have received this message in error, please contact the sender
immediately and be aware that the use, copying, or dissemination of 
this information is prohibited. This email transmission contains 
information from NCI Information Systems, Inc. that may be considered 
privileged or confidential and is intended solely for the named 
recipient.
################################################################################




More information about the dba-SQLServer mailing list