Post reply

want to list out all thejobs that will be running on future date in SQL2000 and 2005 version.

  • January 22, 2014 at 3:29 am

    #303439

    Experts,

    Can someone help me with a query to find which all jobs will be running on 5th of next month from SQL 2000 and SQL 2005 SQL Servers ? Just want to list out all thejobs that will be running on future date in SQL2000 and 2005 version.

    Thanks in advance.

  • January 22, 2014 at 3:58 am

    #1682315

    There's a utility (it might even be free) that displays all your scheduled jobs in a calendar format. I'm afraid I don't know what it's called, but if you can find it, it may be just what you're looking for.

    John

  • January 22, 2014 at 4:25 am

    #1682322

    Joy Smith San (1/22/2014)

    Experts,

    Can someone help me with a query to find which all jobs will be running on 5th of next month from SQL 2000 and SQL 2005 SQL Servers ? Just want to list out all thejobs that will be running on future date in SQL2000 and 2005 version.

    Thanks in advance.

    + John

    Or create a centralized server and write your own script and run in CMS.

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

  • January 22, 2014 at 4:43 am

    #1682332

    I use a script (created by Omri Bahat, see: http://sqlmag.com/t-sql/plugging-gaps-sql-server-job-tracking) to find jobs that haven't run according to their schedule. Allthough this scripts investigate the past, you probably can modify it to query which jobs will run at a specific moment in the future.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply