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.
> >> >> >> > >
> >> >>
> >>
>

run sql script at a specific time

I have an sql statement that I can run by hand. How do I get a job to run this automatically.
I have tried to create a job and it just failes out every time...You need to give more information. What does your job do. What job steps are executed. What error messages are generated...
Start by setting the job to log messages to a file for review.|||Sorry for the late response here is my sql statement:

use intranet;
INSERT INTO USER_INFO (fpu_id,FIRSTNAME, LASTNAME, BOXNUMBER) SELECT id,first,last,box FROM stmailbox WHERE id NOT IN (SELECT FPU_ID FROM USER_INFO);

And when I go through the DTS screens. Telling DTS to copy data from a 3 column temp database to a permanent database called USER_INFO I get a warning that says "LINE 3 incorrect syntax near ')'" This is for the create table steps....

Under the next line I get, Invalid Opject named results...

I am new to DTS,

Any help would be good|||You are still not making any sense.
In your first post you say you have a job that is failing. In your second post you are talking about a DTS package.
You list some SQL code, but not how this has anything to do with your DTS package. Your error "LINE 3 incorrect syntax near ')'" doesn't even make sense given that your code only has two lines. I don't even know whether your error is referring to your SQL statement or code within your DTS package.

Run reports on specific reports server

If I have a web farm can I specify which web server the report should
be processed on?
ie. I have two reporting servers, but one of my servers is closer to
the database than the other (better WAN connection string). Can I
specify which web server the report is processed on?
Similar to in Seagate Info, where from Info desktop I can specify
which APS server to run the report on at run-time.
If not, is this functionality planned for a future update on the
product?
Also is client side printing coming out any time soon?
Regards,
Tom Olthoff
OT Solutions, Inc.can ou access your reportserver through another HTTP port or header name?
instead-of accessing your report through
http://myweb.company.com/reportserver change it to
http://mycloserweb.company.com/reportserver or
http://myweb.company.com:8180/reportserver
but you have to do this in your client application.
or, maybe you can use a redirector (or URL rewriter).
"OT Solutions, sales" <OTSolutions@.shaw.ca> a écrit dans le message de news:
df21d456.0412051703.19c8b627@.posting.google.com...
> If I have a web farm can I specify which web server the report should
> be processed on?
> ie. I have two reporting servers, but one of my servers is closer to
> the database than the other (better WAN connection string). Can I
> specify which web server the report is processed on?
> Similar to in Seagate Info, where from Info desktop I can specify
> which APS server to run the report on at run-time.
> If not, is this functionality planned for a future update on the
> product?
> Also is client side printing coming out any time soon?
> Regards,
> Tom Olthoff
> OT Solutions, Inc.

Run Report with specific Records.

I am not sure where i should post this question since it falls both in Report Server and T-Sql but here goes...

I currently need to run a Report that has only specified records that the client/user wants by clicking the check in the check box next to the record they want. They can pick as many or a few of the records that want then run a report only with the records they indicated they wanted... i am thinking they will need some kind of t-sql statement either a function or temp table but i am not sure if even that...

if anyone has any ideas please reply...

Thanks,
WoFe

EXAMPLE: Instead of running a report on records 1, 2, 3, 4, 5, 6, 7, 8, 9
they would run the report on records: 2, 5, 6, 9

You need to use a multivalue parameter. There is a tutorial here
http://msdn2.microsoft.com/en-us/library/aa337432.aspx