Posted by Bryan on 09/14/06 08:34

I thought you had it there :) Its a doozy I guesss

thanks for trying anyway

Bryan


treschaud33@yahoo.com wrote:
> treschau...@yahoo.com wrote:
> > This is for SQL 2000. Running msdb..sp_help_job will display the
> > information. I dug through the msdb..sp_help_jobschedule and put the
> > following query together:
> >
> > select name
> > ,cast(left(cast(next_run_date as varchar),4)+'-'+
> > substring(cast(next_run_date as
> > varchar),5,2)+'-'+right(cast(next_run_date as varchar),2) +' '+
> > left(cast(next_run_time as varchar),2)+':'+substring(cast(next_run_time
> > as varchar),3,2)+':'+right(cast(next_run_time as varchar),2) as
> > datetime) "Next_Run"
> > from msdb..sysjobschedules
> >
> > Converting the next_run_date and next_run_time columns got kind of
> > messy, but it works.
>
> This is not as good I hope. If the job isn't going to run until
> tomorrow the next_run_date and next_run_time columns are zero.

• Next in forum: SQLRef - Website Created by Programmer to Programmers
• Prev in forum: Re: The user does not have permission to perform this action.
• Thread view: Re: Recurring Scheduled Job

[Reply to this message]