No announcements
Found 4102053 threads
-
0 Votesunder sql server job agent, view job history gets time out error message. How to fix?
see http://www.jamesserra.com/archive/2011/06/easier-way-to-view-sql-server-job-history/Answered | 2 Replies | 1311 Views | Created by bestrongself - Sunday, March 9, 2014 5:18 PM | Last reply by Visakh16 - Sunday, March 9, 2014 5:54 PM
-
0 Votes
SQL Server Agent Job History?
Hi Mira, SQL Server does not keep Job definition change history until unless you have implemented your own such solution to track ...Answered | 4 Replies | 692 Views | Created by Mira Pimbi - Wednesday, January 11, 2017 2:47 AM | Last reply by Sunil Gure - Wednesday, January 11, 2017 5:06 AM -
0 Votes
SQL Agent Job history
Hello all, I have logged in the server as sysadmin and then I checked "Automatically remove agent history" option in SQL Agent ...Answered | 1 Replies | 6040 Views | Created by Ryan_XH - Tuesday, April 26, 2011 4:03 PM | Last reply by Pradeep Adiga - Tuesday, April 26, 2011 5:56 PM -
0 Votes
Error Inside SQL Server Agent Job View History
script inside Query window (interactive), it works fine and do I do get the email. However, when I run the script inside a SQL server agent job, I ...Answered | 2 Replies | 1023 Views | Created by vr123 - Friday, May 24, 2019 8:17 PM | Last reply by vr123 - Friday, May 24, 2019 11:05 PM -
2 Votes
SQL Agent Job History is wiped out
per job). I prefer to increase to 50000 in total, and perhaps 500 per job. right-click Agent, Properties, and here you can configure these ...Answered | 6 Replies | 888 Views | Created by Samantha v - Tuesday, February 11, 2020 7:33 AM | Last reply by Samantha v - Wednesday, February 12, 2020 6:37 AM -
2 Votes
sql agent job history question
Hi, here is a query example.You may be out of luck if the if the job history has cycled SELECT ...Answered | 2 Replies | 505 Views | Created by scott_m - Tuesday, February 28, 2017 4:46 PM | Last reply by KevinNicholas - Tuesday, February 28, 2017 5:40 PM -
0 Votes
SQL SERVER JOB AGENT
I would recommend using the Operating System (CmdExec) job step type to run DTEXEC: http://bi-polar23Answered | 1 Replies | 5734 Views | Created by Harish01 - Friday, May 1, 2009 2:57 PM | Last reply by MatthewRoche - Friday, May 1, 2009 4:21 PM -
0 Votes
sql server agent job
server agent Job using Tidal.could anybody provide batch file for this sqlserver agent ...Answered | 3 Replies | 1695 Views | Created by Vamsivaliveti - Thursday, October 8, 2015 6:31 PM | Last reply by Katherine Xiong - Friday, October 9, 2015 7:23 AM -
0 Votes
SQL JOB History & JOB Activity
thread towards the SQL Server Tools Forums where i have seen several threads related to SQL Agent and job history.I could do it but i prefer ...Answered | 2 Replies | 4370 Views | Created by Sudhir.Nune - Monday, June 25, 2012 1:04 PM | Last reply by Papy Normand - Friday, June 29, 2012 3:49 PM -
0 Votes
SQL Server Agent Job
I want to learn how to create a SQL Server Agent Job. After I googled it, I see that it can be found under ...Answered | 5 Replies | 1649 Views | Created by GTanna - Wednesday, March 25, 2015 2:47 PM | Last reply by ryguy72 - Friday, April 3, 2015 6:26 PM -
0 Votes
Sql Agent Job Error
Hello, I have a sql server agent job running a vbscript and the job fails with message "Executed as user: USER. ...Answered | 2 Replies | 1059 Views | Created by mkl69 - Thursday, May 28, 2015 8:19 PM | Last reply by AV111 - Friday, May 29, 2015 6:41 AM -
0 Votes
SQL Server Agent Job
2. How to create that SQL Server Agent Job & make it works ? Any help ...Answered | 1 Replies | 6408 Views | Created by Radha_Radha - Wednesday, October 15, 2008 5:43 AM | Last reply by Mangal Pardeshi - Wednesday, October 15, 2008 6:33 AM -
6 Votes
Cannot drop job under SQL Server Agent
wanted to delete it under SQL Server Agent, but it gave me error that delete statement conflicted with the reference constraint ...Answered | 9 Replies | 18937 Views | Created by JulieShop - Wednesday, July 25, 2007 12:56 AM | Last reply by mbeckwith - Wednesday, March 29, 2017 5:56 PM -
0 Votes
How to retrive error message for sql agent job failure
My sql server agent job failed and didn't store any error message in the job history. Is there any other table from ...Answered | 3 Replies | 2181 Views | Created by naveej - Tuesday, December 23, 2014 4:38 PM | Last reply by Visakh16 - Tuesday, December 23, 2014 6:06 PM -
0 Votes
SQL Server Agent Job
Hi, Assign SQL job owner to SA and execute SQL job. Also check SQL server agent "start up service ...Answered | 2 Replies | 6560 Views | Created by coloradoumpire - Friday, September 3, 2010 2:23 PM | Last reply by Ramesh S - Friday, September 3, 2010 5:31 PM -
0 Votes
Sql Server Agent Job Option grayed out
I deployed package to sql server and want to schedule a job. The option "Run as" is grayed out.Answered | 1 Replies | 3035 Views | Created by SharePointMadness - Tuesday, June 28, 2016 10:28 PM | Last reply by ArthurZ - Tuesday, June 28, 2016 10:33 PM -
1 Votes
sql server job history
Is there a way to configure the error log so that we can see SQL Server job history from there?Answered | 2 Replies | 1857 Views | Created by cuccisima - Monday, October 15, 2012 4:59 PM | Last reply by cuccisima - Monday, October 15, 2012 5:11 PM -
0 Votes
sql server agent job
Environment to use at execution time when running in this on-demand manner. Step 7: Create Agent Job to execute on an ongoing ...Answered | 2 Replies | 1903 Views | Created by coool_sweet - Wednesday, May 6, 2015 3:07 PM | Last reply by Katherine Xiong - Friday, May 8, 2015 7:41 AM -
0 Votes
SQL server agent job
Generally this error is thrown out by Integration services for many reasons. For finding out the exact cause - Check out the State and ...Answered | 5 Replies | 7291 Views | Created by Durai - Tuesday, July 11, 2006 6:16 PM | Last reply by Durai - Wednesday, July 12, 2006 4:31 PM -
0 Votes
Sql Server Agent Job Error
Save Copy of Packages as from BIDS tool. I have the proxy set up and i'm using that to run my package thru Sql Server Agent Job. I ...Answered | 2 Replies | 902 Views | Created by SharePointMadness - Wednesday, July 20, 2016 1:49 AM | Last reply by Kartar Rana - Wednesday, July 20, 2016 4:38 AM - Items 1 to 20 of 4102053 Next ›
No announcements
