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. ################################################################################