All Questions
Tagged with ssms sql-server-agent
20
questions
0
votes
2
answers
2k
views
SQL Server Agent not running SSIS package
I have followed many articles to create an SSIS pipeline package, deploy it and schedule it.
I'm trying to transfer data from two remote servers, an OLEDB driver that connects to a SQL Server Database ...
0
votes
0
answers
1k
views
Permissions to run SQL Server Agent Job
I am getting the following error message:
Message Executed as user: fin\jdoe. The server principal
"fin\jdoe" is not able to access the database "abc" under the
current security ...
2
votes
1
answer
3k
views
SSMS Not showing Status and Scheduled Jobs Not Running
Recently in SSMS, I have started getting a blue question mark next to the database and SQL Server Agent, when previously all was showing running. At the same time my scheduled jobs have stopped ...
- 21
0
votes
2
answers
1k
views
Is it possible to prevent SQL Agent Job from running if related job or previous instance has not finished?
I have three SQL Agent jobs, one for each of three registries being managed. These go off on a staggered schedule every two hours (i.e. Reg 1 at 9am, 3pm; Reg 2 at 11am, 5pm; Reg 3 at 1pm, 7pm).
In ...
- 101
0
votes
1
answer
537
views
How to Capture Job Exit Code?
I'm essentially trying to find a better way to determine if my job has completed successfully before moving on to another call of the same job. I have multiple jobs which run through a parsing process ...
1
vote
0
answers
2k
views
SSIS job runs successfully but doesn't load data
I am running a job from SQL Server Agent and the job runs successfully. However it doesn't load any data (in my case Excel files from a local folder). I created a new Proxy Account to run this job but ...
- 11
0
votes
1
answer
184
views
SQL Server Agent appears to be treating sysprocesses (and dm_exec_sessions) differently
I have a watchdog process that runs via a SQL Agent job to manage some custom tasks. One of the checks is that the process no longer exists:
UPDATE R
SET IsOrphaned = 1, DebugTimestampUtc = ...
- 721
1
vote
3
answers
12k
views
How to send Email from a SQL Job with results of multiple select statements
I want to create a SQL job and send an emails with multiple select statements including in query results. Is it possible with SQL Job or should I use SSIS?
Edit 1:
EXEC msdb.dbo.sp_send_dbmail
...
- 1,495
2
votes
1
answer
104
views
Setting Up SQL Alerts
I have turned on notifications via email on my SQL Server Agent if any of my scheduled jobs failed or is successful.
Can anyone help me if I want to set up Alerts, if in case one of the scheduled job ...
- 21
0
votes
1
answer
1k
views
How to setup Email alerts for Reporting jobs when it fails?
In SQL server 2008R2, I have a JOB which is running every month 1st week for Reports and I am frequently receiving Error message like "The job failed. The Job was invoked by Schedule 14. The last ...
- 1,495
2
votes
1
answer
473
views
SP_whoisactive capture on Alwayson Secondary Replica issue
I am trying to capture SQL query plans using sp_whosisactive on a alwayson secondary replica db server and getting the error below in the query_plan column.
This happens when I run the code below as a ...
- 105
4
votes
1
answer
2k
views
Script fails to run as SQL Server Agent Job, completes successfully when run from SSMS
I have two T-SQL scripts that are scheduled to run once every day. Both do cleanup of some old data from different tables. Both scripts are run as the same user, on the same database.
Script A will ...
- 877
3
votes
1
answer
86
views
SSMS 2016 Job Schedule Wizard Starting At entry field
I am using SSMS 2016. In the wizard for job schedules the field for Starting/Ending At shows only one character, and is unusable. Here is the screen shot.
SSMS version should be the latest at 13.0....
- 433
3
votes
0
answers
542
views
SQL Agent parsing actually executes instead of just validating
I'm seeing some really odd behavior with SSMS 2014/2016 that I stumbled accross by pure accident. This was run on SQL2014 SP1+CU6 (the fixed one) in a non-prod environment. Here's the backstory.
I ...
- 3,844
1
vote
1
answer
5k
views
Start failed for Job in SQL Server Agent
I am trying to schedule a job which executes stored procedure but it is failing.
DECLARE @return_value int
EXEC @return_value = [dbo].[sp_WarehouseAttendance_New]
SELECT 'Return Value' = @...
- 183