Who is online?
0
guests and
0
members
Member login
|
Become a member
Home
Articles
Forums
Blogs
Jobs
Events
Files
Spaces
People
login
register
Home
» search results
Search Results: SQL Agent Job
47 results found
Stored Proc: xp_cmdshell to exec dtexec utility
Update: Sql Agent Job runs a T-Sql query that executes via xp_cmdshell, the SSIS package then imports data into the table. That's the theory, tested doesn't work. Question: can Sql Agent Job execute xp_cmdshell? Eliminations: -- Tested SSIS package with d
Author:
JohnG
Date: 7/29/2010 Section:
Forum
tags :
SQL Agent Job
,
Stored Procedure
,
sql agent job
Stored Proc: xp_cmdshell to exec dtexec utility
UPDATE / Solution? - You decide. Resolution: Lack of understanding as to how a SQL Agent Job functions when executed within a Stored Procedure. Brief Recap: Stored procedure executed from a sql script. Stored procedure expects 1 parameter. Within Stored P
Author:
JohnG
Date: 7/29/2010 Section:
Forum
tags :
dtexec utility
,
sql agent job
,
Stored Procedure
,
SSIS
SQL Server Agent Proxy Accounts
If you have any experience with Networking I’m sure you have heard of Proxy Servers before. Proxy Servers act as an intermediary between clients, and requests the resources for the client. SQL Server Agents have a Proxy feature that works in the same way.
Author:
DonnyJohns
Date: 3/31/2011 Section:
Blog
tags :
Credentials
,
Pragmatic Works
,
Proxies
,
Run As
,
SQL Server Agent
,
Donny Johns
Proxy
There might be instances where you develop your packages to use Integrated security. After all the unit testing, you try run it in a SQL Agent job and it fails. The reason could be because you're running SQL Server Agent using local service account. Sever
Author:
nitya
Date: 4/6/2010 Section:
Blog
tags :
2005
,
agent
,
sql server
,
ssis
Minimum Requirements
Situation: Test User needs to run an application that executes stored procedures, which execute SSIS packages. Test User's PC is not installed with the FULL version of Sql Server 2008 R2 Resolution: In order for Test User to execute dtexec for package exe
Author:
JohnG
Date: 7/30/2010 Section:
Forum
tags :
installation requirements
,
SQL Agent Job
Populate data in the table from multiple csv files
If you have a requirement to keep each part of the import in an SSIS package - you might consider a script task to concatenate the rows - or a ScriptTask data source component ( within a data flow ) and let some C# / VB.Net code do the heavy lifting on th
Author:
KeithHyer
Date: 5/24/2011 Section:
Forum
tags :
concatenate
,
CSV
,
optimization
Stored Proc: xp_cmdshell to exec dtexec utility
Hi all ! I hope this is the correct forum for this type of question. Here's a synap of my program. 1. C# GUI calls Stored Procedure 2. Stored Procedue Executes xp_cmdshell 3. xp_cmdshell Executes dtexec SSIS.dtsx package (Sql Server 2008, BIDS, SSMS, Win7
Author:
JohnG
Date: 7/28/2010 Section:
Forum
tags :
dtexec
,
sql agent job
,
ssis
Deployment question
You'll get varying opinions on this one. My preference is SQL Server. I prefer this method because it then relies on SQL Server security and backups. If you're confident that your network team handles backups and file security well on file system than tha
Author:
DevinKnight
Date: 8/11/2011 Section:
Forum
Ole db destination from a sybase dsn source running slow in ssis 2008
Prior to upgrading to SSIS 2008, I had a data warehouse that was populated by two separate processes, an SSIS 2005 package (populating one subset of tables) and an old vb.net application that populated the second subset of tables. Once I upgraded to SSIS
Author:
griffster
Date: 2/22/2012 Section:
Forum
tags :
ole db destination
,
ssis 2008
,
sybase odbc dsn
Easy way to run a Data-Driven Subscription on-demand?
Anyone know of a way to do this? I know that I can look at the SQL Agent jobs created, run some queries to link the job name back to the report/schedule I want, and kick that off, but I'd love to have an easier way to do this. We can't rename the Agent jo
Author:
paschott
Date: 12/11/2009 Section:
Forum
tags :
SSRS
,
Data Driven Subscription
,
SQL Agent
Promoting large volumes of subscription definitions from a report server to a different report server in a batch method?
Hello, I'm curious if anyone knows a way to batch move subscription definitions from a report server to a report server, with minimal intervention, with the ability to change subscription definition meta-data between each environment. I have to have all m
Author:
m3crast
Date: 5/25/2011 Section:
Forum
tags :
migrate subscription definitions
,
SSRS
,
Subscriptions
Force a
SQL Agent Job
step to fail
I still work with T-SQL in SQL Server Agent jobs on a pretty regular basis. From time to time I want to force a job step to fail based on conditions produced in the step. For example: Sometimes the T-SQL used in a step will run just fine but the data prod
Author:
Daniel
Date: 11/4/2011 Section:
Blog
tags :
force Agent job failure
,
SQL Agent Jobs
,
SQL Server
Find all object and item references in the SQL Agent jobs on a server
We use SQL Agent jobs for a lot of different types of tasks. Some do heavy lifting and ETL, some run and email basic reports, some simply manipulate data according to a schedule. However with all these jobs there is an occasional need to find object refer
Author:
Daniel
Date: 4/23/2011 Section:
Blog
How Can I know who has changed anything in SQL?
Hello all, After such a long time , I would like to post some another blog which might be helpful to the one who works in SQL. I need to find the one who has changed the tables within my SQL Database that I have created. For certain reason ,we may need to
Author:
Anil
Date: 12/20/2011 Section:
Blog
tags :
SQL Server
So Your Package Runs in BIDs But Not As A
SQL Agent Job
This is a very common issue. You develop your package in BIDS/Visual Studio and it runs just fine. Your package also depends on a password for a connection or another key piece of information. When you deploy it to another machine it errors out due to "in
Author:
MichaelSimon
Date: 5/31/2012 Section:
Blog
How Can I know who has changed anything in SQL?
Hello all, After such a long time , I would like to post some another blog which might be helpful to the one who works in SQL. I need to find the one who has changed the tables within my SQL Database that I have created. For certain reason ,we may need to
Author:
Anil
Date: 12/20/2011 Section:
Blog
tags :
SQL Server
Using a SSRS Report to run
SQL Agent Job
s part 2
In part one of this post I showed how you can use a report to run SQL Server Agent Jobs by using a report. In that post I only showed you how to run a single job but hardcoding in the job name. Someone recently asked if it was possible to have a drop-down
Author:
DevinKnight
Date: 12/11/2009 Section:
Blog
tags :
SSRS
Reporting on Failed
SQL Agent Job
s
I recently developed a series of reports that allows the user to view recently failed jobs by querying the MSDB database for job history information. By clicking the link "Click here to re-run the job", users can attempt to re-run the failed job right fro
Author:
DustinRyan
Date: 5/19/2010 Section:
Blog
tags :
run job from ssrs
,
SSRS 2008
Identifying Long Running
SQL Agent Job
s Script
I’m usually pretty hesitant to share scripts I write because inevitably it will get torn to pieces, but in this case I’d actually like some feedback so I can continue to grow this solution. This script spawned from Jorge Segarra (@SQLChicken)
Author:
DevinKnight
Date: 7/8/2012 Section:
Blog
tags :
SQL Agent Jobs
SQL Saturday #74 Session Recap
Hopefully if you came to my session this year at SQL Saturday in Jacksonville, FL you came away with some small piece of knowledge you didn’t have when you walked into the room. If nothing else you now know that there is a phenomenon known as Robocop on a
Author:
BradSchacht
Date: 5/6/2011 Section:
Blog
tags :
SSIS
,
SQL Saturday
Using a SSRS Report to run
SQL Agent Job
s
Data Warehouse latency is often a complaint I have heard from end users when trying to access data via either Reporting Services reports or Excel. Generally, I promise 24 hour latency unless the job mandates updates hourly or even sooner. With these compl
Author:
DevinKnight
Date: 11/12/2009 Section:
Blog
A Simple Twitter Console Application
I've been working this week to automate the BIDN.com's twitter connectivity and to do so, decided to build a quick Twitter interface to communicate with BIDN. I needed a simple console application that could be called via a trigger or a SQL Agent Job (my
Author:
BrianKnight
Date: 12/17/2009 Section:
Blog
tags :
bidn
,
twitter
Easy way to run a Data-Driven Subscription on-demand?
One thing I've done in the past is setup SQL Agent jobs to run from a report. So you can click on a report and it kicks off a SQL Agent job that runs your subscription. This blog post details that. http://www.bidn.com/blogs/DevinKnight/ssis/142/using-a-ss
Author:
DevinKnight
Date: 12/11/2009 Section:
Forum
How to run SSIS package with sql Agent not from default Working Directory
Hi, i've ~20 packages, whitch must be executed every day. Packages have one common configuration, and log provider. Config and Log provider addresses begins with "./", so it means that i can execute only using Execute Packages Utility. If i try execute us
Author:
aetern
Date: 1/24/2011 Section:
Forum
tags :
SQL Agent Job
,
ssis execution
SSIS Package vs Stored Procedure- Which one is better?
Hello, I am an ETL Developer in a company. My client is running three stored procedures in sql agent job (step 1, step 2, and step 3) to move the data from OLTP(sql server 2005 database) to reporting database(data mart). The store procedures use a lot of
Author:
ganeshl
Date: 8/28/2012 Section:
Forum
Page 1 of 2 (47 items)
<< Prev
1
2
Next >>
Go to page:
[Go]