scheduling the job to process a dts package

I am new to sqlserver.

Could anybody please help me by giving me a syntax for the command in job schedular to run dts package

i enter the job name in the first screen of the wizard.

I entered the step name. type Transact SQL

database msdb

What should i enter in command text box

My dts package name is fullcube.

Thanks in advance

The easiest way to schedule a DTS package in SQL 2000 is to navigate to the package in Enterprise Manager, right click on the package and choose the "Schedule Package..." option.

This will create a SQL Agent job to execute the package, by default I think it encrypts the command line.

The other way to execute a DTS package is to use the DTexec command line utility. To get a list of the parameters for this utility, type in "DTEXEC /?" to a command line window. If you wanted to you could manually do what the "Schedule Package..." screen does and create a SQL job that has a CmdExec step that calls DTExec.

Scheduling SSIS Package

Hi

I am trying to scheduling package using "Executing Sql Server Agent Task" before that I create new job,But there is error in STEP "Command Line Parameter are Invalid"

Anybody help me for configure jobs for Scheduling

I am new to SQL Server

Thanks in Advance

Now I want to save package in MSDB database but its gives en error as follows

"Login timeout expired
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.
Named Pipes Provider: Could not open a connection to SQL Server [2]. "

Can anybody helpout for this error

Note : Whats modification in SQL Server Setting so did not get this error

Actually here i am trying to save a package in MSDB database for run package through Sql Server job

thnaks in advance for your help

|||

Hi,

I am new to SSIS but have worked on other ETL tools. I was trying to schedule and run a SSIS package using SQL Server Agent. I created the job but when i tried to make a step of the Job, it asks for a type of step in a drop down. I cant see the step type required for running the SSIS packages as mentioned in the help files.

Please help me on this.

Regards,

Samaksh

|||

Doesn't matter. Execute your packages from the cmdexec subsystem using dtexec. You will get more useful error messages as explained here: http://wiki.sqlis.com/default.aspx/SQLISWiki/ScheduledPackages.html

-Jamie

|||Don't you see the type "SQL Server Integration Services Package" as one option in the dropdown? If you choose that, you can select where your package is.|||

Yes, the help file says to look at the "SQL Server Integration Services Package" as the option in the drop down, but i am unable to see it as an option. I tried various ways to check if the i can get to it, but each time "SQL Server Integration Services Package" is not there as an option.

Can this be the issue with the licence of the product or something similar. Because this is bizarre that the option is not coming in the list.

Regards,

Samaksh

Scheduling SSIS Package

Hi

I am trying to scheduling package using "Executing Sql Server Agent Task" before that I create new job,But there is error in STEP "Command Line Parameter are Invalid"

Anybody help me for configure jobs for Scheduling

I am new to SQL Server

Thanks in Advance

Now I want to save package in MSDB database but its gives en error as follows

"Login timeout expired
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.
Named Pipes Provider: Could not open a connection to SQL Server [2]. "

Can anybody helpout for this error

Note : Whats modification in SQL Server Setting so did not get this error

Actually here i am trying to save a package in MSDB database for run package through Sql Server job

thnaks in advance for your help

|||

Hi,

I am new to SSIS but have worked on other ETL tools. I was trying to schedule and run a SSIS package using SQL Server Agent. I created the job but when i tried to make a step of the Job, it asks for a type of step in a drop down. I cant see the step type required for running the SSIS packages as mentioned in the help files.

Please help me on this.

Regards,

Samaksh

|||

Doesn't matter. Execute your packages from the cmdexec subsystem using dtexec. You will get more useful error messages as explained here: http://wiki.sqlis.com/default.aspx/SQLISWiki/ScheduledPackages.html

-Jamie

|||Don't you see the type "SQL Server Integration Services Package" as one option in the dropdown? If you choose that, you can select where your package is.|||

Yes, the help file says to look at the "SQL Server Integration Services Package" as the option in the drop down, but i am unable to see it as an option. I tried various ways to check if the i can get to it, but each time "SQL Server Integration Services Package" is not there as an option.

Can this be the issue with the licence of the product or something similar. Because this is bizarre that the option is not coming in the list.

Regards,

Samaksh

Scheduled SSIS

Hello all,

I was very familiar in creating quite complex DTS packages in SQL2000. Now with 2007 that is all gone. I looked at the command line utility and it's UI counter part but these are just for executing. I keep getting references to the SSIS designer but I can't find where it is.

