SQL 2012 :: FTP Transfer Fails Via Job Activity Monitor

Oct 15, 2014

I have a SSIS package set up that will transfer a file from a location on the network drive and transfer it over FTP to another location.

When I manually run the package, the file is transfer with no errors. But when the job is automated (via Job Activity Monitor) the transfer fails?

I have set the ProtectionLevel of the package to "EncryptSensitiveWithUserKey" and also converted the package to a Development Model. The settings for the FTP is saved within the package.

What am I missing? below is the error message

Executed as user: UHBInfoSQLAgent. Microsoft (R) SQL Server Execute Package Utility Version 11.0.5058.0 for 32-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 08:43:02 Error: 2014-10-13 08:43:03.72
Code: 0xC001405F Source: ResearchWebsite

[Code] .....

View 2 Replies


ADVERTISEMENT

SQL 2012 :: Job In Rollback Not Showing In Activity Monitor?

Feb 22, 2015

We have killed a job which is now in KILLEDROLL BACK state. Job activity monitor is not showing any running jobs but I can see the SPID of that job. When tried to kill again its giving the message ‘command completed successfully‘, not able to get the percentage or time for the roll back to complete.

Another DBA tried to create a snapshot and it was stuck and I believe it was because of this ROLLBACK as both were using same Database.

View 5 Replies View Related

SQL 2012 :: Job Activity Monitor - Start Time Of Currently Running Job?

Apr 14, 2015

Is there anywhere in the SSMS to see the start time of a currently running job, currently running it's first step, without needing to run a query?

If not, why would Microsoft decide to not show it in the job activity monitor?

SSMS = Sql Server Management Studio

View 1 Replies View Related

Setup And Upgrade :: Activity Monitor Shuts Down If Connect To Instance Its Monitoring With Performance Monitor

Aug 19, 2015

If I'm on a remote machine, meaning a computer not in the WSFC cluster, and I open SSMS 2014, point it to a SQL Instance, and open activity monitor:

1.  I get all the panes and charts except % Processor Time.

2.  Then, if I authenticate to the cluster's domain by mapping a drive with valid domain credentials, I'm free to put performance counters in the Perfmon - - - but SQL Activity Monitor shuts down with“The Activity Monitor is unable to execute queries against server SQL-V01INSTANCE1..Activity monitor for this instance will be placed into a paused state.Use the context menu in the overview pane to resume the activity monitor.

Additional information:  Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))(Mscorlib)”

3.  Of course, the Activity monitor can't be resumed via the context menu. Removing counters and closing the perfmon do not work.  I dropped the mapped drive and rebooted the machine.  That brought back 95% of the information in the Activity monitor.

4.  Further experimentation showed that any mapping of drive shares present on the SQL Server to the computer running SSMS cut off functionality of the 'overview' pane in the remote machine's SQL Activity monitor -- the monitor that had been trying to watch the server offering the shares.

View 4 Replies View Related

Activity Monitor

Apr 10, 2008

Is there a way to allow a user to run activity monitor without making that user system admin

View 9 Replies View Related

Activity Monitor

Apr 23, 2008

Hi experts,
I just want to know how can i kill all the processes of a database
if the database have more than 100 connections.This is for the purpose of restoring a database.

RKNAIR

View 3 Replies View Related

Activity Monitor

Apr 10, 2007

Is there a way to give access to non-admins on ACTIVITY MONITOR?


------------------------
I think, therefore I am - Rene Descartes

View 2 Replies View Related

Job Activity Monitor

Sep 10, 2007

Hi,

I have a problem with Job Activity Monitor.

I have a SSIS which copies data from a table to a flat file. The connection string of this file is variable and the file is reused if not exists and is created if exists.

When I run the SSIS manually from my microsoft visual studio it works properly. However, when I run this SSIS from the Job Activity Monitor, I get the following error:

Message
Executed as user: REDCAMadminsql2k5. Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 8:41:10 AM Error: 2007-09-10 08:48:04.99 Code: 0xC020200E Source: Crear Historico Historico [1] Description: Cannot open the datafile "\srvnfileHISTORICOSCAJEROSOFI3210C01OFI3210C01_2007-7X.txt". End Error Error: 2007-09-10 08:48:04.99 Code: 0xC004701A Source: Crear Historico DTS.Pipeline Description: component "Historico" (1) failed the pre-execute phase and returned error code 0xC020200E. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 8:41:10 AM Finished: 8:48:53 AM Elapsed: 462.234 seconds. The package execution failed. The step failed.

