No announcements
Found 167155 threads
-
0 Votes
SQL Server Agent Configuration for SQL Azure
Hi, The most common reason we have seen the SQL Agent fail (especially when it works from command line) is due to the user context that the SQL ...Answered | 2 Replies | 11132 Views | Created by PetkaRUS - Tuesday, January 12, 2010 9:10 PM | Last reply by Willie.Bugnon - Sunday, December 19, 2010 1:44 AM -
0 Votes
SSIS Job does not start from SQL Server Agent
Hi all, i'm trying to execute a job from sql server agent, the job starts and ends with success but it does not make any progress.Answered | 1 Replies | 15641 Views | Created by Priti06 - Friday, December 24, 2010 9:08 AM | Last reply by Ed Price - MSFT - Friday, December 2, 2011 8:54 AM -
3 Votes
SQL Server 2012 MCSA Manage SQL Server Agent objective
I believe this should be "Send SQL Server Agent Error Messages " http://msdn.microsoft.com/en-us/library/ms177451.aspxWhen you see answers and helpful ...Answered | 2 Replies | 5648 Views | Created by Arjen Krap - Thursday, July 26, 2012 7:26 AM | Last reply by Arjen Krap - Saturday, July 28, 2012 4:03 AM -
3 Votes
SQL Tuning to Address Job & Task Performance
Task 4 shows up in the HPC Job Manager but is marked as failed.Answered | 11 Replies | 6998 Views | Created by Surly - Thursday, April 23, 2009 6:28 PM | Last reply by Josh Barnard - Wednesday, June 3, 2009 9:50 PM -
0 Votes
Web application starting SQL jobs
Could you start this job via SQL?Answered | 3 Replies | 1160 Views | Created by ChuckMN - Thursday, August 6, 2015 2:31 PM | Last reply by Christopher84 - Thursday, August 6, 2015 6:08 PM -
4 Votes
Catch Exception in a C# application which calls SQL Job Agents
Ed Price (a.k.a User Ed), SQL Server Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki) ...Answered | 3 Replies | 2462 Views | Created by Rac19 - Tuesday, April 16, 2013 6:07 PM | Last reply by Ed Price - MSFT - Wednesday, April 24, 2013 7:08 AM -
0 Votes
SQL Server agent is not running when changing database server
Create the jobs using the T-SQL code from the other server.Answered | 9 Replies | 6409 Views | Created by Muhamad Yasin - Sunday, November 7, 2010 11:27 PM | Last reply by Curt Spanburgh MVP Moderator - Tuesday, November 9, 2010 1:54 PM -
0 Votes
Data archival/removal of Jobs/Tasks data in HPC
As for archival, you can use the various SQL tools to do this (though you may need to install Full SQL instead of SQL Express for many features).Answered | 1 Replies | 6121 Views | Created by PVASNMurthy - Wednesday, August 13, 2008 11:25 AM | Last reply by Josh Barnard - Wednesday, August 27, 2008 5:47 PM -
0 Votes
help request on SQL Agent
Hi, What Exactly do you want to do with SQL Agent?Answered | 3 Replies | 9933 Views | Created by wonderfulStar - Friday, October 31, 2008 5:41 AM | Last reply by Vijay Mullick - Wednesday, November 5, 2008 6:38 AM -
0 Votes
Exponential time of queueing tasks of a single job - is it a bug?
Hi Lukasz, I'm using V3 beta, SQL Server Express (the one that came with the V3).Answered | 4 Replies | 5264 Views | Created by rag3ous - Monday, June 21, 2010 7:22 AM | Last reply by Lukasz Tomczyk - Monday, June 28, 2010 10:51 PM -
0 Votes
Script Task : exception has been thrown by the target of an invocation (sometimes it is running fine and sometimes got failed through the sql job with same error.)
Microsoft Certified Professional Microsoft MVP [Windows Server] Datacenter Management Disclaimer: This posting is ...Answered | 1 Replies | 1527 Views | Created by ssis script task got failed - Wednesday, September 21, 2016 3:11 PM | Last reply by Dave Patrick - Wednesday, September 21, 2016 3:58 PM -
1 Votes
HPC Headnode disconnects when submitting jobs with many tasks
Hi, It is not efficient to have so many batch tasks in one job while you are using SQL express.Answered | 2 Replies | 915 Views | Created by TimJRoberts1 - Wednesday, September 16, 2015 4:52 PM | Last reply by TimJRoberts1 - Thursday, September 17, 2015 8:47 AM -
1 Votes
Communication between task processes and the job process
Hi Lucasz, At first we also had the idea of using jobs as tasks, but then realized jobs lack an important feature that ...Answered | 5 Replies | 6012 Views | Created by rag3ous - Wednesday, June 9, 2010 12:28 PM | Last reply by Lukasz Tomczyk - Wednesday, June 30, 2010 4:42 PM -
1 Votes
sql job getting error
Message Executed as user: CORP\Nserver_SVC.Answered | 2 Replies | 5439 Views | Created by himanshu_kulkarni - Monday, August 20, 2012 11:16 AM | Last reply by Sheng Jiang 蒋晟 - Saturday, September 1, 2012 1:09 AM -
0 Votes
SSIS Package Execution in SQL Agent Jobs
Error:- Microsoft (R) SQL Server Execute Package Utility Version 14.0.3049.1 for 32-bit Copyright (C) 2017 Microsoft.Answered | 1 Replies | 1605 Views | Created by Udhayaganesh P - Friday, November 1, 2019 10:00 AM | Last reply by - Friday, November 1, 2019 11:02 AM -
0 Votes
Edit task properties via job submission filter
It is impossible to change task propertys using a job submission or activation filter.Answered | 1 Replies | 5997 Views | Created by Shay_Segev - Sunday, April 25, 2010 11:44 AM | Last reply by MWirtz - Friday, April 30, 2010 12:31 PM -
0 Votes
Is there any possibility of Submitting the task before adding all the task to the Job(Partial job Submitting)
Alternatively you can just wait for your tasks to complete and then cancel the job.Answered | 6 Replies | 6144 Views | Created by PVASNMurthy - Tuesday, August 19, 2008 6:03 AM | Last reply by PVASNMurthy - Thursday, September 4, 2008 6:38 AM -
0 Votes
Node & Core Allocation Priorities for Tasks in the JOB
While Submitting Job with 8 Tasks, it is allocating all this tasks to single node.Answered | 1 Replies | 6702 Views | Created by PVASNMurthy - Thursday, March 5, 2009 11:08 AM | Last reply by Josh Barnard - Tuesday, March 10, 2009 6:57 PM -
2 Votes
Problem with job of type Operating system(CmdExec) in sql server 2008
Windows Server 2008 Standard 64-bit platform SQL Server 2005 Excel/Office 2007 Professional Don't try to use SaveAs just try ...Answered | 2 Replies | 10151 Views | Created by BhargavUppalapu - Thursday, September 24, 2009 12:09 PM | Last reply by avrail Vivo - Friday, November 20, 2009 11:44 PM -
0 Votes
How are tasks killed when you cancel a job?
The scheduler actually just cleans up the job object, so it's more the equivalent of selecting your process(es) in Task Manager and hitting "kill process.Answered | 1 Replies | 5824 Views | Created by Brian Granger - Sunday, November 8, 2009 10:36 PM | Last reply by Josh Barnard - Monday, November 16, 2009 9:06 PM - Items 1 to 20 of 167155 Next ›
No announcements