Can someone point me in the right direction?

Thanks,

Jesse

So, dtsrun.exe has now become dtexec.exe and it's counterpart on the UI is dtexecui.exe. The UI you see in the UI there is the same type of ui you'll see in the SQL Server Agent job. You'll just simply need to select SQL Server Integration Services for the step type and you'll get the same screens.

Brian

|||The designer components is installed when you select Client/Workstation components during SQL Setup. Run SQL Server Business Intelligence Development Studio, create new Integration Services project, now you have a package to design.|||

Yes I did that but when I open SQL Server Business Intelligence Development Studio it just looks like a standard visual basic studio that there is nothing under new projects that says intergration services project.

Do I just have a bad install maybe?

|||BIDS is a standard Visual Studio, but in the New Project dialog it should contain Business Intelligence Projects folder, with Integration Services Project in it.|||

I found it!

I feal incredably greatfull to everyone that helped and incredably stupid for not spoting earlier.

Thank you all.

Scheduled SSIS

Hello all,

I was very familiar in creating quite complex DTS packages in SQL2000. Now with 2007 that is all gone. I looked at the command line utility and it's UI counter part but these are just for executing. I keep getting references to the SSIS designer but I can't find where it is.

Can someone point me in the right direction?

Thanks,

Jesse

So, dtsrun.exe has now become dtexec.exe and it's counterpart on the UI is dtexecui.exe. The UI you see in the UI there is the same type of ui you'll see in the SQL Server Agent job. You'll just simply need to select SQL Server Integration Services for the step type and you'll get the same screens.

Brian

|||The designer components is installed when you select Client/Workstation components during SQL Setup. Run SQL Server Business Intelligence Development Studio, create new Integration Services project, now you have a package to design.|||

Yes I did that but when I open SQL Server Business Intelligence Development Studio it just looks like a standard visual basic studio that there is nothing under new projects that says intergration services project.

Do I just have a bad install maybe?

|||BIDS is a standard Visual Studio, but in the New Project dialog it should contain Business Intelligence Projects folder, with Integration Services Project in it.|||

I found it!

I feal incredably greatfull to everyone that helped and incredably stupid for not spoting earlier.

Thank you all.

sql

schedule job backup

Hi there
I want to implement a job command at SQL Server 2000 that should allow the
following:
1. Do a backup to "xpto" database
2. the name generated by the backup should be:
21112006xpto.bak
22112006xpto.bak
...
21022007xpto.bak
After archiving 3 months the first backup craeted "21112006xpto.bak" should
be replaced by "21022007xpto.bak"
once i just want to stay the earlier 3 months.
Actually i use the following command:
BACKUP DATABASE [xpto] TO DISK = N'C:\Microsoft SQL
Server\MSSQL\BACKUP\xpto.BAK' WITH INIT , NOUNLOAD , NAME = N'xpto
backup', SKIP , STATS = 10, NOFORMAT
Can somenone help me or give some tips?...
[]
RickyHi
To create the file using a current date then you would need to use dynamic SQL
e.g.
DECLARE @.cmd varchar(1000)
SET @.cmd = 'BACKUP DATABASE [xpto] TO DISK = N''C:\Microsoft SQL
Server\MSSQL\BACKUP\' + CONVERT(char(8),GETDATE(),112) + 'xpto.BAK'' WITH
INIT , NOUNLOAD , NAME = N''xpto backup'', SKIP , STATS = 10, NOFORMAT'
EXEC (@.cmd)
This will give you are filename YYYYMMDDxpto.BAK. This is a better format as
the files can easily be sorted.
To delete older files check out:
http://realsqlguy.com/serendipity/archives/9-Out-With-The-Old.html
Alternatively a DTS package using an activeX script would be a way of
deleting old files see http://www.sqldts.com/default.aspx?292
John
"Ricky" wrote:
> Hi there
> I want to implement a job command at SQL Server 2000 that should allow the
> following:
> 1. Do a backup to "xpto" database
> 2. the name generated by the backup should be:
> 21112006xpto.bak
> 22112006xpto.bak
> ...
> 21022007xpto.bak
> After archiving 3 months the first backup craeted "21112006xpto.bak" should
> be replaced by "21022007xpto.bak"
> once i just want to stay the earlier 3 months.
> Actually i use the following command:
> BACKUP DATABASE [xpto] TO DISK = N'C:\Microsoft SQL
> Server\MSSQL\BACKUP\xpto.BAK' WITH INIT , NOUNLOAD , NAME = N'xpto
> backup', SKIP , STATS = 10, NOFORMAT
> Can somenone help me or give some tips?...
> []
> Ricky
>
>

