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:
> 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.|||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...
> 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:
>> 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 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...
> > 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:
> >
> >> 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.
>|||Scroll up in the drop-down list, and you'll see it.
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...
> > > 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:
> > >
> > >> 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.
> >|||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:
> Scroll up in the drop-down list, and you'll see it.
> 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...
> > > > 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:
> > > >
> > > >> 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.
> > >|||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...
> 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:
>> Scroll up in the drop-down list, and you'll see it.
>> 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...
>> > > > 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:
>> > > >
>> > > >> 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.
>> > >|||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...
> 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:
>> Scroll up in the drop-down list, and you'll see it.
>> 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...
>> > > > 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:
>> > > >
>> > > >> 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.
>> > >|||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...
> > 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:
> >
> >> Scroll up in the drop-down list, and you'll see it.
> >>
> >> 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...
> >> > > > 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:
> >> > > >
> >> > > >> 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.
> >> > >
>|||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...
> > 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:
> >
> >> Scroll up in the drop-down list, and you'll see it.
> >>
> >> 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...
> >> > > > 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:
> >> > > >
> >> > > >> 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.
> >> > >
>
>|||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...
>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...
>> > 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:
>> >
>> >> Scroll up in the drop-down list, and you'll see it.
>> >>
>> >> 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...
>> >> > > > 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:
>> >> > > >
>> >> > > >> 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.
>> >> > >|||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...
> >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...
> >> > 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:
> >> >
> >> >> Scroll up in the drop-down list, and you'll see it.
> >> >>
> >> >> 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...
> >> >> > > > 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:
> >> >> > > >
> >> >> > > >> 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.
> >> >> > >
> >>
>|||I can't say 1005 it won't work, but I do know that we often see problems with the mere fact that a
program does GUI interaction. There might be some dependencies on OS version and/or SQL Server
version as well. So, I'd watch it carefully and since you do have an option to make it console app,
don't hesitate to do so in case it starts behaving fishy.
--
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:2DAD30AB-1FFF-4751-A060-7C6A357F47E5@.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...
>> >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...
>> >> > 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:
>> >> >
>> >> >> Scroll up in the drop-down list, and you'll see it.
>> >> >>
>> >> >> 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...
>> >> >> > > > 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:
>> >> >> > > >
>> >> >> > > >> 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.
>> >> >> > >
>> >>|||It looks like it worked, this was just for test so when I build the real
application I will make it into a console app.
--
Paul G
Software engineer.
"Tibor Karaszi" wrote:
> I can't say 1005 it won't work, but I do know that we often see problems with the mere fact that a
> program does GUI interaction. There might be some dependencies on OS version and/or SQL Server
> version as well. So, I'd watch it carefully and since you do have an option to make it console app,
> don't hesitate to do so in case it starts behaving fishy.
> --
> 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:2DAD30AB-1FFF-4751-A060-7C6A357F47E5@.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...
> >> >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...
> >> >> > 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:
> >> >> >
> >> >> >> Scroll up in the drop-down list, and you'll see it.
> >> >> >>
> >> >> >> 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...
> >> >> >> > > > 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:
> >> >> >> > > >
> >> >> >> > > >> 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.
> >> >> >> > >
> >> >>
> >>
>