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...
>|||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...
>|||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...
it[vbcol=seagreen]
automaticly[vbcol=seagreen]
>|||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...
it[vbcol=seagreen]
automaticly[vbcol=seagreen]
>|||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...
> SQL
> Line.
> it
> automaticly
>|||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...
launch[vbcol=seagreen]
to[vbcol=seagreen]
>