schedule job backup

Hi there
I want to implement a job command at SQL Server 2000 that should allow the
following:
1. Do a backup to "xpto" database
2. the name generated by the backup should be:
21112006xpto.bak
22112006xpto.bak
...
21022007xpto.bak
After archiving 3 months the first backup craeted "21112006xpto.bak" should
be replaced by "21022007xpto.bak"
once i just want to stay the earlier 3 months.
Actually i use the following command:
BACKUP DATABASE [xpto] TO DISK = N'C:\Microsoft SQL
Server\MSSQL\BACKUP\xpto.BAK' WITH INIT , NOUNLOAD , NAME = N'xpto
backup', SKIP , STATS = 10, NOFORMAT
Can somenone help me or give some tips?...
[]
Ricky
Hi
To create the file using a current date then you would need to use dynamic SQL
e.g.
DECLARE @.cmd varchar(1000)
SET @.cmd = 'BACKUP DATABASE [xpto] TO DISK = N''C:\Microsoft SQL
Server\MSSQL\BACKUP\' + CONVERT(char(8),GETDATE(),112) + 'xpto.BAK'' WITH
INIT , NOUNLOAD , NAME = N''xpto backup'', SKIP , STATS = 10, NOFORMAT'
EXEC (@.cmd)
This will give you are filename YYYYMMDDxpto.BAK. This is a better format as
the files can easily be sorted.
To delete older files check out:
http://realsqlguy.com/serendipity/archives/9-Out-With-The-Old.html
Alternatively a DTS package using an activeX script would be a way of
deleting old files see http://www.sqldts.com/default.aspx?292
John
"Ricky" wrote:

> Hi there
> I want to implement a job command at SQL Server 2000 that should allow the
> following:
> 1. Do a backup to "xpto" database
> 2. the name generated by the backup should be:
> 21112006xpto.bak
> 22112006xpto.bak
> ...
> 21022007xpto.bak
> After archiving 3 months the first backup craeted "21112006xpto.bak" should
> be replaced by "21022007xpto.bak"
> once i just want to stay the earlier 3 months.
> Actually i use the following command:
> BACKUP DATABASE [xpto] TO DISK = N'C:\Microsoft SQL
> Server\MSSQL\BACKUP\xpto.BAK' WITH INIT , NOUNLOAD , NAME = N'xpto
> backup', SKIP , STATS = 10, NOFORMAT
> Can somenone help me or give some tips?...
> []
> Ricky
>
>

schedule job backup

Hi there
I want to implement a job command at SQL Server 2000 that should allow the
following:
1. Do a backup to "xpto" database
2. the name generated by the backup should be:
21112006xpto.bak
22112006xpto.bak
..
21022007xpto.bak
After archiving 3 months the first backup craeted "21112006xpto.bak" should
be replaced by "21022007xpto.bak"
once i just want to stay the earlier 3 months.
Actually i use the following command:
BACKUP DATABASE [xpto] TO DISK = N'C:\Microsoft SQL
Server\MSSQL\BACKUP\xpto.BAK' WITH INIT , NOUNLOAD , NAME = N'xpto
backup', SKIP , STATS = 10, NOFORMAT
Can somenone help me or give some tips?...
[]
RickyHi
To create the file using a current date then you would need to use dynamic S
QL
e.g.
DECLARE @.cmd varchar(1000)
SET @.cmd = 'BACKUP DATABASE [xpto] TO DISK = N''C:\Microsoft SQL
Server\MSSQL\BACKUP' + CONVERT(char(8),GETDATE(),112) + 'xpto.BAK'' WITH
INIT , NOUNLOAD , NAME = N''xpto backup'', SKIP , STATS = 10, NOFORMAT'
EXEC (@.cmd)
This will give you are filename YYYYMMDDxpto.BAK. This is a better format as
the files can easily be sorted.
To delete older files check out:
http://realsqlguy.com/serendipity/a...th-The-Old.html
Alternatively a DTS package using an activeX script would be a way of
deleting old files see http://www.sqldts.com/default.aspx?292
John
"Ricky" wrote:

> Hi there
> I want to implement a job command at SQL Server 2000 that should allow the
> following:
> 1. Do a backup to "xpto" database
> 2. the name generated by the backup should be:
> 21112006xpto.bak
> 22112006xpto.bak
> ...
> 21022007xpto.bak
> After archiving 3 months the first backup craeted "21112006xpto.bak" shoul
d
> be replaced by "21022007xpto.bak"
> once i just want to stay the earlier 3 months.
> Actually i use the following command:
> BACKUP DATABASE [xpto] TO DISK = N'C:\Microsoft SQL
> Server\MSSQL\BACKUP\xpto.BAK' WITH INIT , NOUNLOAD , NAME = N'xpto
> backup', SKIP , STATS = 10, NOFORMAT
> Can somenone help me or give some tips?...
> []
> Ricky
>
>

Schedule for the sqlagent from the command line

hi
How do I set-up a schedule for the sqlagent from the command line
/ErikErik,
presumably you're referring to a particular job rather than the agent, so
for this you'd need to use "sp_update_jobschedule".
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

Schedule for the sqlagent from the command line

hi
How do I set-up a schedule for the sqlagent from the command line
/Erik
Erik,
presumably you're referring to a particular job rather than the agent, so
for this you'd need to use "sp_update_jobschedule".
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

Schedule for the sqlagent from the command line

hi
How do I set-up a schedule for the sqlagent from the command line
/ErikErik,
presumably you're referring to a particular job rather than the agent, so
for this you'd need to use "sp_update_jobschedule".
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

Schedule cmdExec

