running application

I need to run an application that sends out automatic emails based on
specific conditions. I need to schedule this to run every evening, could it
be scheduled as one of the SQL server agent jobs, using sql2000 or is there
another way to schedule it? Thanks.
Paul G
Software engineer.
That sounds like a strainghtforward job for SQLAgent.
Linchi
"Paul" wrote:

> I need to run an application that sends out automatic emails based on
> specific conditions. I need to schedule this to run every evening, could it
> be scheduled as one of the SQL server agent jobs, using sql2000 or is there
> another way to schedule it? Thanks.
> --
> Paul G
> Software engineer.
|||thanks for the response. I can not use windows scheduler because of computer
restrictions but for example what command in SQL would I use to run the
executable called test.exe located at C:\?
Doesn't it have to be transact SQL to run out SQlAgent?
Paul.
Paul G
Software engineer.
"Linchi Shea" wrote:
[vbcol=seagreen]
> That sounds like a strainghtforward job for SQLAgent.
> Linchi
> "Paul" wrote:
|||Thanks for the response. I am using SQL 2000 but under the step types I only
see the following listed;
Replication Transaction-Log Reader
Replication Queue Reader
Replication Snapshot
Replication Merge
Tansact-SQL script
did not see a cmdExec type.
Paul G
Software engineer.
"Tibor Karaszi" wrote:

> A job has one or more jobsteps. There are different type of jobsteps. TSQL is for executing SQL
> commands, while CmdExec is for executing EXE files etc.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:4310F194-2BAB-4F52-BE75-4A6D019A3388@.microsoft.com...
>
|||Scroll up in the drop-down list, and you'll see it.
Linchi
"Paul" wrote:
[vbcol=seagreen]
> Thanks for the response. I am using SQL 2000 but under the step types I only
> see the following listed;
> Replication Transaction-Log Reader
> Replication Queue Reader
> Replication Snapshot
> Replication Merge
> Tansact-SQL script
> did not see a cmdExec type.
>
>
> --
> Paul G
> Software engineer.
>
> "Tibor Karaszi" wrote:
|||found it, thanks! so for the command I just use c:/test.exe to run the
executable called test.exe at location c:?
Paul G
Software engineer.
"Linchi Shea" wrote:
[vbcol=seagreen]
> Scroll up in the drop-down list, and you'll see it.
> Linchi
> "Paul" wrote:
|||Try it and see. Better yet, reference Books Online (for 2005 the link is
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/51352afc-a0a4-428b-8985-f9e58bb57c31.htm)
and see the explicit example there.
BOL are your friend!
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:9FBC9A5D-3985-40F5-A268-45F2AEC68CBA@.microsoft.com...[vbcol=seagreen]
> found it, thanks! so for the command I just use c:/test.exe to run the
> executable called test.exe at location c:?
> --
> Paul G
> Software engineer.
>
> "Linchi Shea" wrote:
|||I currently have it has a windows app but I have the window closing at the
end of the program so no gui is left open.
Paul G
Software engineer.
"Tibor Karaszi" wrote:

> Yep. Just make sure that the program is a console program (no GUI element), since it is started by a
> service...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:9FBC9A5D-3985-40F5-A268-45F2AEC68CBA@.microsoft.com...
>
|||yep the books on line are quite helpful although sometimes I have difficulty
comming up with the correct search string. thanks.
Paul G
Software engineer.
"TheSQLGuru" wrote:

> Try it and see. Better yet, reference Books Online (for 2005 the link is
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/51352afc-a0a4-428b-8985-f9e58bb57c31.htm)
> and see the explicit example there.
> BOL are your friend!
> --
> Kevin G. Boles
> Indicium Resources, Inc.
> SQL Server MVP
> kgboles a earthlink dt net
>
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:9FBC9A5D-3985-40F5-A268-45F2AEC68CBA@.microsoft.com...
>
>
|||ok thanks I will try it, just wondering if it will work, I can just as easily
create a new console application with vs.net as well.
Paul G
Software engineer.
"Tibor Karaszi" wrote:

> That will probably not work, since a service has no window context at all. I.e., the windows API
> calls will make the program fail. But you could give it a go and see what happens.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:F605C191-3233-42B2-BB7A-41D9A6D1D9E5@.microsoft.com...
>