Ever wanted to know which jobs are scheduled for the next day? Or for this weekend?
This procedure selects those jobs. You can specify the minimum runtime (default 15 minutes), a category and jobname filter.
Create this procedure in your own "DBA" database (references to MSDB tables are hardcoded)
Execute this procedure: exec usp_upcoming_jobschedules
Alter the default value of the parameters by specifying them.