Any idea?

Thanks.

View 3 Replies View Related

SQL Activity Monitor Logs

Oct 5, 2007

Hi All,

I want to analyze server (SQL 2005) activity at a specific time in the past. Unfortunately, there doesn't seem to be a log file reflecting the information in Activity Monitor. Knowing that the sysprocesses and syslocks tables feed Activity Monitor, I thought about doing a log analysis on the master transaction log, but I'm not sure that's possible.

Is there a (different) way to achieve this?

Or is there a better approach to identifying processes that cause performance bottleneck/deadlocks?

Any input would be appreciated.

Ken

View 4 Replies View Related

Service Pack 1 And Job Activity Monitor

Feb 6, 2007

Hi,

I've been using the Job Activity Monitor quite a lot and last night I installed Service Pack 1 for SQL Server 2005. I've noticed now that I only have a "Start Job at Step" option when I right-click a job. Whereas I used to have just Start Job or both Start Job and Start Job at Step options.

The problem is that Starting a Job at a Step, produces a modal dialog box which prevents further access to Job Activity Monitor until the job is complete.

Does anyone have any comments regarding this?

Thanks in advance,
Richard.

View 1 Replies View Related

SQL Server Agent - Job Activity Monitor

Apr 19, 2007

I'm hoping that someone has experienced this problem before and knows how to get round it.

The problem we are having is that we have a job that is scheduled to run at 4:00 am each morning, for the past 6 weeks it has done this with no problem. However, this morning it failed. we know it failed because it didn't produce the results it was supposed to. However the monitor said that the job had completed successfully. On examining the history of the job we found that the job was still running!!! When we tried to stop the job by right clicking and selecting the appropriate action. The action available to us was to start the job.

After arguing for a bit we decided to try and run the job again. We did this and found that the job running in the history screen terminated with an error and than ran and completed successfully.

Confused? So are we any ideas or solutions gratefully received

View 3 Replies View Related

Sp_who2 Vs. Activity Monitor In SQL 2000

Apr 4, 2007

Hi!



I want to extract the same information as the Activity Monitor does with SQL in SQL Server 2000.

Have tried to use sp_who2 but I miss some important columns.



How do I do?



Thanks!

View 2 Replies View Related

Refresh Settings Job Activity Monitor

Oct 25, 2007



If you are in SQL Server Management console, go to Job Activity Monitor, there is an option 'View Refresh Settings'. You have to enable/check the Auto Refresh option here every time. Is it possible to keep this Auto Refresh enabled?

Thanks!

Olaf

View 6 Replies View Related

Large Number Of Processes In Activity Monitor

Jun 4, 2007

All;

We have a Windows App and Web App that share business objects which points to a single database. When a Windows user logs in, an average of 50 processes are created in the first few seconds and never go away. The details window is blank and they all remain sleeping from that point on.

I have stepped through the code to see if there is anything odd going on but most of the processes are created when validating the number of parameters the stored procedure has or the length of the stored procedure name. This translates to 1000-1500 processes on average.

Is this normal? Will it hurt performance? Is there a way to remove them?

View 1 Replies View Related

SQL Tools :: Activity Monitor Gives Access Is Denied

Apr 23, 2013

When I try to open Activity Monitor from SSMS I receive the message "Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)) (mscorlib)". - more details below.

I have a SQL Server 2012 Enterprise SP1 installed in an Active/Passive cluster configuration on Windows 2008 R2 Enterprise SP1. The problem happens using sa and a domain administrator.

------- more details -------
Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)) (mscorlib)
   at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
   at System.Management.ManagementScope.InitializeGuts(Object o)
   at System.Management.ManagementScope.Initialize()
  
[Code] .....

View 5 Replies View Related

Activity Monitor - Host Entries Blank For Sql Login ?

May 18, 2007

The activity monitor is not showing entries for hosts which connect via sql logins (odbc), is this normal? Where can I find a list of protocols in which the hostname/ip can be picked up. We're on SQL 2005 SP1/Build 2153



Thanks

View 2 Replies View Related

Change Login-Info For Activity-Monitor And Sp_who

Sep 26, 2007

Hi

we have one 'application'-user in sysusers that makes the connect to SqlServer for all users, for example:

