RSS Text Data Mining: 2012

Friday, March 30, 2012

Running both 2000 & 2005 ?

Is it possible to run SqlServer 2000 & 2005 on the same Server? We're
only a small company with 1 server, and we'd like to try 2005 without
losing access to our 2000 databases.Jon
Yes , it is.
"Jon Brunson" <JonBrunson@.NOSPAMinnovationsoftwareDOTcoPERIODuk> wrote in
message news:egCB1uJAGHA.3296@.TK2MSFTNGP12.phx.gbl...
> Is it possible to run SqlServer 2000 & 2005 on the same Server? We're only
> a small company with 1 server, and we'd like to try 2005 without losing
> access to our 2000 databases.|||Hi
Yes, they are supported side-by-side. The 2nd instance has to be a named
instance "servername\instancename", but otherwise, the 2 reside happily
together.
Don't forget, since you have 2 DB engines on 1 server, they have to share
resources, including RAM, so don't expect both to run at 100% if you are
beating both hard.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Jon Brunson" <JonBrunson@.NOSPAMinnovationsoftwareDOTcoPERIODuk> wrote in
message news:egCB1uJAGHA.3296@.TK2MSFTNGP12.phx.gbl...
> Is it possible to run SqlServer 2000 & 2005 on the same Server? We're only
> a small company with 1 server, and we'd like to try 2005 without losing
> access to our 2000 databases.|||Thank-you Mike & Uri for your prompt (and unexpected!) replies.
Mike Epprecht (SQL MVP) wrote:
> Hi
> Yes, they are supported side-by-side. The 2nd instance has to be a named
> instance "servername\instancename", but otherwise, the 2 reside happily
> together.
> Don't forget, since you have 2 DB engines on 1 server, they have to share
> resources, including RAM, so don't expect both to run at 100% if you are
> beating both hard.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Jon Brunson" <JonBrunson@.NOSPAMinnovationsoftwareDOTcoPERIODuk> wrote in
> message news:egCB1uJAGHA.3296@.TK2MSFTNGP12.phx.gbl...
>>Is it possible to run SqlServer 2000 & 2005 on the same Server? We're only
>>a small company with 1 server, and we'd like to try 2005 without losing
>>access to our 2000 databases.
>
>

Running BCP from a webserver

I am executing BCP within a web application. SQL Server
client is not installed on the web server there although
we have copied the BCP.exe and BCP.RLL, an error message
displays saying it is missing the Resource Library. What
are my options to get this work?
Robert Complusman (anonymous@.discussions.microsoft.com) writes:
> I am executing BCP within a web application. SQL Server
> client is not installed on the web server there although
> we have copied the BCP.exe and BCP.RLL, an error message
> displays saying it is missing the Resource Library. What
> are my options to get this work?
The simplest would be to run the SQL Server install on the web server,
and install "Tools and utilities only". Now, whether this is
compliant with your license, I don't know.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
|||Hi
Maybe you would be better using Bulk Insert?
You may also want to consider using a DTS job to get (FTP) the file and put
it onto a different server, then process it.
John
"Robert Complusman" <anonymous@.discussions.microsoft.com> wrote in message
news:1974701c44cc6$df510140$a001280a@.phx.gbl...
> I am executing BCP within a web application. SQL Server
> client is not installed on the web server there although
> we have copied the BCP.exe and BCP.RLL, an error message
> displays saying it is missing the Resource Library. What
> are my options to get this work?
sql

Running batches of reports

Hi,
we are making an interesting use of report services...we are actually
using it to generate programming specification for Informatica Mappings
from our mapping spreadsheets..LOL!!
Anyway, we have a couple of hundre mapping specifications and we want
to generate the couple of hundred PDFs associated with those
mappings...I recall reading in my hitchhikers guide how to do this but
that book is about 1,500 miles away from me at the moment.
Would anyone be kind enough to please share the command I need to enter
at the command line to run a report with specific parameters and spit
the output into a specific PDF file also specified as a parameter. I'd
be ever so grateful to not have to wait a few days to go home and read
my book!!
Thanks
Peter
www.peternolan.comHi All,
I got somewhere on this.....if I export and save I get this on the
address line of the browser...
http://ger-eutst/ReportServer?%2fIDW+Reports%2fMetadata%2fMIN0102A+-+Infa+Mappings+Detailed+Documentation&spreadsheet_name=StagingToODSMappingOAP&spreadsheet_version=V00.14&mapping_name=m_ODS_MTL_DEMAND&rs%3aCommand=Render&rs%3AFormat=PDF
So, surely there is some way to enter some kind of similar command via
a command line or via an vb.net program to capture a list of such
pdsf....
Anybody done this before?
Thanks
Peter
www.peternolan.com

