Re: Automating a job

From: John316 (bobmcc_at_tricoequipment.com)
Date: 09/14/04


Date: Tue, 14 Sep 2004 13:31:15 -0400

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

  • Re: expect script doesnt pass graphics chars correctly
    ... My expect script needs to automate login to a terminal server which is ...
    (comp.lang.tcl)
  • Re: Newbie php problem
    ... The OP said that their script would send email without ... Another common way is that spam bots will hit commonly ... you betcha he would automate it soon enough. ...
    (alt.php)
  • Re: Calling all Custom DTS Gurus!
    ... I need to check within an existing DTS package on how to check if the ... source field exists before I map to a destination field. ... I get error messages and the vb script doesn't work. ... tranformation it gives me the error: "Some of your transformations ...
    (microsoft.public.sqlserver.dts)
  • Re: OO-COBOL for Unisys IX
    ... >>Our biggest problem is that our configuration management system has been ... >>scripted to automate a mainframe compile from a ... >> us to try to script that, then send the intermediate results up to the ...
    (comp.lang.cobol)
  • Re: Newbie php problem
    ... The OP said that their script would send email without ... CAPTCHA images are hackable/readable by the bots, ... you betcha he would automate it soon enough. ... contact form could have anything to do with its action script. ...
    (alt.php)