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: 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: VB Scripting
    ... In that script file, you can set the machine to log in as a domain user on ... the next reboot. ... install scripts for your programs. ... > Is it possible to automate logging an XP PC onto a domain ...
    (microsoft.public.windowsxp.setup_deployment)
  • SSH Scripting/Automation, How To?
    ... I need to automate a connection from a Win2k machine to a Sun machine ... The script should automatically log in, ... Username = 'myusername' ... sendln Username ...
    (comp.security.ssh)