schedule structure

Hi,
I need to set up the schedule for email remainder for my users. It will be v
ery 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_f
actor all have numbers, what are these numbers referred? I mean if I can kno
w what the data means I can
understand better about the column like freq_subday_type. Thanks
-- Jasper Smith wrote: --
You 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,
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