Stack Overflow
Stack Overflow

Questions tagged [sql-server-agent]

SQL Server Agent is a Microsoft Windows service that executes scheduled administrative tasks, which are called jobs. SQL Server Agent uses SQL Server to store job information. Jobs contain one or more job steps. Each step contains its own task, for example, backing up a database. SQL Server Agent can run a job on a schedule, in response to a specific event, or on demand.

From Microsoft.com:

SQL Server Agent is a Microsoft Windows service that executes scheduled administrative tasks, which are called jobs. SQL Server Agent uses SQL Server to store job information. Jobs contain one or more job steps. Each step contains its own task, for example, backing up a database. SQL Server Agent can run a job on a schedule, in response to a specific event, or on demand.

483 questions
0
votes
0 answers

Error Msg: A new password should be set for this login without specifying the old password

Good day, I have a SQL Server job that keeps on failing. As per checking the error msg states that : A new password should be set for this login without specifying the old password. I did some research and all the resources I've found suggest…
Michelle Santos
  • 257
  • 4
  • 20
0
votes
1 answer

How do I troubleshoot a hanging SQL Server Agent Job

I have a SQL Server Agent Job with 4 steps. If I run it, it displays as "Executing" indefinitely. If I run the code in the four steps sequentially directly into SSMS, they take ~7 seconds to execute. No configuration information (owner, run as,…
Gawain Lavers
  • 11
  • 4
0
votes
1 answer

SQL Agent job to select a value from table and pass the values as input parameter to execute stored procedure

I have a stored procedure which expects integer as input parameter. i need this sp to run every 10 mins. for this im thinking to use sql server agent job. i want to select a set of values from table.column and pass this as an input parameter to the…
Sanjai Yadav
  • 15
  • 2
0
votes
2 answers

sysprocesses table inside or outside a sql server agent job is not the same

I try to write a simple sql server agent job to run daily. The sql statement is as follows: insert into testtable (nt_username, last_batch) select nt_username, last_batch from master.sys.sysprocesses where nt_username <> '' The same sql statement…
George Fang
  • 1
  • 2
0
votes
1 answer

Cannot find path Powershell script on SQL Server Agent

I've been searching all the internet and stackOF to and resolve this issue. I am trying to automate a db restore using SQL Server Agent. The sql server agent job comprises of four steps 3 of which are tsql and one which is a powershell script. I…
Huzaifa M Aamir
  • 383
  • 2
  • 4
  • 16
0
votes
1 answer

Bulk Insert fails in SQL Agent Job, FILE NOT FOUND

I've several entries for this kind of problem, and none of them seem to solve it for me. My SQL SERVER and SQL SERVER AGENT services are both set to the same user account. I have a stored procedure which does the following (error-checking cruft…
Marc L. Allen
  • 410
  • 2
  • 8
0
votes
0 answers

SQL Server Agent - String or binary data would truncated

I am working on SQL replication and facing some issues. I am now trying to enable output logging for replication by adding the following commands to the Merge agent under SQL Server Agent. -Output C:\ReplOutput.txt -OutputVerboseLevel 2 However,…
Bat_Programmer
  • 6,717
  • 10
  • 56
  • 67
0
votes
0 answers

Scheduled SQL Job Not Running

I created a SQL Job to re-organize all indexes at 2AM every day. When I check in the interface the job is due to run. However the job is not being run. I've tried checking the table msdb.dbo.sysjobschedules the job does not have a next_run_date or…
Nizac
  • 3
  • 5
0
votes
3 answers

SQL Server Agent: How to "sleep"?

In a scripting step in a scheduled task in SQL Server Agent 2005, I need to trigger a webscript that is running on a different server. I'm doing this: Dim ie Set ie = CreateObject( "InternetExplorer.Application" ) ie.navigate "...to my…
Thomas
0
votes
1 answer

Can packages in an SSIS project run on different job schedules?

I've got an SSIS project with three packages in it. I'd like to have each package run on a different schedule from our SQL Server Agent. When I try to set up three different jobs, the schedule of each job in the project changes to the last one I…
user2148983
  • 138
  • 2
  • 13
0
votes
2 answers

how to find out who modified SQL Server Agent job?

I need to verify who changed step in job 2 weeks ago, is this possible? I have tried this: use msdb go select j.name, j.date_modified, l.loginname from sysjobs j inner join sys.syslogins l on j.owner_sid = l.sid but is shows only owner of the job…
Zulu Z
  • 1,103
  • 5
  • 14
  • 27
0
votes
1 answer

SQL Server Agent job: Run T-SQL query and then send email?

We currently have a SQL Server Agent Job that has one step: to execute a stored procedure at 10AM daily that populates a SQL Server table. Using only SSMS, I want to modify that job to do the following: send an email where the email contents will be…
fdkgfosfskjdlsjdlkfsf
  • 3,165
  • 2
  • 43
  • 110
0
votes
0 answers

sql server agent job fails while execute

I'm trying to execute ssis package in sql server agent job . while start the job am facing the sql job fail. below i attached the screenshot of the error. NOTE : it is running fine , if i execute ssis package. Please find the below screenshot for…
SINDUJA
  • 63
  • 1
  • 6
0
votes
1 answer

Execute a SQL agent job based off a constraint

How do you execute a SQL server agent job in a schedule only if a certain criteria is met. My example is that I only want to run the job if a boolean value on a different server is set to true otherwise it must not run
Keag1
  • 141
  • 1
  • 11
0
votes
1 answer

Start failed for Job error in SQL Server Agent

I am trying to schedule a job which executes stored procedure but it is failing. If I try to run it manually, I am getting this error. At the moment I am trying to run EXECUTE storedproc but it takes long time to complete. Kindly let me know how to…
Aruna Raghunam
  • 903
  • 7
  • 22
  • 43
1 2 3
…
32 33