Re: Scheduling a script

Hi

Look at SQL Server Agent in BOL. It can schedule jobs and run code.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@xxxxxxxxxxxx

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"Myth of Sisyphus)." <teller_117@xxxxxxxxxxx> wrote in message
news:iqRFe.4700$q23.748061@xxxxxxxxxxxxxxxxxxxxxxxx
>I wish to run this script daily. Can this be scheduled?
>
>
> backup log shipmateDB with truncate_only
>
>
> G
>
>


.

Relevant Pages

  • Re: Problem with 64-bit ODBC code and SQLConnect and SQLWCHAR
    ... SQL Server 2005 CTP questions to the community newsgroups: ... Mike Epprecht, Microsoft SQL Server MVP ... MVP Program: http://www.microsoft.com/mvp ...
    (microsoft.public.sqlserver.odbc)
  • Re: Scheduling a script
    ... It can schedule jobs and run code. ... Can I add though that this script is probably not a good idea. ... > Mike Epprecht, Microsoft SQL Server MVP ...
    (comp.databases.ms-sqlserver)
  • Re: Question about SQL Server 2005
    ... >> Mike Epprecht, Microsoft SQL Server MVP ... >> MVP Program: http://www.microsoft.com/mvp ... >> Blog: http://www.msmvps.com/epprecht/ ...
    (microsoft.public.sqlserver.setup)
  • Re: Insert picture
    ... Mike Epprecht, Microsoft SQL Server MVP ... MVP Program: http://www.microsoft.com/mvp ... > Access allows to insert manually an image into OLE Object type field very ...
    (microsoft.public.sqlserver.tools)
  • Re: Image save into folder
    ... Mike Epprecht, Microsoft SQL Server MVP ... >> Mike Epprecht, Microsoft SQL Server MVP ... >> Zurich, Switzerland ... >> MVP Program: http://www.microsoft.com/mvp ...
    (microsoft.public.sqlserver.clients)