How can I schedule a exe program from SQL server jobs ?
What is the CmdExec command I need to put in in order to
run a exe program call Test.exeJust put in the name and path to the exec file, like below:
C:\test.exe
Note that this file is executed on the *server*. Also, the program cannot open any windows (it need
to be a what we call "console" program).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Travis" <anonymous@.discussions.microsoft.com> wrote in message
news:135601c4ad16$9b197880$a301280a@.phx.gbl...
> How can I schedule a exe program from SQL server jobs ?
> What is the CmdExec command I need to put in in order to
> run a exe program call Test.exe|||My test.exe is created using vb6 for doing some extra
process.
I already try the "C:\Test.exe" but it not runnable.
>--Original Message--
>Just put in the name and path to the exec file, like
below:
>C:\test.exe
>Note that this file is executed on the *server*. Also,
the program cannot open any windows (it need
>to be a what we call "console" program).
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"Travis" <anonymous@.discussions.microsoft.com> wrote in
message
>news:135601c4ad16$9b197880$a301280a@.phx.gbl...
>> How can I schedule a exe program from SQL server jobs ?
>> What is the CmdExec command I need to put in in order
to
>> run a exe program call Test.exe
>
>.
>|||If you right-click the job and select "history", and in this dialog check "View Step Details", what
do you have for your jobstep?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Travis" <anonymous@.discussions.microsoft.com> wrote in message
news:283a01c4ad1c$700546a0$a601280a@.phx.gbl...
> My test.exe is created using vb6 for doing some extra
> process.
> I already try the "C:\Test.exe" but it not runnable.
>>--Original Message--
>>Just put in the name and path to the exec file, like
> below:
>>C:\test.exe
>>Note that this file is executed on the *server*. Also,
> the program cannot open any windows (it need
>>to be a what we call "console" program).
>>--
>>Tibor Karaszi, SQL Server MVP
>>http://www.karaszi.com/sqlserver/default.asp
>>http://www.solidqualitylearning.com/
>>
>>"Travis" <anonymous@.discussions.microsoft.com> wrote in
> message
>>news:135601c4ad16$9b197880$a301280a@.phx.gbl...
>> How can I schedule a exe program from SQL server jobs ?
>> What is the CmdExec command I need to put in in order
> to
>> run a exe program call Test.exe
>>
>>.|||When I check on the Windows Task Manager,I notice that the
program was start up but I don't know why it is not
runnable.
No jobs history is available because the program already
been executed but I'm sure the program it not run the
process because it takes very long time to execute
and I not get the desired result I need.
If I run the Test.exe manually , it takes about few seconds
to finish the process.
I need to manually terminate the Job since it seems like
hanging there.
Any other setting I need to configure ?
TQ for your info
>--Original Message--
>If you right-click the job and select "history", and in
this dialog check "View Step Details", what
>do you have for your jobstep?
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"Travis" <anonymous@.discussions.microsoft.com> wrote in
message
>news:283a01c4ad1c$700546a0$a601280a@.phx.gbl...
>> My test.exe is created using vb6 for doing some extra
>> process.
>> I already try the "C:\Test.exe" but it not runnable.
>>--Original Message--
>>Just put in the name and path to the exec file, like
>> below:
>>C:\test.exe
>>Note that this file is executed on the *server*. Also,
>> the program cannot open any windows (it need
>>to be a what we call "console" program).
>>--
>>Tibor Karaszi, SQL Server MVP
>>http://www.karaszi.com/sqlserver/default.asp
>>http://www.solidqualitylearning.com/
>>
>>"Travis" <anonymous@.discussions.microsoft.com> wrote in
>> message
>>news:135601c4ad16$9b197880$a301280a@.phx.gbl...
>> How can I schedule a exe program from SQL server
jobs ?
>> What is the CmdExec command I need to put in in order
>> to
>> run a exe program call Test.exe
>>
>>.
>
>.
>|||Are you 100% certain that the program doesn't display any window, or message box?`The symptoms you
describe is exactly what we see if we try starting programs that tries to display windows...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<anonymous@.discussions.microsoft.com> wrote in message
news:287301c4af7c$e0e05420$a301280a@.phx.gbl...
> When I check on the Windows Task Manager,I notice that the
> program was start up but I don't know why it is not
> runnable.
> No jobs history is available because the program already
> been executed but I'm sure the program it not run the
> process because it takes very long time to execute
> and I not get the desired result I need.
> If I run the Test.exe manually , it takes about few seconds
> to finish the process.
> I need to manually terminate the Job since it seems like
> hanging there.
> Any other setting I need to configure ?
> TQ for your info
>>--Original Message--
>>If you right-click the job and select "history", and in
> this dialog check "View Step Details", what
>>do you have for your jobstep?
>>--
>>Tibor Karaszi, SQL Server MVP
>>http://www.karaszi.com/sqlserver/default.asp
>>http://www.solidqualitylearning.com/
>>
>>"Travis" <anonymous@.discussions.microsoft.com> wrote in
> message
>>news:283a01c4ad1c$700546a0$a601280a@.phx.gbl...
>> My test.exe is created using vb6 for doing some extra
>> process.
>> I already try the "C:\Test.exe" but it not runnable.
>>--Original Message--
>>Just put in the name and path to the exec file, like
>> below:
>>C:\test.exe
>>Note that this file is executed on the *server*. Also,
>> the program cannot open any windows (it need
>>to be a what we call "console" program).
>>--
>>Tibor Karaszi, SQL Server MVP
>>http://www.karaszi.com/sqlserver/default.asp
>>http://www.solidqualitylearning.com/
>>
>>"Travis" <anonymous@.discussions.microsoft.com> wrote in
>> message
>>news:135601c4ad16$9b197880$a301280a@.phx.gbl...
>> How can I schedule a exe program from SQL server
> jobs ?
>> What is the CmdExec command I need to put in in order
>> to
>> run a exe program call Test.exe
>>
>>.
>>
>>.|||I m sure the program did not process ...because my program will just take few
seconds to complete and will display a msgbox after that ..
I wait for few minutes after execute the jobs but it seems like no process..
what is other posibility to cause it ?
"Tibor Karaszi" wrote:
> Are you 100% certain that the program doesn't display any window, or message box?`The symptoms you
> describe is exactly what we see if we try starting programs that tries to display windows...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> <anonymous@.discussions.microsoft.com> wrote in message
> news:287301c4af7c$e0e05420$a301280a@.phx.gbl...
> > When I check on the Windows Task Manager,I notice that the
> > program was start up but I don't know why it is not
> > runnable.
> >
> > No jobs history is available because the program already
> > been executed but I'm sure the program it not run the
> > process because it takes very long time to execute
> > and I not get the desired result I need.
> >
> > If I run the Test.exe manually , it takes about few seconds
> > to finish the process.
> >
> > I need to manually terminate the Job since it seems like
> > hanging there.
> >
> > Any other setting I need to configure ?
> >
> > TQ for your info
> >
> >>--Original Message--
> >>If you right-click the job and select "history", and in
> > this dialog check "View Step Details", what
> >>do you have for your jobstep?
> >>
> >>--
> >>Tibor Karaszi, SQL Server MVP
> >>http://www.karaszi.com/sqlserver/default.asp
> >>http://www.solidqualitylearning.com/
> >>
> >>
> >>"Travis" <anonymous@.discussions.microsoft.com> wrote in
> > message
> >>news:283a01c4ad1c$700546a0$a601280a@.phx.gbl...
> >> My test.exe is created using vb6 for doing some extra
> >> process.
> >> I already try the "C:\Test.exe" but it not runnable.
> >>
> >>--Original Message--
> >>Just put in the name and path to the exec file, like
> >> below:
> >>
> >>C:\test.exe
> >>
> >>Note that this file is executed on the *server*. Also,
> >> the program cannot open any windows (it need
> >>to be a what we call "console" program).
> >>
> >>--
> >>Tibor Karaszi, SQL Server MVP
> >>http://www.karaszi.com/sqlserver/default.asp
> >>http://www.solidqualitylearning.com/
> >>
> >>
> >>"Travis" <anonymous@.discussions.microsoft.com> wrote in
> >> message
> >>news:135601c4ad16$9b197880$a301280a@.phx.gbl...
> >> How can I schedule a exe program from SQL server
> > jobs ?
> >> What is the CmdExec command I need to put in in order
> >> to
> >> run a exe program call Test.exe
> >>
> >>
> >>.
> >>
> >>
> >>
> >>.
> >>
>
>|||If the program completes and displays a message box then it
does have a window or message box displaying. The command
will appear to hang but it is actually waiting for a
response to the message box or can't create the window. A
service such as SQL Server or SQL Server Agent can't respond
to user input (such as clicking the ok button on a message
box). You need to remove the message box. The exe can't have
any windows or user input.
-Sue
On Mon, 11 Oct 2004 19:49:07 -0700, Travis
<Travis@.discussions.microsoft.com> wrote:
>I m sure the program did not process ...because my program will just take few
>seconds to complete and will display a msgbox after that ..
>I wait for few minutes after execute the jobs but it seems like no process..
>what is other posibility to cause it ?
>"Tibor Karaszi" wrote:
>> Are you 100% certain that the program doesn't display any window, or message box?`The symptoms you
>> describe is exactly what we see if we try starting programs that tries to display windows...
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> <anonymous@.discussions.microsoft.com> wrote in message
>> news:287301c4af7c$e0e05420$a301280a@.phx.gbl...
>> > When I check on the Windows Task Manager,I notice that the
>> > program was start up but I don't know why it is not
>> > runnable.
>> >
>> > No jobs history is available because the program already
>> > been executed but I'm sure the program it not run the
>> > process because it takes very long time to execute
>> > and I not get the desired result I need.
>> >
>> > If I run the Test.exe manually , it takes about few seconds
>> > to finish the process.
>> >
>> > I need to manually terminate the Job since it seems like
>> > hanging there.
>> >
>> > Any other setting I need to configure ?
>> >
>> > TQ for your info
>> >
>> >>--Original Message--
>> >>If you right-click the job and select "history", and in
>> > this dialog check "View Step Details", what
>> >>do you have for your jobstep?
>> >>
>> >>--
>> >>Tibor Karaszi, SQL Server MVP
>> >>http://www.karaszi.com/sqlserver/default.asp
>> >>http://www.solidqualitylearning.com/
>> >>
>> >>
>> >>"Travis" <anonymous@.discussions.microsoft.com> wrote in
>> > message
>> >>news:283a01c4ad1c$700546a0$a601280a@.phx.gbl...
>> >> My test.exe is created using vb6 for doing some extra
>> >> process.
>> >> I already try the "C:\Test.exe" but it not runnable.
>> >>
>> >>--Original Message--
>> >>Just put in the name and path to the exec file, like
>> >> below:
>> >>
>> >>C:\test.exe
>> >>
>> >>Note that this file is executed on the *server*. Also,
>> >> the program cannot open any windows (it need
>> >>to be a what we call "console" program).
>> >>
>> >>--
>> >>Tibor Karaszi, SQL Server MVP
>> >>http://www.karaszi.com/sqlserver/default.asp
>> >>http://www.solidqualitylearning.com/
>> >>
>> >>
>> >>"Travis" <anonymous@.discussions.microsoft.com> wrote in
>> >> message
>> >>news:135601c4ad16$9b197880$a301280a@.phx.gbl...
>> >> How can I schedule a exe program from SQL server
>> > jobs ?
>> >> What is the CmdExec command I need to put in in order
>> >> to
>> >> run a exe program call Test.exe
>> >>
>> >>
>> >>.
>> >>
>> >>
>> >>
>> >>.
>> >>
>>