Application Login-User: Thomas
DB-Connect-User: AppUser

With this solution, in Activity-Monitor or with sp_who I don't know, what is the real name of the connected user.
Any possibility to change the login-information after the connect, so that i can see 'Thomas' in Activity-Monitor or with sp_who?

Thanks for your help.
Thomas

View 4 Replies View Related

SQL Server 2008 :: Job Activity Monitor - Swapping Order Of Columns

May 28, 2015

Is there a way to permanently change the order of the columns in Job Activity Monitor?

I'd like to move Duration to the right of Step Name, but this only lasts so long as I have JAM open. Once I close it and re-open, JAM goes back to its default column order. Google gives me nothing but the temporary "drag and drop" method that I already know about.

View 2 Replies View Related

User Connection Changes In Activity Monitor When Running Stored Proc

May 16, 2007

Please forgive the simplicity of this question - I am not the dba type. When I connect to a server and look at my connection attributes in activity monitor, the user column shows the correct information for my domainusername. When I run a certain stored procedure in that connection, the domainusername changes to another person. We are not using execute as, setuser, or anything special to explicitly change the user. The stored procedure is in a schema that is owned by dbo (principal_id = 1 - I verified by checking sys.database_principals.)



Does anyone have any suggestions?



Thanks in advance,

John Hennesey

View 4 Replies View Related

Permissions In SQL Server 2005 To Allow Users To View The Management Activity Monitor?

Sep 27, 2006

For SQL Server 2000 we have a user login mapped to msdb with database role membership of db_datareader and public checked. This seems to allow the developers to view the Management Activity monitor. For SQL Server 2005 the same mapping is in place but the developers cannot view the Management Activity monitor. Developers are NOT granted the sysadmin role, and should not have that role.

What permissions need to be set for SQL Server 2005 to allow users to view the Management Activity monitor? They should not be allowed to take actions on the activities.

View 13 Replies View Related

SQL Server 2005 Start Jobs Window And Job Activity Monitor Do Not Show Job Status Correcly

Mar 14, 2007

Hi,

We have development and user acceptance (UA) servers. When I start a job on the development server, on the management studio, Start Jobs window and Job activity windows indicate "Executing" until the end of the job and finish with "success" or "failure"

But on the UA server, second after I start a job, Start Jobs window comes up with "success" or failure" and Job activity monitor says "idle" but Job continues to log without any error message and updates the tables. So these two windows are not reliable at all. I have to add that I have only job operator rights on the UA server.

Does anybody know what the reason is ?

Thanks

View 5 Replies View Related

Transfer Objects With DTS Fails

May 3, 2000

Hello,

I have some trouble with a couple DTS package transfering table contents using "Transfer Objects" from one server to another. Every other night they fail, without leaving any error messages in either the SQL Server Log, NT Event Log or SQL Agent Log.

The server running DTS is a 7.0 SP1, and it transfers data to and from other servers running 7.0 without any service packs.

Brgds

Jonas Hilmersson

View 1 Replies View Related

EM Transfer Manager Fails Moving Data After 80th Table?

Sep 14, 1999

Hello:

I am running on mssql 6.5, sp4. We have been trying to use EM transfer manager to move one test database on one server to another database on another server.
We are dealing with 135 tables on this database. The transfer works up until about the 80th atble and then just dies but the scheduled task says it failed and check error log. The transfer creates the tables on the destination database but only loads the data until this one table.

WE use all of the options in EM Transfer manager which are st as defaults.

THere is no one on the source or destination databases locking this table.

Other smaller databases were successfully transferred from one database on one server to the other database on the other server without any problems today and yesterday.

Has any one run across something like this?

THanks.

David Spaisman

View 1 Replies View Related

Transfer Sql Server Objects Task Truncate Table Fails Due To Foreign Key

Aug 10, 2006

Hi

We used to used Sql Server 2000 DTS to perform daily backups to remote servers very successfully but just cannot do the same with SSIS.

I set my Transfer Sql Transfer Objects Task to use the following settings:

CopyData = true

ObjectsTocopy = All Tables

As soon as it hits a table that has a foreign key, I get the following error:

"Truncate data failed for Table nnn"

I've tried setting DropObjectsFirst = True but this fails too with foreign key violations.

First of all, am I doing something obviously wrong? Is SSIS not smart enough to drop tables in the right order so that we don't get foreign key violations?

