Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databasesSince this weekend is Daylight Savings, we want to make sure of any jobs that won't run due to the "missing hour". I have written a small query against sysjobschedules that tells me which ones have a schedule that runs between 2 and 3. However, it doesn't include any jobs that run every X minutes/hours, and so might be run during that time. (i.e. a job that starts at midnight and runs until 6, running every 2 hours) Is there any (easy) way to determine this? I might be able to build a function that uses the other fields in sysjobschedules to give a list of times that the job will run, but I haven't gotten to that point yet. Figured someone might have something already, rather than reinvent the wheel. Thanks, Michael
Post Follow-up to this messageI don't believe there's any easy way, but sysjobhistory might be a good starting point - if a job ran between 2 and 3 in the past, it will probably do so again. You could join on sysjobschedules to narrow it down to daily schedules, schedules on a certain weekday or date etc. And you can check the next_run_date column as well, of course. Simon
Post Follow-up to this message
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread