Showing posts with label jobs. Show all posts
Showing posts with label jobs. Show all posts

Friday, March 23, 2012

Need dtsrun help

I am trying to run two dts jobs using a batch file obviously using dtsrun but im having trouble. I've never attempted this before and it looked easy but not as easy as I thought.

I have two dts jobs, call them package1 and package2. I also saved these as .dts files. I made a .bat file and put it in the same location as the .dts files.

My batch file looks like this:

dtsrun /F package1
dtsrun /F package2
pause

This does not work and I get the following:

C:\WINDOWS>dtsrun /F package1
DTSRun: Loading...

Error: -2147287038 (80030002); Provider Error: 0 (0)
Error string: The system cannot find the file specified.

Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 704

Can anyone help and tell me what I am doing wrong?

Thanks

Neil.What happens when you fully path out the package files?|||check this link ,it may help u.
http://www.sqlteam.com/item.asp?ItemID=16512|||By fully path I guess you mean C:\folder\xyz etc...?

If so then I just tried that and still the same error.|||Oh dear, I'm definately having a slow day today...

I had a thought about where I was running the batch file from. I was running it from my PC even though it is located on the server. I then remote connected to the server and ran it there, IT WORKS!

Sorry for trouble but thanks for the link

NeilAsql

Wednesday, March 21, 2012

Need Assistance: Trying to run jobs and getting nowhere/SQLServerAgent

I've gone through hundreds of posts here and on the Net. I'm creating an ssis package to access my db on my desktop. I then save a copy as "Test" on the msdb database on our sql 2005 box.

Try to create a job and I'm getting nowhere. My SQL Server Agent account is a member of local Administrator group and a member of the domain.

Now what I noticed is if I run the dtsexec from the command prompt and use the command line string then it works. Just seems like I'm not able to run anything from the SQL Server>>Jobs interface.

Please Help :)

What errors do you get? Have you seen http://support.microsoft.com/kb/918760?|||

I have it working with the set password but I'd like not to do this in case other developers create packages and then forget. I'd like to use the below method but how do you do this --> "SQL Server Agent run the job as the account that created the package or as an account that has the required permissions.
"

Method 1: Use a SQL Server Agent proxy account

Create a SQL Server Agent proxy account. This proxy account must use a credential that lets SQL Server Agent run the job as the account that created the package or as an account that has the required permissions.

This method works to decrypt secrets and satisfies the key requirements by user. However, this method may have limited success because the SSIS package user keys involve the current user and the current computer. Therefore, if you move the package to another computer, this method may still fail, even if the job step uses the correct proxy account.

|||Books online have topic Creating SQL Server Agent Proxies under Administering the Database Engine > Automating Administrative Tasks (SQL Server Agent) > Implementing SQL Server Agent Security >

Need Assistance: Trying to run jobs and getting nowhere/SQLServerAgent

I've gone through hundreds of posts here and on the Net. I'm creating an ssis package to access my db on my desktop. I then save a copy as "Test" on the msdb database on our sql 2005 box.

Try to create a job and I'm getting nowhere. My SQL Server Agent account is a member of local Administrator group and a member of the domain.

Now what I noticed is if I run the dtsexec from the command prompt and use the command line string then it works. Just seems like I'm not able to run anything from the SQL Server>>Jobs interface.

Please Help :)

What errors do you get? Have you seen http://support.microsoft.com/kb/918760?|||

I have it working with the set password but I'd like not to do this in case other developers create packages and then forget. I'd like to use the below method but how do you do this --> "SQL Server Agent run the job as the account that created the package or as an account that has the required permissions.
"

Method 1: Use a SQL Server Agent proxy account

Create a SQL Server Agent proxy account. This proxy account must use a credential that lets SQL Server Agent run the job as the account that created the package or as an account that has the required permissions.

This method works to decrypt secrets and satisfies the key requirements by user. However, this method may have limited success because the SSIS package user keys involve the current user and the current computer. Therefore, if you move the package to another computer, this method may still fail, even if the job step uses the correct proxy account.

|||Books online have topicCreating SQL Server Agent Proxies under Administering the Database Engine > Automating Administrative Tasks (SQL Server Agent) > Implementing SQL Server Agent Security >

Friday, March 9, 2012

Need advice

I would like to do the following:
I don=B4t want to run SQL Jobs on my sql server. I will be using an application called ITO. This application will have a user assigned to it and will execute the jobs and monitor it (TNG Style). Anyways this is the problem:
To execute "exec sp_start_job @.job_name", the user must be the owner of the job.
Now lets say your job is an sql query. It has (for example) deletes. This user will need priviledges to be able to execute those queries.
The problem with this is that this application executes the job through a batch:
it lauches the batch file which contains the commands necessary: isql -S servname -U username -P password -
i "inputfile".
The problem is that a user=B4s account (that has priviledges) and its password is out in the open. Is there anyway i can go arround this. Any other command that can execute the job and dont need priviledges. I was thinking about SETUSER but for SETUSER you need to be sysadmin.
Does anyone have any idea?
:)Not sure Im following. But in isql -E means use a trusted connection so if your using Windows authentication you wont need to specify the user/ password. Does this help?
>--Original Message--
>I would like to do the following:
>I don=B4t want to run SQL Jobs on my sql server. I will be >using an application called ITO. This application will >have a user assigned to it and will execute the jobs and >monitor it (TNG Style). Anyways this is the problem:
>To execute "exec sp_start_job @.job_name", the user must be >the owner of the job. >Now lets say your job is an sql query. It has (for >example) deletes. This user will need priviledges to be >able to execute those queries. >The problem with this is that this application executes >the job through a batch:
>it lauches the batch file which contains the commands >necessary: isql -S servname -U username -P password -
>i "inputfile".
>The problem is that a user=B4s account (that has >priviledges) and its password is out in the open. Is there >anyway i can go arround this. Any other command that can >execute the job and dont need priviledges. I was thinking >about SETUSER but for SETUSER you need to be sysadmin.
>Does anyone have any idea?
>:)
>.
>

Need a Tool/Software to monitor SQl Jobs

Does any one know of any free web-based apps that can monitor my SQl
agent Jobs?
This is the best tool around for that:
http://www.sqlsentry.net/
Andrew J. Kelly SQL MVP
"Jeremy Smith" <godtoall@.hotmail.com> wrote in message
news:1115654766.965681.68180@.f14g2000cwb.googlegro ups.com...
> Does any one know of any free web-based apps that can monitor my SQl
> agent Jobs?
>
|||Sorry it's not free but it's not that expensive either and can actually save
you money in the long run.
Andrew J. Kelly SQL MVP
"Jeremy Smith" <godtoall@.hotmail.com> wrote in message
news:1115654766.965681.68180@.f14g2000cwb.googlegro ups.com...
> Does any one know of any free web-based apps that can monitor my SQl
> agent Jobs?
>