The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
16 views

Unable to view SQL Server Agent while logged in as user

I apologize for asking with insufficient information. I have granted SQLAgentUserRole permission to one of the user in SQL server on msdb database, but when user login in to SSMS using his ...
0
votes
0answers
17 views

SSA sending false job failure emails MSSQL(10.0)

We have a job runs every 3 minutes. We have set up email failure notifications as we are not located at the site. Every few days or so we will receive a number of job failure emails regarding the job ...
1
vote
0answers
74 views

SQL 2012 SQL server Agent Jobs

I am trying to figure out how to troubleshoot a situation with SQL Server Agent (2012). A job that has been running nightly (user SQL Server Agent as its scheduler) for over a year in 2 to 4 seconds ...
0
votes
0answers
443 views

SQL Server keep crashing, cannot connect with SSMS, Agent not starting

System Windows Server 2003 x64 SQL Server 2005 x64 Problems: 1) Cannot connect via SSMS - Tried both sa account and domain account (that is in sysadmin group) - If I supplied the wrong password, ...
0
votes
1answer
264 views

BizTalk Message Tracking not working

We have a new BizTalk instance set up, and have Message Tracking enabled on some events. The Tracked Message Events appear in the query, but trying to open the details results in this error message: ...
0
votes
1answer
114 views

Linked Servers in SQL Server

I have created a linked server and wish to execute a job that queries the linked server and writes the result in a local database.Ihave tested the connection to the linked server and it was fine. I ...
2
votes
2answers
2k views

How to detect robocopy's failure to delete from source?

On my SQL Server instance I use SQL Agent to run a daily backup job in two steps. One of the steps uses Robocopy to move local backup files to network storage. The command to move the files looks ...
0
votes
1answer
193 views

SQLServer Agent jobs and shutting down PC

Using SQLServer 2008. Just curious as to what happens when an administrator shuts down a server machine when an SQL Server Agent job happens to be running. In our case, the jobs could take several ...
1
vote
2answers
5k views

Add SSH host key to another user's PuTTY cache

I have written a PS1 script that 7-zips a file and uses PuTTY's SCP to store it at my back-up server. I have tested it and it works perfectly. Then I log into my SQL Server Agent and add an extra ...
0
votes
2answers
110 views

Determine when/by whom a Sql Server 2000 service account was changed?

I am looking into some backup issues on an old Sql 2000 server and I've narrowed it down to the fact that the Sql Agent account was changed. The big question that I have is whether or not I can tell ...
0
votes
1answer
560 views

Error SQL Server 2005 Using Proxy to run Agent Job ConnGetProxyPassword

I'm using a proxy to run several SQL Server agent jobs. Essentially the jobs copy data from Excel spreadsheets into a dbs via a network shared drive. The jobs have been failing for several weeks with ...
1
vote
2answers
86 views

Is there a performance hit when using an external URL rather than an internal IP to address a server in SSIS?

I'm running SQL Server Integration Services (SSIS) packages in SQL Server agent every day. I've been monitoring the performance of the packages and see a lot of network activity in Resource Monitor. ...
1
vote
2answers
3k views

Is it safe to restart Sql Server Agent?

I've found myself in the tenuous role of a developer tasked to manage a SQL server. I've set up some jobs to run on a schedule, but would like to receive email notification on completion. I've set ...
1
vote
1answer
216 views

Can you use a relatively expensive filter on transactional replication?

I'm trying to replicate (transactional, push) a relatively small table (50K rows), subject to several different filters, which are rather expensive (each taking at least an hour long to complete, ...
1
vote
1answer
270 views

MSSQL2008-R2 Scheduled Job Infinite Loop

I have two very similar jobs on a SQL2008r2 instance. Each one selects data from one of two structurally identical tables and exports it to one of two SQLAzure databases with the same schema every ...
0
votes
1answer
1k views

SQL Server Management Studio Agent Jobs List View

I've recently moved from using SQL 2000 Enterprise Manager to SQL 2008 R2 Management Studio. I am administering the SQL Agent Jobs of a remote SQL 2000 Server and need to find the Next Run details of ...
1
vote
2answers
209 views

SQL Server Agents jobs and turning off the server

I'm really new to SQL Agent jobs, but I am attempting to build up a maintainance regime for a server that will be turned off and on again at unknown intervals. It may run without being shutdown for a ...
0
votes
1answer
666 views

SQL Server: job with PowerShell step with robocopy doesn't end

I have a multiple steps SQL job set up in that basically generates transactions logs and then copies them using robocopy. Robocopy steps are of type “PowerShell” and look like following: ...
2
votes
2answers
3k views

SQL Server Agent refuses to start

I'm having a problem with SQL Server 2005 where the SQL Server Agent suddenly refuses to start. If I attempt to start it through Services, I get the error "SQL Server Agent (MSSQLSERVER) service on ...
0
votes
1answer
308 views

SQL Server Agent 2005 job runs but provides no output

Essentially I have a job which runs in BIDS and as as a stand lone package and while it runs under the SQL Server Agent it doesn't complete properly (no error messages though). The job steps are: 1) ...
0
votes
2answers
1k views

SQL Server 2005 Agent running SSIS job can't find file path

Basically I'm trying to run a functioning SSIS job (created in BIDS) under the SQL Server Agent - it reads a set of Excel spreadsheets and dumps the results into a table. The problem I'm having is ...
1
vote
3answers
1k views

How can I get the status of an sql agent job?

We use an sql agent job running on our SQL 2000 server to import data from our business system every ten minutes. The job runs a number of steps and usually takes about 5 to 6 minutes to run. This ...
1
vote
1answer
1k views

Sql Server 2008 Backups not quite running

I'm running a server with SQL 2008, and backing up the database with a "regular maintenance plan". (I'm not an expert by far in configuring SQL Server). The execution of this plan is automated by a ...
0
votes
3answers
453 views

Can I query a different server in a SQL Server Agent job?

When creating a T-SQL step in a SQL Server Agent job, is there a way to pull from a database on a different server? For example, I'd like to query different database job histories across all of the ...
3
votes
3answers
2k views

How to execute msdb.dbo.sp_start_job from a stored procedure in user database in sql server 2005

I am trying to execute a msdb.dbo.sp_start_Job from MyDB.dbo.MyStoredProc in order to execute MyJob 1) I Know that if i give the user a SqlAgentUser role he will be able to run the jobs that he owns ...
1
vote
1answer
173 views

SQL Server 2005 Alerts no Email Option

I've got Database Mail set up successfully, I can send test emails, however when I go to set up an alert to be sent by email to an operator I don't have a checkbox to check to say email should be ...
4
votes
6answers
12k views

Auto-start the SQL Server Agent after a computer restart

I am using the SQL Server Agent to run some jobs every day, but the problem is that whenever the server (the machine itself) is restarted, the SQL Server Agent doesn't automatically start when the ...
2
votes
3answers
4k views

Run a SQL Server 2005 Job as Administrator on Windows Server 2008

I have a job, C:\foo.bat. When I run the job from windows explorer it fails. When I right click on the file and click "Run as administrator..." the job passes. Now when I setup the job in SQL ...
1
vote
3answers
489 views

Verify jobs running on an SQL 2000 database

I have a stored procedure that is being executed by an unknown job. So I'm trying to figure out where the data is stored in SQL 2000 that shows which jobs belong to which database. The reason is that ...
0
votes
1answer
1k views

SSRS - SQL Agent Job Report Queuing

So we have a small number of SQL Server 2005 Servers running a lot of SSRS reports, which is running into issues where the servers cannot keep up with the total number of reports, that users are ...
1
vote
3answers
3k views

SQL agent job: Use mapped drive with different credentials

I'm running SQL Server 2008 and want to setup an agent job to backup all databases. The machine running SQL Server is part of a Windows domain. The destination for the backup files is on another ...
5
votes
5answers
13k views

Calling sp_start_job from a stored procedure

Our developers to be able to start a SQL Server Agent job from their .Net code. I know I can call *msdb..sp_start_job* to do just that, but I don't want to give general user accounts direct access to ...
1
vote
4answers
857 views

SQL Server 2005 error related to SQL Agent and Database Restores

I have been restoring sql 2005 databases from one server to another (similar spec, same version and service pack etc.) and have encountered the following. The problem starts with the restore of the ...
25
votes
5answers
52k views

Get a list of SQL Server Agent Jobs

I've got an extensive selection of these to add to a spreadsheet and don't want to go through by hand. What it the T-SQL command(s) to generate a list of SQL Server Agent Jobs?