Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2003
    Location
    Los Angeles
    Posts
    18

    Lightbulb Unanswered: auto running "app"

    Greeting all,

    I need something that will run on my server
    once every day, I need to query the DB,
    also I can't use any *.exe or *.dll files,
    currently using SQL Server 2k and ASP.

    just a thought - should I use the SQL Trigger ?
    Eddie.

  2. #2
    Join Date
    Nov 2002
    Location
    Singapore
    Posts
    17

    Re: auto running "app"

    Basically you can use the SQL Server Agent to do the trick.
    Schedule a job and fire the query in the job and it will run whenever you like

    Originally posted by ZeligOn
    Greeting all,

    I need something that will run on my server
    once every day, I need to query the DB,
    also I can't use any *.exe or *.dll files,
    currently using SQL Server 2k and ASP.

    just a thought - should I use the SQL Trigger ?

  3. #3
    Join Date
    Feb 2003
    Location
    Los Angeles
    Posts
    18

    Question BUT . . .

    Can I send an email thru the Agent ?

    U C, I need to check every day witch user to charge,
    if so than to charge his CC and send him an email.
    Last edited by ZeligOn; 02-26-03 at 21:37.
    Eddie.

  4. #4
    Join Date
    Jul 2002
    Location
    Australia
    Posts
    147
    Yes you can send email though the agent, as you would have found if you researched it yourself for 2 minutes.

    Are you using a shared server as you will need to configure it.

    Search SQL Books On Line for more info.

    Another method is to use a sheduled task on the server if you have the permissions to set it up.

    Cheers,
    Andrew
    There have been many posts made throughout the world.
    This was one of them.

  5. #5
    Join Date
    Feb 2003
    Location
    Los Angeles
    Posts
    18

    Arrow

    Originally posted by Bunce
    Yes you can send email though the agent, as you would have found if you researched it yourself for 2 minutes.
    I know that I can send an email
    form the sql server but didn't explain my self good enough,
    the thing is that I want to send an customized email
    from my ASP, I need to know if there is a target that activate
    my script on the server just like user is making a request..

    also I can't configure the SQL Server or the
    IIS Server as boat are sherd with others . . .
    Eddie.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •