Date parsed: 18/10/2007 21:10:19
Date: Thu, 18 Oct 2007 21:10:19 -0000
Excellent! Thank ya'll so much!!
On Oct 18, 3:59 pm, "Tibor Karaszi"
<tibor_please.no.email_kara...@hotmail.nomail.com> wrote:
> Create an Agent job with one or several job steps containing your TSQL (o=
r whatever) code. Schedule
> this job to be executed when Agent starts.
>
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asp=
http://sqlblog.com/blogs/tibor_karaszi>
> "traceable1" <thham...@gmail.com> wrote in message
>
> news:1192739683.702442.18160@k35g2000prh.googlegroups.com...
>
> Thank you so much for your feedback!
>
> So how exactly would I set up the script to run when the Agent starts?
>
> On Oct 18, 1:27 pm, "Tibor Karaszi"
>
>
>
> <tibor_please.no.email_kara...@hotmail.nomail.com> wrote:
> > Actually, one can claim that your alternative, Ekrem, is a cleaner solu=
tion than mine. I.e., it
> > might feel better to have a client app (Agent) execute whatever TSQL co=
mmands you want to run
> > instead of the database engine. (Of course, if one only start the engin=
e and not Agent, then the
> > script will not be executed.)
>
> > Good thinking. :-)
>
> > --
> > Tibor Karaszi, SQL Server
> > MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs=
/=2E..
>
> > "Ekrem =D6nsoy" <ek...@btegitim.com> wrote in message
>
> >news:1890C2B6-7DD2-40AE-AF10-01981F3ABD51@microsoft.com...
>
> > > Alternatively you can create a job to run your stuff which starts whe=
n SQL Server Agent
> > > starts...
> > > (may not be as good as Tibor's suggestion :) but I already said, it's=
just an alternative)
>
> > > --
> > > Ekrem =D6nsoy
>
> > > "traceable1" <thham...@gmail.com> wrote in message
> > >news:1192722595.538697.92480@y27g2000pre.googlegroups.com...
>
> > >> Is there a way I can set up a SQL script to run when the instance
> > >> starts up?
> > >> SQL Server 2005 SP2
>
> > >> thanks!- Hide quoted text -
>
> > - Show quoted text -- Hide quoted text -
>
> - Show quoted text -
