Job Execution Dates/Times Calculation (Past and Future Execution)

Question

Viewing 4 posts - 16 through 19 (of 19 total)

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

SwePeso SSC-Dedicated Points: 39758 More actions · Answer 1

Code is taken from my blog here

N 56°04'39.16"
E 12°55'05.25"

Jerry Hung SSChampion Points: 12968 More actions · Answer 2

Thanks for the script Peso

I am making a little modification to it so that startTime and endTime will use the infoDate date

otherwise it keeps showing "1900-01-01 05:00:00.000" for a Daily 5 am job

SQLServerNewbieMCITP: Database Administrator SQL Server 2005

SwePeso SSC-Dedicated Points: 39758 More actions · Answer 3

Where did you make that change?

Post back and I will update the blog post.

N 56°04'39.16"
E 12°55'05.25"

Carsten Cumbrowski Right there with Babe Points: 766 More actions · Answer 4

Good Job Peso, thanks a lot. I also posted a response at the SQLTeam forums. 🙂

Cheers!

Carsten Cumbrowski
MS SQL Server Resources Meta Search Engine
SQLHunt.com[/url]