sql-job Questions
5
Solved
In SQL Server Management Studio, when I "View History" for a SQL Job, I'm only shown the last 50 executions of the Job.
How can I view a full log of every execution of a SQL Job since it was creat...
Rattlepate asked 13/10, 2011 at 12:49
5
I defined parameters as shown below on my SSIS project
then I would like to change those optional over my sql agent- job, i defined as below.
even I tried to set a fix date value instead of g...
Dad asked 19/12, 2014 at 16:11
6
I have one SQL Agent maintenance job which checks the index fragmentation within a database and rebuilds indexes if required.
This is running well in my test server (Microsoft Sql Server 2012). But...
Thundershower asked 5/12, 2014 at 5:39
3
Solved
I'm getting the following error when trying to read a SQL Job.
The SELECT permission was denied on the object 'sysjobs', database 'msdb', schema 'dbo'
How can I fix this?
Weldon asked 16/6, 2011 at 11:14
6
Solved
I need to know how to make a SQL query run daily using a SQL Server Agent job, with minimum required configuration settings.
Tarboosh asked 29/3, 2011 at 10:28
3
I am trying to write a SQL query which tell me if a SQL job has run or not based on its schedule. For instance, if a job was planned to run at 12:00PM and we are 12:05PM and it still hasn't run, I ...
Callender asked 11/2, 2013 at 19:33
2
Solved
I need to create a SQL JOB.
Step1:
Insert a Row into TaskToProcess Table and return ProcessID(PK and Identity)
Step2:
Retrive the ProcessID which is generated in step1 and pass the value to SSIS...
Byer asked 21/5, 2011 at 8:31
2
Solved
I have been trying to get this issue resolved for a couple of days but none of the issues when searching on the web directly explains why I am getting this error as there is no cursor being execute...
Bali asked 11/11, 2016 at 9:1
5
Solved
In my application (ASP.NET, C#), i need to run a stored procedure in a set of pre defined time interval(s) everyday. So that i created a sql job and scheduled the same. But the problem is, there is...
Euphroe asked 15/4, 2016 at 4:33
3
Could anyone please explain to me how to create jobs in SQL Server Express edition?
Amphibian asked 26/8, 2011 at 6:54
1
Solved
I have the following in a CMDExec type SQL Job step (details changed):
D:\path\PSExec.exe \\servername -accepteula -u "domain\username" -p password D:\path\executable.exe
This works fine.
Howeve...
Malignity asked 19/11, 2012 at 13:2
4
Solved
This is the first time I am trying for the SQL Job Agent...I was trying to create the sample job and I got struck in between when it came to select the Category as highlighted in the below screen s...
Twerp asked 16/8, 2012 at 11:59
3
Solved
How can I drop sql server agent jobs, if (and only if) it exists?
This is a well functioning script for stored procedures. How can I do the same to sql server agent jobs?
if exists (select * from d...
Hardin asked 25/9, 2008 at 23:7
2
Solved
I've created a denormalized table that needs to be inserted/updated every hour. The process is rather involved from a data perspective, so i am looking for a recommend way to update the table witho...
Benitabenites asked 8/2, 2012 at 1:34
1
Solved
None of the SQL Jobs on my server are running. I've looked into this and got the message:
SQLServerAgent is not currently running so it cannot be notified of this action
How can I get SQL ...
Anhydride asked 14/7, 2011 at 9:33
2
Solved
When I try to create a Schedule the minimum amount of time I can choose from is 1 minute, is there a way to reduce this to seconds?
Artois asked 6/4, 2011 at 15:58
1
© 2022 - 2024 — McMap. All rights reserved.