Re: Automating a job

From: mgm (mgm_at_discussions.microsoft.com)
Date: 09/14/04 

Date: Tue, 14 Sep 2004 11:29:02 -0700

Ok, I tried it, however I don't have a lot of permissions on that database so
it won't allow me to save the dts package on that server. Can I create it on
my machine since I'm running SQL server too? Can it query the other database
and save the results back on my machine in a text file? I'm still not sure
how I get the mail to be sent daily as well. I've never dealt with dts
packages before.
 

"John316" wrote:

> Create a dts package then right click and select schedule package
> hth
> bob mcclellan
>
> "mgm" <mgm@discussions.microsoft.com> wrote in message
> news:6AF67D5A-C51D-40B9-BA02-052066480D0F@microsoft.com...
> > Hello, I have automated very very little and it was some time ago when I
> > did.
> > I have a new job and I would like to automate one mundane task I have to
> > do
> > every day.
> >
> > Every day I run a query in query analyzer and if there are results I send
> > them to someone in an email. I have a vb script which uses Windows
> > Scripting
> > Host that can be incorporated into what I want to do. I just don't know
> > where to start. Can someone help me with a starting point as to how I can
> > accomplish this?
> >
> > Thanks!
> > Geniene
>
>
>

Relevant Pages

  • PHP+informix -922, -25582 errors
    ... User apache ... I have simple script i.php with simple query to database: ... Unable to connect to Informix Database ...
    (alt.php)
  • Re: i love php but php loves mysql and mysql hates me
    ... // This script adds a entry to the database. ... // Execute the query. ... // This script retrieves header and body text from the database. ...
    (php.general)
  • Re: [PHP] Newbie question, Which way is best?
    ... When the form calls the script it passes all the parameters that the script ... SELECT query, as is, back to the same script with a way to change just the ... As a relative newbie my self I think I understand what you are trying to do. ... If potental attackers have access to your field names they can much easier try and insert stuff into your database. ...
    (php.general)
  • Re: Query Help
    ... > objects in any database. ... that parcitular script is executed, I somehow tought that it shouln't put it ... Unless I misunderstand your tables and query, ... I have seen execution plans where the subquery gets ...
    (microsoft.public.sqlserver.programming)
  • Re: Automatic Scheduled Import
    ... query to import the data I'd write a script using the DAO library to ... create and execute the query without using Access itself; ... trouble of installing Access on the server). ... >I have a database on a shared server. ...
    (microsoft.public.access.externaldata)