schedule structure

Hi,
I need to set up the schedule for email remainder for my users. It will be very similiar to the schedule in MS SQL server. I would like to see the data structure of sql schedules. where can I see it? any suggestions on how to do it? ThanksYou will find these in msdb. Have a look at sysjobs,sysjobsteps and
sysjobschedules
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Jen" <anonymous@.discussions.microsoft.com> wrote in message
news:20D70C27-D893-4CA7-AD46-9E95D8BD3E2F@.microsoft.com...
> Hi,
> I need to set up the schedule for email remainder for my users. It will be
very similiar to the schedule in MS SQL server. I would like to see the data
structure of sql schedules. where can I see it? any suggestions on how to do
it? Thanks|||Thanks. in sysjobschedules table, the column freq_type, freq_interval, freq_subday_type, freq_subday_interval, freq_relatice_interval, freq_recurrence_factor all have numbers, what are these numbers referred? I mean if I can know what the data means I can understand better about the column like freq_subday_type. Thank
-- Jasper Smith wrote: --
You will find these in msdb. Have a look at sysjobs,sysjobsteps an
sysjobschedule
--
HT
Jasper Smith (SQL Server MVP
I support PASS - the definitive, globa
community for SQL Server professionals
http://www.sqlpass.or
"Jen" <anonymous@.discussions.microsoft.com> wrote in messag
news:20D70C27-D893-4CA7-AD46-9E95D8BD3E2F@.microsoft.com..
> Hi
>> I need to set up the schedule for email remainder for my users. It will b
very similiar to the schedule in MS SQL server. I would like to see the dat
structure of sql schedules. where can I see it? any suggestions on how to d
it? Thank