Wednesday, March 7, 2012

msdb.dbo.sysjobschedules less columns

msdb.dbo.sysjobschedules shows columns
scheduke_id,job_id,next_rundate,next_run
_time in MS Sqlserver 2005 beta3.
but the document (help) tells "name","enabled","freq_type","freq_interval"
too.
These columns were present in MS sqlserver 2000.
1. Is it that, some configuration is missing in my sql server 2005 beta3 DB?
2. or Do I need to do join with some other view/table to get these details.
Best regards,
Amit Kumar.Dear Amit,
I've got the CTP June for Sql Server 2005 and it happens the same.
""This topic is pre-release documentation and is subject to change in future
releases. Blank topics are included as placeholders.]""
Best regards,
"Amit Kumar" wrote:

> msdb.dbo.sysjobschedules shows columns
> scheduke_id,job_id,next_rundate,next_run
_time in MS Sqlserver 2005 beta3.
> but the document (help) tells "name","enabled","freq_type","freq_interval"
> too.
> These columns were present in MS sqlserver 2000.
> 1. Is it that, some configuration is missing in my sql server 2005 beta3 D
B?
> 2. or Do I need to do join with some other view/table to get these details
.
> Best regards,
> Amit Kumar.
>

No comments:

Post a Comment