Am I totally barking up the wrong tree with this and can anyone suggest a better way of doing remote backups?



Kind regards

Ben

View 3 Replies View Related

SQL 2012 :: Efficient Way To Monitor User Access To Database

Apr 22, 2014

Currently there are various teams accessing the database. For costing reasons, we need to track usage.Is there an efficient way to monitor User access to the database.Can we track which user has executed which query(SELECT,insert etc),the login time and such parammeters?

View 5 Replies View Related

SQL Server 2012 :: How To Monitor Replication Count Using Code

Jun 4, 2015

I Want to monitor Replication count of object (Table )if it is not equal to Publication (Table ) and subscriber (Table ), It have to send mail with count difference.

View 9 Replies View Related

SQL Tools :: How To Trace Or Monitor Previous Actions In 2012

Sep 12, 2015

how to trace or monitor previous actions in sql server 2012. Like previous using delete command . I want to know who is used that command in server.

View 2 Replies View Related

SQL 2012 :: Can Combine Performance Monitor Counters With Extended Events

Oct 14, 2014

In the past, I've combined server side traces with Perfmon successfully, which is pretty useful, I know that. I would like to do the same with Extended Events, so I can correlate and analyze the server side as well.

View 4 Replies View Related

SQL 2012 :: Can See Last Copied Files In Log Shipping Monitor Reports As Well In Proc

Jan 30, 2015

At one of our client side a wired log shipping issues has come up.while monitoring those two server i noticed that although log-shipping report says both server are in sync, report displays information related to both backup and restore , it doesn't shows information related to copy that is when was last file copied and last file copy column is showed blank. Same is when i execute proc "sp_help_log_shipping_monitor" . I get same result ...

When i expand copy job history to analyse its what i found is although job has executed successfully , but in depth reading each steps says that no .trn file was copied .

My copy directory is at secondary server itself where .trn files are placed.And from this location itself files are begin restored.

SQL server and agent on both servers are run by same domain account ....

View 5 Replies View Related

SQL 2012 :: Approximate Hours Per Month To Monitor And Maintain Health Of Databases?

Jul 8, 2014

Based on the description below on average how many hours a month would it take to monitor and maintain the MSSQL Server databases?

Description of IT infrastructure.All Windows Servers and MSSQL Servers are up to date on patches and best practices.

Corporate site with 3 remote sites.

All remote sites have one DC and one MSSQL Server.

The corporate site has one MSSQL Server.

Replication is performed between the remote MSSQL databases and the corporate office MSSQL database.

There is no in-house DBA. All DBA services will have to be outsourced. I am trying to determine what is reasonable in budgeting for time involved for this service.

There is one project written in MS Access using Visual Basic for Applications (VBA) with the backend residing on these database.

The question is on average approximately how many hours a month would it take to monitor and maintain the health of the MSSQL Servers database by a MSSQL DBA. The DBA will not have to create any user reporting, queries, etc. Just maintain the existing MSSQL Servers database.

View 9 Replies View Related

SQL Server 2012 :: Script To Specify Date Field To Use For Activity Date

Jun 2, 2014

I'm writing a view to check record counts in a table that has numerous datasets and therefore various "Activity Dates". Is it possible as part of the SQL statement to have a CASE statement for example so that it can identify the field to use as the activity date?

The field to use is being identified using a seperate table so at the moment I have CASE WHEN FieldToUse = '2' THEN MapCol ELSE '[Activity_Date]' END, where FieldToUse = '2' identifies the date field to use and the MapCol data is the field name to be used as the activity date.

Is this even possible?

View 3 Replies View Related

SQL 2012 :: Read Only Database Transfer

Dec 4, 2014

I have an inter-company problem.

The one company gathers data into a SQL database hosted within their secure network and now one of the companies (that they are contracted to gather the data for) wants a backup of the data or a replicated database to be able to be placed onto a external HDD or different SQL server on their own network and server.

The catch is that to maintain their data security the original company doesn't want the company that is receiving the data to be able to edit the data. They are concerned that someone might change the data and claim that the data that they gathered is incorrect.

Is there a way to ensure the SQL database remains entirely read only?

View 1 Replies View Related

SQL 2012 :: Login Transfer In Database Mirroring

Jan 24, 2015

I have created a new login in principle server and provided dbowner permission to principle db.

How do I transfer this login to mirror server and assign the same permission to mirror dd?

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved