automatic script with SQL Server 2000

Hello,
Newbie question:
How can you set a SQL Server 2000 script which will launch automaticly every
day ?
Thanks for your help!One way would be to create a SQL Server JOB, and designate the time to
execute. (That 'JOB' could be running a Stored Procedure -for example.)
--
Arnie Rowland*
"To be successful, your heart must accompany your knowledge."
"Newbie" <newbie@.beginers.com> wrote in message
news:Of6IaxGpGHA.3600@.TK2MSFTNGP04.phx.gbl...
> Hello,
> Newbie question:
> How can you set a SQL Server 2000 script which will launch automaticly
> every
> day ?
> Thanks for your help!
>
>|||Thanks Arnie,
The script is alredy written. How can I create the job which'll launch it ?
(NB : I'm a very beginner;-)
Thanks again
"Arnie Rowland" <arnie@.1568.com> a écrit dans le message de
news:udsgS%23GpGHA.3324@.TK2MSFTNGP05.phx.gbl...
> One way would be to create a SQL Server JOB, and designate the time to
> execute. (That 'JOB' could be running a Stored Procedure -for example.)
> --
> Arnie Rowland*
> "To be successful, your heart must accompany your knowledge."
>
> "Newbie" <newbie@.beginers.com> wrote in message
> news:Of6IaxGpGHA.3600@.TK2MSFTNGP04.phx.gbl...
> > Hello,
> > Newbie question:
> > How can you set a SQL Server 2000 script which will launch automaticly
> > every
> > day ?
> > Thanks for your help!
> >
> >
> >
>|||In Enterprise Mangler, expand down through your server until you get to SQL
Server Agent, and then Jobs.
Right click on the right pane, and select 'New Job'. Most of the rest will
be reasonably explanitory. You can look up SQL Agent Jobs in Books on Line.
Arnie Rowland*
"To be successful, your heart must accompany your knowledge."
"Newbie" <newbie@.beginers.com> wrote in message
news:Oyd1ZGHpGHA.4188@.TK2MSFTNGP03.phx.gbl...
> Thanks Arnie,
> The script is alredy written. How can I create the job which'll launch it
> ?
> (NB : I'm a very beginner;-)
> Thanks again
> "Arnie Rowland" <arnie@.1568.com> a écrit dans le message de
> news:udsgS%23GpGHA.3324@.TK2MSFTNGP05.phx.gbl...
>> One way would be to create a SQL Server JOB, and designate the time to
>> execute. (That 'JOB' could be running a Stored Procedure -for example.)
>> --
>> Arnie Rowland*
>> "To be successful, your heart must accompany your knowledge."
>>
>> "Newbie" <newbie@.beginers.com> wrote in message
>> news:Of6IaxGpGHA.3600@.TK2MSFTNGP04.phx.gbl...
>> > Hello,
>> > Newbie question:
>> > How can you set a SQL Server 2000 script which will launch automaticly
>> > every
>> > day ?
>> > Thanks for your help!
>> >
>> >
>> >
>>
>|||Thanks a lot Arnie !
That's great !
Newbie
"Arnie Rowland" <arnie@.1568.com> a écrit dans le message de
news:%23NBhNaHpGHA.3564@.TK2MSFTNGP03.phx.gbl...
> In Enterprise Mangler, expand down through your server until you get to
SQL
> Server Agent, and then Jobs.
> Right click on the right pane, and select 'New Job'. Most of the rest will
> be reasonably explanitory. You can look up SQL Agent Jobs in Books on
Line.
>
> --
> Arnie Rowland*
> "To be successful, your heart must accompany your knowledge."
>
> "Newbie" <newbie@.beginers.com> wrote in message
> news:Oyd1ZGHpGHA.4188@.TK2MSFTNGP03.phx.gbl...
> > Thanks Arnie,
> > The script is alredy written. How can I create the job which'll launch
it
> > ?
> > (NB : I'm a very beginner;-)
> > Thanks again
> >
> > "Arnie Rowland" <arnie@.1568.com> a écrit dans le message de
> > news:udsgS%23GpGHA.3324@.TK2MSFTNGP05.phx.gbl...
> >> One way would be to create a SQL Server JOB, and designate the time to
> >> execute. (That 'JOB' could be running a Stored Procedure -for example.)
> >>
> >> --
> >> Arnie Rowland*
> >> "To be successful, your heart must accompany your knowledge."
> >>
> >>
> >>
> >> "Newbie" <newbie@.beginers.com> wrote in message
> >> news:Of6IaxGpGHA.3600@.TK2MSFTNGP04.phx.gbl...
> >> > Hello,
> >> > Newbie question:
> >> > How can you set a SQL Server 2000 script which will launch
automaticly
> >> > every
> >> > day ?
> >> > Thanks for your help!
> >> >
> >> >
> >> >
> >>
> >>
> >
> >
>|||Arnie,
In the Command section of the New job Step, how I said to launch the
ScriptXX ?
"Arnie Rowland" <arnie@.1568.com> a écrit dans le message de
news:%23NBhNaHpGHA.3564@.TK2MSFTNGP03.phx.gbl...
> In Enterprise Mangler, expand down through your server until you get to
SQL
> Server Agent, and then Jobs.
> Right click on the right pane, and select 'New Job'. Most of the rest will
> be reasonably explanitory. You can look up SQL Agent Jobs in Books on
Line.
>
> --
> Arnie Rowland*
> "To be successful, your heart must accompany your knowledge."
>
> "Newbie" <newbie@.beginers.com> wrote in message
> news:Oyd1ZGHpGHA.4188@.TK2MSFTNGP03.phx.gbl...
> > Thanks Arnie,
> > The script is alredy written. How can I create the job which'll launch
it
> > ?
> > (NB : I'm a very beginner;-)
> > Thanks again
> >
> > "Arnie Rowland" <arnie@.1568.com> a écrit dans le message de
> > news:udsgS%23GpGHA.3324@.TK2MSFTNGP05.phx.gbl...
> >> One way would be to create a SQL Server JOB, and designate the time to
> >> execute. (That 'JOB' could be running a Stored Procedure -for example.)
> >>
> >> --
> >> Arnie Rowland*
> >> "To be successful, your heart must accompany your knowledge."
> >>
> >>
> >>
> >> "Newbie" <newbie@.beginers.com> wrote in message
> >> news:Of6IaxGpGHA.3600@.TK2MSFTNGP04.phx.gbl...
> >> > Hello,
> >> > Newbie question:
> >> > How can you set a SQL Server 2000 script which will launch
automaticly
> >> > every
> >> > day ?
> >> > Thanks for your help!
> >> >
> >> >
> >> >
> >>
> >>
> >
> >
>|||You can just copy and paste the script into the window.
--
Arnie Rowland*
"To be successful, your heart must accompany your knowledge."
"Newbie" <newbie@.beginers.com> wrote in message
news:ONmdioHpGHA.1140@.TK2MSFTNGP05.phx.gbl...
> Arnie,
> In the Command section of the New job Step, how I said to launch the
> ScriptXX ?
> "Arnie Rowland" <arnie@.1568.com> a écrit dans le message de
> news:%23NBhNaHpGHA.3564@.TK2MSFTNGP03.phx.gbl...
>> In Enterprise Mangler, expand down through your server until you get to
> SQL
>> Server Agent, and then Jobs.
>> Right click on the right pane, and select 'New Job'. Most of the rest
>> will
>> be reasonably explanitory. You can look up SQL Agent Jobs in Books on
> Line.
>>
>> --
>> Arnie Rowland*
>> "To be successful, your heart must accompany your knowledge."
>>
>> "Newbie" <newbie@.beginers.com> wrote in message
>> news:Oyd1ZGHpGHA.4188@.TK2MSFTNGP03.phx.gbl...
>> > Thanks Arnie,
>> > The script is alredy written. How can I create the job which'll launch
> it
>> > ?
>> > (NB : I'm a very beginner;-)
>> > Thanks again
>> >
>> > "Arnie Rowland" <arnie@.1568.com> a écrit dans le message de
>> > news:udsgS%23GpGHA.3324@.TK2MSFTNGP05.phx.gbl...
>> >> One way would be to create a SQL Server JOB, and designate the time to
>> >> execute. (That 'JOB' could be running a Stored Procedure -for
>> >> example.)
>> >>
>> >> --
>> >> Arnie Rowland*
>> >> "To be successful, your heart must accompany your knowledge."
>> >>
>> >>
>> >>
>> >> "Newbie" <newbie@.beginers.com> wrote in message
>> >> news:Of6IaxGpGHA.3600@.TK2MSFTNGP04.phx.gbl...
>> >> > Hello,
>> >> > Newbie question:
>> >> > How can you set a SQL Server 2000 script which will launch
> automaticly
>> >> > every
>> >> > day ?
>> >> > Thanks for your help!
>> >> >
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >
>>
>|||Arnie,
Thanks a lot !
"Arnie Rowland" <arnie@.1568.com> a écrit dans le message de
news:Oz9bVGJpGHA.756@.TK2MSFTNGP05.phx.gbl...
> You can just copy and paste the script into the window.
> --
> Arnie Rowland*
> "To be successful, your heart must accompany your knowledge."
>
> "Newbie" <newbie@.beginers.com> wrote in message
> news:ONmdioHpGHA.1140@.TK2MSFTNGP05.phx.gbl...
> > Arnie,
> > In the Command section of the New job Step, how I said to launch the
> > ScriptXX ?
> >
> > "Arnie Rowland" <arnie@.1568.com> a écrit dans le message de
> > news:%23NBhNaHpGHA.3564@.TK2MSFTNGP03.phx.gbl...
> >> In Enterprise Mangler, expand down through your server until you get to
> > SQL
> >> Server Agent, and then Jobs.
> >>
> >> Right click on the right pane, and select 'New Job'. Most of the rest
> >> will
> >> be reasonably explanitory. You can look up SQL Agent Jobs in Books on
> > Line.
> >>
> >>
> >> --
> >> Arnie Rowland*
> >> "To be successful, your heart must accompany your knowledge."
> >>
> >>
> >>
> >> "Newbie" <newbie@.beginers.com> wrote in message
> >> news:Oyd1ZGHpGHA.4188@.TK2MSFTNGP03.phx.gbl...
> >> > Thanks Arnie,
> >> > The script is alredy written. How can I create the job which'll
launch
> > it
> >> > ?
> >> > (NB : I'm a very beginner;-)
> >> > Thanks again
> >> >
> >> > "Arnie Rowland" <arnie@.1568.com> a écrit dans le message de
> >> > news:udsgS%23GpGHA.3324@.TK2MSFTNGP05.phx.gbl...
> >> >> One way would be to create a SQL Server JOB, and designate the time
to
> >> >> execute. (That 'JOB' could be running a Stored Procedure -for
> >> >> example.)
> >> >>
> >> >> --
> >> >> Arnie Rowland*
> >> >> "To be successful, your heart must accompany your knowledge."
> >> >>
> >> >>
> >> >>
> >> >> "Newbie" <newbie@.beginers.com> wrote in message
> >> >> news:Of6IaxGpGHA.3600@.TK2MSFTNGP04.phx.gbl...
> >> >> > Hello,
> >> >> > Newbie question:
> >> >> > How can you set a SQL Server 2000 script which will launch
> > automaticly
> >> >> > every
> >> >> > day ?
> >> >> > Thanks for your help!
> >> >> >
> >> >> >
> >> >> >
> >> >>
> >> >>
> >> >
> >> >
> >>
> >>
> >
> >
>