Running bat files in SSIS

Folks -

Did you have any success when running bat files (Execute Process Task) from SSIS through SQL Server Agent jobs? My package will succeed when I run it from my machine, when I ask the DBA to run it manually from the Server but not when we run from a job.

The job will hang and the bat file does not seem to be executed. The executable property does evaluate to the right path and the package owner does have write/execute permissions in the folder where the bat file is located.

Everything I could find close to that is under <http://support.microsoft.com/kb/918760>. Would you shed any light on this? When I run the same bat file from a DTS through SQL Server Agent job, it will work with no issues. Any help would be very much appreciated.

Thanks.

Does the batch file have any prompts that require user input?|||

What is SQL Agent Service account running with?

Is it the same account that you are your DBA use - when running the package manually?

Because when you run the job - it runs with the credential of SQL Agent account.

|||Phil, thxs 4 your reply. No prompts that will require user input. The bat file will do a ftp. Thanks again.|||

How do I check what is SQL Agent Service account running my job? I know when I run the pkg manually it will run under my ID.

I do own the SQL Agent job in the Development environment so the DBA told me that my ID should be trying to execute the bat file (as I said before my ID has the permissions so there is something very strange happening). She said when I move to MO it will be owned by SA.

I can't go to MO if it is not working in DEV Wink

Thanks for your reply.

|||If you are using the SSIS job step to run the package, it runs under the service account that the Agent is set up to use, not the job owner's account. Try setting up a proxy account - check books online for details.|||

Hi,

It's simple. Use an Execute Process Task.

Double Click the Task, Under Process Tab, set the values for the following properties:

1) Executable = cmd.exe

2) Arguments = /c C:\BatchFolder\MyFile.bat.

Make Sure when you run the job, The Service account that runs your job should have access to this batch file.

Thanks

Subhash Subramanyam

|||

Jwelch -

There is a proxy account set by the DBA already... When we add a step to a job, for type we do "Operating system (CmdExec)" and for run as we do "SQLAgentJobProxy".

So... Do you believe this proxy account is the one with no access to run the bat file?

Thanks.

|||

That would be my guess.

Also, is the bat file located on a local drive, network share with UNC path, or a mapped drive?

|||Network share with UNC path.|||Might try copying it locally and see if that makes a difference.|||

I don't have Integration Services installed locally. I will check with the DBA on the permissions mentioned here and I will let you guys know.

Thanks.

|||

Folks,

The feedback I had from my DBA was that the SQLAgentProxyAccount does have access to execute the bat file in question... This is proved when I run a dts through the same job and the same bat file is fired successfully. She also agreed that the Executable Property in the Execute Process Task step was evaluating correctly.

So, our work-around was to remove the bat file execution from the SSIS pkg and add it to the second step of the job. Dirty and scary if you think that the ftp might not be the last step of a whole process. In my case, thanks to God it is... But since we have lack of time right now, this is the solution we put in place.

I would say the issue is still not clarified but I will mark this as closed and if somebody in the future runs into the same problem a new thread could be opened.

Thanks to all.

Running bat files in SSIS

Folks -

Thanks.

Does the batch file have any prompts that require user input?|||

What is SQL Agent Service account running with?

Is it the same account that you are your DBA use - when running the package manually?

Because when you run the job - it runs with the credential of SQL Agent account.

|||Phil, thxs 4 your reply. No prompts that will require user input. The bat file will do a ftp. Thanks again.|||

How do I check what is SQL Agent Service account running my job? I know when I run the pkg manually it will run under my ID.

I can't go to MO if it is not working in DEV Wink

Thanks for your reply.

Hi,

It's simple. Use an Execute Process Task.

Double Click the Task, Under Process Tab, set the values for the following properties:

1) Executable = cmd.exe

2) Arguments = /c C:\BatchFolder\MyFile.bat.

Make Sure when you run the job, The Service account that runs your job should have access to this batch file.

Thanks

Subhash Subramanyam

|||

Jwelch -

There is a proxy account set by the DBA already... When we add a step to a job, for type we do "Operating system (CmdExec)" and for run as we do "SQLAgentJobProxy".

So... Do you believe this proxy account is the one with no access to run the bat file?

Thanks.

|||

That would be my guess.

Also, is the bat file located on a local drive, network share with UNC path, or a mapped drive?

|||Network share with UNC path.|||Might try copying it locally and see if that makes a difference.|||

I don't have Integration Services installed locally. I will check with the DBA on the permissions mentioned here and I will let you guys know.

Thanks.

|||

Folks,

I would say the issue is still not clarified but I will mark this as closed and if somebody in the future runs into the same problem a new thread could be opened.

Thanks to all.

Running Backup through Maintenance Plan

I am receiving an Event 208 when running our autmated backup in Enterprise
Manager. The job use to run fine however possibly a change in password
caused this to stop working? The error states:
Event Type:Warning
Event Source:SQLSERVERAGENT
Event Category:Job Engine
Event ID:208
Date:11/21/2006
Time:8:45:00 AM
User:N/A
Computer:CROMWELL-DBPROD
Description:
SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'DB
Maintenance Plan1'' (0x8E8A44BEA81D964CAAF7E3F3338674D3) - Status: Failed -
Invoked on: 2006-11-21 08:45:00 - Message: The job failed. The owner () of
job DB Backup Job for DB Maintenance Plan 'DB Maintenance Plan1' does not
have server access.
How can I become owner of this job?
Check the properties for the job named
DB Backup Job for DB Maintenance Plan 'DB Maintenance Plan1'
and change the owner to your login if you want to be the
owner.
-Sue
On Tue, 21 Nov 2006 06:57:02 -0800, Andrew Harlan
<AndrewHarlan@.discussions.microsoft.com> wrote:

>I am receiving an Event 208 when running our autmated backup in Enterprise
>Manager. The job use to run fine however possibly a change in password
>caused this to stop working? The error states:
>Event Type:Warning
>Event Source:SQLSERVERAGENT
>Event Category:Job Engine
>Event ID:208
>Date:11/21/2006
>Time:8:45:00 AM
>User:N/A
>Computer:CROMWELL-DBPROD
>Description:
>SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'DB
>Maintenance Plan1'' (0x8E8A44BEA81D964CAAF7E3F3338674D3) - Status: Failed -
>Invoked on: 2006-11-21 08:45:00 - Message: The job failed. The owner () of
>job DB Backup Job for DB Maintenance Plan 'DB Maintenance Plan1' does not
>have server access.
>
>How can I become owner of this job?

Running Backup Jobs

Hi everyone
I have a SQL Server 2005. On this server is a database that only a handfull
of users may access - This excludes the normal IT people such as Domain
Admins etc. Only problem is that if I remove BuiltIn\Administrators from the
sysadmin server role I am no longer able to do backups of the database. If I
leave the BuiltIn\Administrator in the SysAdmin role they can access the
database.
Any help would be appriciated.
Thanks.
Regards
JonasJonas
By default all members of Administrators group have login SQL Server .
What is an account SQL Server Agent running under? Is it Local Account?
Create a user domain account/group on the box SQL Server running on. Change
Sql Server Agent's/MSSqlService account to this new one but make sure that
this account has an appropriate permissions to access the network
"Jonas Larsen" <JonasLarsen@.discussions.microsoft.com> wrote in message
news:C06D17CC-95A2-48A3-BFD7-6288CA2918BE@.microsoft.com...
> Hi everyone
> I have a SQL Server 2005. On this server is a database that only a
> handfull
> of users may access - This excludes the normal IT people such as Domain
> Admins etc. Only problem is that if I remove BuiltIn\Administrators from
> the
> sysadmin server role I am no longer able to do backups of the database. If
> I
> leave the BuiltIn\Administrator in the SysAdmin role they can access the
> database.
> Any help would be appriciated.
> Thanks.
> Regards
> Jonas|||Thanks for that. The Agent was running Local System, changed that as
suggested and then removed builtin admin from the sysadmin role. Everything
works.
"Uri Dimant" wrote:

> Jonas
> By default all members of Administrators group have login SQL Server .
> What is an account SQL Server Agent running under? Is it Local Account?
> Create a user domain account/group on the box SQL Server running on. Chan
ge
> Sql Server Agent's/MSSqlService account to this new one but make sure that
> this account has an appropriate permissions to access the network
>
>
> "Jonas Larsen" <JonasLarsen@.discussions.microsoft.com> wrote in message
> news:C06D17CC-95A2-48A3-BFD7-6288CA2918BE@.microsoft.com...
>
>sql

running backup and restore...

I had my IT dept. install sql server 2005 enterprise edition on a new windows server 2003. All other machines are running sql 2000 server on windows server 2000. I am a sa and local admin on all servers. I tried performing copy database, backup and restore and detach and attach to upgrade the sql server 2000 databases to 2005 and all fail. They also installed sql server 2005 sp2. I followed all steps. It's like the servers dont talk to each other. Their all on the company's domain. I am wondering if something happen with the install but the IT dept. insist that everything went fine. It's strange that I can't perform a simple backup and restore it on the new server buy when I click on restore it doesn't let me browse to get the backup file on the 2000 server. I never had a problem in Sql 2000 with backup. Can it be the installation was corrupted somehow. It seems fine. I haven't created any new databases because I wanted to move the databases from sql 2000. Can anyone help me get a clue of what the problem is please?

ThanksSounds like the service account for the SQL Server 2005 service has no network rights. Try copying the backup file locally, then doing the restore.

Running as another user

SQL Server 2000
I've been looking for a way to test something as another SQL Server user in
T-SQL (linked servers). The only way I can come up with is something like
this:
EXEC xp_cmdshell('osql -U TestLogin -P password -q "Select * FROM
Server.DB.Owner.Table"')
Seems kinda kludgy. Is this all that's available, or is there a cleaner way?Jay,
If you are testing interactively, then in SQL Server 2000 Query Analyzer you
can login a new query session as TestLogin. (If you always use QA in
Windows Authentication, just click the SQL Authentication radio button, then
enter TestLogin and password.) That would probably be better than running
OSQL scripts.
In SQL Server 2000 the SETUSER command will allow you to imitate another
user if you are sysadmin. But a linked server will not allow SETUSER
credentials through the link, so that is no help to you.
RLF
"Jay" <spam@.nospam.org> wrote in message
news:u5HSQeEAIHA.5184@.TK2MSFTNGP02.phx.gbl...
> SQL Server 2000
> I've been looking for a way to test something as another SQL Server user
> in T-SQL (linked servers). The only way I can come up with is something
> like this:
> EXEC xp_cmdshell('osql -U TestLogin -P password -q "Select * FROM
> Server.DB.Owner.Table"')
> Seems kinda kludgy. Is this all that's available, or is there a cleaner
> way?
>|||You can configure the security information in the linked server
configuration panel.
"Jay" <spam@.nospam.org> wrote in message
news:u5HSQeEAIHA.5184@.TK2MSFTNGP02.phx.gbl...
> SQL Server 2000
> I've been looking for a way to test something as another SQL Server user
> in T-SQL (linked servers). The only way I can come up with is something
> like this:
> EXEC xp_cmdshell('osql -U TestLogin -P password -q "Select * FROM
> Server.DB.Owner.Table"')
> Seems kinda kludgy. Is this all that's available, or is there a cleaner
> way?
>|||> You can configure the security information in the linked server
> configuration panel.
I'm doing this completly in T-SQL so I have scripts to run on all servers in
the farm. The only use of EM and clicking on Linked Servers is to find what
I'm looking for, or resetting things when I screw up.
However, that said, I fail to see how that helps me test the configuration.
>
> "Jay" <spam@.nospam.org> wrote in message
> news:u5HSQeEAIHA.5184@.TK2MSFTNGP02.phx.gbl...
>> SQL Server 2000
>> I've been looking for a way to test something as another SQL Server user
>> in T-SQL (linked servers). The only way I can come up with is something
>> like this:
>> EXEC xp_cmdshell('osql -U TestLogin -P password -q "Select * FROM
>> Server.DB.Owner.Table"')
>> Seems kinda kludgy. Is this all that's available, or is there a cleaner
>> way?
>|||Good ideas, thank you. I will test them shortly.
"Russell Fields" <russellfields@.nomail.com> wrote in message
news:OW1zakEAIHA.3848@.TK2MSFTNGP05.phx.gbl...
> Jay,
> If you are testing interactively, then in SQL Server 2000 Query Analyzer
> you can login a new query session as TestLogin. (If you always use QA in
> Windows Authentication, just click the SQL Authentication radio button,
> then enter TestLogin and password.) That would probably be better than
> running OSQL scripts.
> In SQL Server 2000 the SETUSER command will allow you to imitate another
> user if you are sysadmin. But a linked server will not allow SETUSER
> credentials through the link, so that is no help to you.
> RLF
> "Jay" <spam@.nospam.org> wrote in message
> news:u5HSQeEAIHA.5184@.TK2MSFTNGP02.phx.gbl...
>> SQL Server 2000
>> I've been looking for a way to test something as another SQL Server user
>> in T-SQL (linked servers). The only way I can come up with is something
>> like this:
>> EXEC xp_cmdshell('osql -U TestLogin -P password -q "Select * FROM
>> Server.DB.Owner.Table"')
>> Seems kinda kludgy. Is this all that's available, or is there a cleaner
>> way?
>|||And, just a FWIW, when you move to 2005, you have this beautiful EXECUTE AS command (which can be
used both at login or user level).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Jay" <spam@.nospam.org> wrote in message news:uWKmlsEAIHA.320@.TK2MSFTNGP04.phx.gbl...
> Good ideas, thank you. I will test them shortly.
> "Russell Fields" <russellfields@.nomail.com> wrote in message
> news:OW1zakEAIHA.3848@.TK2MSFTNGP05.phx.gbl...
>> Jay,
>> If you are testing interactively, then in SQL Server 2000 Query Analyzer you can login a new
>> query session as TestLogin. (If you always use QA in Windows Authentication, just click the SQL
>> Authentication radio button, then enter TestLogin and password.) That would probably be better
>> than running OSQL scripts.
>> In SQL Server 2000 the SETUSER command will allow you to imitate another user if you are
>> sysadmin. But a linked server will not allow SETUSER credentials through the link, so that is no
>> help to you.
>> RLF
>> "Jay" <spam@.nospam.org> wrote in message news:u5HSQeEAIHA.5184@.TK2MSFTNGP02.phx.gbl...
>> SQL Server 2000
>> I've been looking for a way to test something as another SQL Server user in T-SQL (linked
>> servers). The only way I can come up with is something like this:
>> EXEC xp_cmdshell('osql -U TestLogin -P password -q "Select * FROM Server.DB.Owner.Table"')
>> Seems kinda kludgy. Is this all that's available, or is there a cleaner way?
>>
>|||I saw that in the 2005 docs, but ignored it (which was hard to do).
It seems that there is only enough money in the budget to either get a SAN,
or upgrade to 2005. Given that choice, we'll be on 2000 for another 1-4
years and if too much time goes by, we'll be going from 2000, to 2008.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:FD5708A7-D8B8-4D90-8FB7-8AEA8A57D2CA@.microsoft.com...
> And, just a FWIW, when you move to 2005, you have this beautiful EXECUTE
> AS command (which can be used both at login or user level).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Jay" <spam@.nospam.org> wrote in message
> news:uWKmlsEAIHA.320@.TK2MSFTNGP04.phx.gbl...
>> Good ideas, thank you. I will test them shortly.
>> "Russell Fields" <russellfields@.nomail.com> wrote in message
>> news:OW1zakEAIHA.3848@.TK2MSFTNGP05.phx.gbl...
>> Jay,
>> If you are testing interactively, then in SQL Server 2000 Query Analyzer
>> you can login a new query session as TestLogin. (If you always use QA
>> in Windows Authentication, just click the SQL Authentication radio
>> button, then enter TestLogin and password.) That would probably be
>> better than running OSQL scripts.
>> In SQL Server 2000 the SETUSER command will allow you to imitate another
>> user if you are sysadmin. But a linked server will not allow SETUSER
>> credentials through the link, so that is no help to you.
>> RLF
>> "Jay" <spam@.nospam.org> wrote in message
>> news:u5HSQeEAIHA.5184@.TK2MSFTNGP02.phx.gbl...
>> SQL Server 2000
>> I've been looking for a way to test something as another SQL Server
>> user in T-SQL (linked servers). The only way I can come up with is
>> something like this:
>> EXEC xp_cmdshell('osql -U TestLogin -P password -q "Select * FROM
>> Server.DB.Owner.Table"')
>> Seems kinda kludgy. Is this all that's available, or is there a cleaner
>> way?
>>
>>
>

running AS 2000 and AS 2005 on same hardware...

Is it possible to run analysis services 2000 and analysis services 2005
on the same computer?
I'm looking to migrate, but need to run production in both environments
concurrently until we're ready...eric.schleicher@.gmail.com wrote:
> Is it possible to run analysis services 2000 and analysis services 2005
> on the same computer?
> I'm looking to migrate, but need to run production in both environments
> concurrently until we're ready...
>
not tried it myself, but I believe not|||I found that you can run them concurrently, one just has to install the
AS2005 as a named instance (as AS2000 does not support "non default"
instances)

running AS 2000 and AS 2005 on same hardware...

Is it possible to run analysis services 2000 and analysis services 2005
on the same computer?
I'm looking to migrate, but need to run production in both environments
concurrently until we're ready...
eric.schleicher@.gmail.com wrote:
> Is it possible to run analysis services 2000 and analysis services 2005
> on the same computer?
> I'm looking to migrate, but need to run production in both environments
> concurrently until we're ready...
>
not tried it myself, but I believe not
|||I found that you can run them concurrently, one just has to install the
AS2005 as a named instance (as AS2000 does not support "non default"
instances)

running AS 2000 and AS 2005 on same hardware...

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

Running and sleeping processes

Hi there,
Can somebody tell me the differences between SLEEPING and RUNNING
processes? I cannot find an explaination in BOL. If there is a thread on
this issue somewhere, can you put a link?
Tnx,
Hans Brouwer
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!sleeping status indicates that the SPID has completed execution and is
waiting for the application to submit another query or batch. A runnable
status indicates the SPID is currently processing a query
See
INF: Understanding and Resolving SQL Server 7.0 or 2000 Blocking Problems
PSS ID Number: 224453
--
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Hans Brouwer" <hansbrouwer@.hotmail.com> wrote in message
news:u$XIjMJlDHA.2500@.TK2MSFTNGP10.phx.gbl...
> Hi there,
> Can somebody tell me the differences between SLEEPING and RUNNING
> processes? I cannot find an explaination in BOL. If there is a thread on
> this issue somewhere, can you put a link?
> Tnx,
> Hans Brouwer
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

running and exporting report using visual basic 6.0 (not using .net)

Hello,
I saw the post below that it is possible if we develop programs with C# or
VB.NET.
My question is
Is it possible to develop the program using visual basic 6.0?
If so, which reporting services dll should be referenced in visual basic 6.0
project?
Could you explain in detail what to do in visual studio IDE environment?
Thanks in advance,
StpnK
<<copied from the previous posts>>
>Yes, Reporting Services provide a set of Web Services API that you can call
>to generate report. Form your client app project (Win Form App), set web
>reference to the reporting services and look into its Render() methods. You
>can also learn more aboubt this from SQL Server2005 Book on Line.
>
"Smugliy" <Smugliy@.discussions.microsoft.com> wrote in message
news:184E2D63-E618-4C35-A0C5-5F3A647B3803@.microsoft.com...
> Hello ,All
> I am new to the reporting services and my question maybe stupid .
>
> I created some report and published it on the server.
> Now my question is : does it possible at all to run this report from my
> client (in C# )and to export the result to CSV format also from client
> Is there any web service that I can use which is calling for my report
> ?
> Please ,help me to understand this .
> Thanks a lot.
> Smugliy
>
>
>You would have to use the soap toolkit and do lots and lots of roll your own
coding. And even then there might be some incompatibilities.
Your best bet is to use URL integration. This is very straight forward and
easy to implement. Generate the URL string, embed the IE browser control (if
all you want to do is show the report) and set the url for the control.
There are lots of examples on the web of how to embed the browser control
and set the URL.
Books online has lots of examples of URL integration.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"stpnK" <ssdfatepano917@.optonline.net> wrote in message
news:47f3122d$0$15166$607ed4bc@.cv.net...
> Hello,
> I saw the post below that it is possible if we develop programs with C# or
> VB.NET.
> My question is
> Is it possible to develop the program using visual basic 6.0?
> If so, which reporting services dll should be referenced in visual basic
> 6.0 project?
> Could you explain in detail what to do in visual studio IDE environment?
> Thanks in advance,
> StpnK
> <<copied from the previous posts>>
>>Yes, Reporting Services provide a set of Web Services API that you can
>>call
>>to generate report. Form your client app project (Win Form App), set web
>>reference to the reporting services and look into its Render() methods.
>>You
>>can also learn more aboubt this from SQL Server2005 Book on Line.
> "Smugliy" <Smugliy@.discussions.microsoft.com> wrote in message
> news:184E2D63-E618-4C35-A0C5-5F3A647B3803@.microsoft.com...
>> Hello ,All
>> I am new to the reporting services and my question maybe stupid .
>> I created some report and published it on the server.
>> Now my question is : does it possible at all to run this report from my
>> client (in C# )and to export the result to CSV format also from client
>> Is there any web service that I can use which is calling for my report
>> ?
>> Please ,help me to understand this .
>> Thanks a lot.
>> Smugliy
>>
>
>|||Thanks for your reply. Bruce.
Let me explain details.
I have a VB6 program (A.EXE) keeping running on the server. This program
should do lots of things such as monitoring the incoming files, reading the
files and do various kinds of tasks depending on the file type and other
conditions on the file...
With certain type of files, this program needs to call report-generator
(dll) (this is the program I want to write) of SSRS 2005 (passing
parameters) so that the report-generator saves the output file as PDF format
on the network folder. After that this program picks up this PDF file and
send emails to the customer with PDF reports attachments.
So to speak, there is no user interaction, no report viewer required...
(1) Is it doable with vb6.0 projects (possibly connecting to SSRS without
user interaction)?
If so, can you tell me the sample URL site? or attach the sample?
(2) I think it is doable with C#.NET or VB.NET...
Can you introduce the URL of samples? Or attach the sample if you have any?
Best Regards,
stpnK
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:ul0WYuNlIHA.1184@.TK2MSFTNGP04.phx.gbl...
> You would have to use the soap toolkit and do lots and lots of roll your
> own coding. And even then there might be some incompatibilities.
> Your best bet is to use URL integration. This is very straight forward and
> easy to implement. Generate the URL string, embed the IE browser control
> (if all you want to do is show the report) and set the url for the
> control. There are lots of examples on the web of how to embed the browser
> control and set the URL.
> Books online has lots of examples of URL integration.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "stpnK" <ssdfatepano917@.optonline.net> wrote in message
> news:47f3122d$0$15166$607ed4bc@.cv.net...
>> Hello,
>> I saw the post below that it is possible if we develop programs with C#
>> or VB.NET.
>> My question is
>> Is it possible to develop the program using visual basic 6.0?
>> If so, which reporting services dll should be referenced in visual basic
>> 6.0 project?
>> Could you explain in detail what to do in visual studio IDE environment?
>> Thanks in advance,
>> StpnK
>> <<copied from the previous posts>>
>>Yes, Reporting Services provide a set of Web Services API that you can
>>call
>>to generate report. Form your client app project (Win Form App), set web
>>reference to the reporting services and look into its Render() methods.
>>You
>>can also learn more aboubt this from SQL Server2005 Book on Line.
>>
>> "Smugliy" <Smugliy@.discussions.microsoft.com> wrote in message
>> news:184E2D63-E618-4C35-A0C5-5F3A647B3803@.microsoft.com...
>> Hello ,All
>> I am new to the reporting services and my question maybe stupid .
>> I created some report and published it on the server.
>> Now my question is : does it possible at all to run this report from my
>> client (in C# )and to export the result to CSV format also from client
>> Is there any web service that I can use which is calling for my report
>> ?
>> Please ,help me to understand this .
>> Thanks a lot.
>> Smugliy
>>
>>
>>
>|||I use the URL method in two ways. One, I have used it for integrating in old
type of programs. For instance, we use In-Touch a real time MMI (in the real
time control world the environment that interacts with the user is called
MMI, man machine interface). For that I embed a browser control. However, in
your case you have no GUI and so you would need to go to a lower level,
getting some dll that will go to a website and then get the stream back and
do with it as you will. Personally I think this is going to be a mess.
I think a vb.net or c# program using web services would be a much better way
to go that using URL and VB6.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"stpnK" <ssdfatepano917@.optonline.net> wrote in message
news:47f6b3df$0$15199$607ed4bc@.cv.net...
> Thanks for your reply. Bruce.
> Let me explain details.
> I have a VB6 program (A.EXE) keeping running on the server. This program
> should do lots of things such as monitoring the incoming files, reading
> the
> files and do various kinds of tasks depending on the file type and other
> conditions on the file...
> With certain type of files, this program needs to call report-generator
> (dll) (this is the program I want to write) of SSRS 2005 (passing
> parameters) so that the report-generator saves the output file as PDF
> format
> on the network folder. After that this program picks up this PDF file and
> send emails to the customer with PDF reports attachments.
> So to speak, there is no user interaction, no report viewer required...
> (1) Is it doable with vb6.0 projects (possibly connecting to SSRS without
> user interaction)?
> If so, can you tell me the sample URL site? or attach the sample?
> (2) I think it is doable with C#.NET or VB.NET...
> Can you introduce the URL of samples? Or attach the sample if you have
> any?
> Best Regards,
> stpnK
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:ul0WYuNlIHA.1184@.TK2MSFTNGP04.phx.gbl...
>> You would have to use the soap toolkit and do lots and lots of roll your
>> own coding. And even then there might be some incompatibilities.
>> Your best bet is to use URL integration. This is very straight forward
>> and easy to implement. Generate the URL string, embed the IE browser
>> control (if all you want to do is show the report) and set the url for
>> the control. There are lots of examples on the web of how to embed the
>> browser control and set the URL.
>> Books online has lots of examples of URL integration.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "stpnK" <ssdfatepano917@.optonline.net> wrote in message
>> news:47f3122d$0$15166$607ed4bc@.cv.net...
>> Hello,
>> I saw the post below that it is possible if we develop programs with C#
>> or VB.NET.
>> My question is
>> Is it possible to develop the program using visual basic 6.0?
>> If so, which reporting services dll should be referenced in visual basic
>> 6.0 project?
>> Could you explain in detail what to do in visual studio IDE environment?
>> Thanks in advance,
>> StpnK
>> <<copied from the previous posts>>
>>Yes, Reporting Services provide a set of Web Services API that you can
>>call
>>to generate report. Form your client app project (Win Form App), set web
>>reference to the reporting services and look into its Render() methods.
>>You
>>can also learn more aboubt this from SQL Server2005 Book on Line.
>>
>> "Smugliy" <Smugliy@.discussions.microsoft.com> wrote in message
>> news:184E2D63-E618-4C35-A0C5-5F3A647B3803@.microsoft.com...
>> Hello ,All
>> I am new to the reporting services and my question maybe stupid .
>> I created some report and published it on the server.
>> Now my question is : does it possible at all to run this report from my
>> client (in C# )and to export the result to CSV format also from client
>> Is there any web service that I can use which is calling for my
>> report
>> ?
>> Please ,help me to understand this .
>> Thanks a lot.
>> Smugliy
>>
>>
>>
>>
>

Friday, March 30, 2012

Running both 2000 & 2005 ?

Running BCP from a webserver

Running batches of reports

Running bat files in SSIS

Running bat files in SSIS

Running Backup through Maintenance Plan

Running Backup Jobs

running backup and restore...

Running as another user

running AS 2000 and AS 2005 on same hardware...

running AS 2000 and AS 2005 on same hardware...

running AS 2000 and AS 2005 on same hardware...

running application

running application

Running and sleeping processes

running and exporting report using visual basic 6.0 (not using .net)

RSS Text Data Mining

Blog Archive

About Me