Schedule cmdExec

How can I schedule a exe program from SQL server jobs ?
What is the CmdExec command I need to put in in order to
run a exe program call Test.exe
Just put in the name and path to the exec file, like below:
C:\test.exe
Note that this file is executed on the *server*. Also, the program cannot open any windows (it need
to be a what we call "console" program).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Travis" <anonymous@.discussions.microsoft.com> wrote in message
news:135601c4ad16$9b197880$a301280a@.phx.gbl...
> How can I schedule a exe program from SQL server jobs ?
> What is the CmdExec command I need to put in in order to
> run a exe program call Test.exe
|||My test.exe is created using vb6 for doing some extra
process.
I already try the "C:\Test.exe" but it not runnable.

>--Original Message--
>Just put in the name and path to the exec file, like
below:
>C:\test.exe
>Note that this file is executed on the *server*. Also,
the program cannot open any windows (it need
>to be a what we call "console" program).
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"Travis" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:135601c4ad16$9b197880$a301280a@.phx.gbl...
to
>
>.
>
|||If you right-click the job and select "history", and in this dialog check "View Step Details", what
do you have for your jobstep?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Travis" <anonymous@.discussions.microsoft.com> wrote in message
news:283a01c4ad1c$700546a0$a601280a@.phx.gbl...[vbcol=seagreen]
> My test.exe is created using vb6 for doing some extra
> process.
> I already try the "C:\Test.exe" but it not runnable.
> below:
> the program cannot open any windows (it need
> message
> to
|||When I check on the Windows Task Manager,I notice that the
program was start up but I don't know why it is not
runnable.
No jobs history is available because the program already
been executed but I'm sure the program it not run the
process because it takes very long time to execute
and I not get the desired result I need.
If I run the Test.exe manually , it takes about few seconds
to finish the process.
I need to manually terminate the Job since it seems like
hanging there.
Any other setting I need to configure ?
TQ for your info

>--Original Message--
>If you right-click the job and select "history", and in
this dialog check "View Step Details", what
>do you have for your jobstep?
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"Travis" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:283a01c4ad1c$700546a0$a601280a@.phx.gbl...
jobs ?
>
>.
>
|||Are you 100% certain that the program doesn't display any window, or message box?`The symptoms you
describe is exactly what we see if we try starting programs that tries to display windows...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<anonymous@.discussions.microsoft.com> wrote in message
news:287301c4af7c$e0e05420$a301280a@.phx.gbl...[vbcol=seagreen]
> When I check on the Windows Task Manager,I notice that the
> program was start up but I don't know why it is not
> runnable.
> No jobs history is available because the program already
> been executed but I'm sure the program it not run the
> process because it takes very long time to execute
> and I not get the desired result I need.
> If I run the Test.exe manually , it takes about few seconds
> to finish the process.
> I need to manually terminate the Job since it seems like
> hanging there.
> Any other setting I need to configure ?
> TQ for your info
> this dialog check "View Step Details", what
> message
> jobs ?
|||If the program completes and displays a message box then it
does have a window or message box displaying. The command
will appear to hang but it is actually waiting for a
response to the message box or can't create the window. A
service such as SQL Server or SQL Server Agent can't respond
to user input (such as clicking the ok button on a message
box). You need to remove the message box. The exe can't have
any windows or user input.
-Sue
On Mon, 11 Oct 2004 19:49:07 -0700, Travis
<Travis@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>I m sure the program did not process ...because my program will just take few
>seconds to complete and will display a msgbox after that ..
>I wait for few minutes after execute the jobs but it seems like no process..
>what is other posibility to cause it ?
>"Tibor Karaszi" wrote: