The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
54 views

what happens to sql server if the active directory server goes down?

What happens to sql server if the active directory server goes down and the sql agent services is logged on as a windows user.
2
votes
1answer
224 views

Error on CMDEXEC job step even with proxy account defined

I’m not yet used to managing permissions on SQL Server 2008. I’m currently trying to create a SQL Server job directly from SQL with a user that isn’t sysadmin (but has the role SQLAgentUserRole). ...
1
vote
3answers
208 views

SQL Backup Is Taking All My Hard Drive Space

I have a job that I run every day to backup my SQL database. I just bought a band new server and was going to transfer the database backup over to the new serer and restore it. Our database isn't as ...
0
votes
2answers
250 views

SQL Agent started with local user account can't run job with domain user account

I have SQL Agent running under a local user account. Jobs runs well if I used Local account credentials for the cmdExec step. If I try to use a domain user account (created previously in proxies ...
5
votes
3answers
1k views

Scheduled Jobs during hours of autumn time change

I'm wondering how other people deal with this scenario. What if you have a job scheduled to run at 1:30 am. In the autumn, when time changes, the hour of 1:00:00 to 1:59:59 repeats itself and so ...
0
votes
2answers
2k views

SQL server agent job to execute SSIS package fails, package succeds if run manually

I've got a SSIS package installed on a SQL server (SQL Server 2012). It's fairly simple and just fetches data from a remote data source and adds it into a local table. The remote connection string is ...
0
votes
1answer
290 views

How to trigger a SQL Agent Job from a client PC

I have SQL Agent job that is automated that a non SQL Admin user may need to occasionaly run. I know I can trigger a SQL Agent Job via sp_execute_job. Can anyone tell me where to find what I need ...
1
vote
1answer
3k views

Configuring SQL Server Agent with domain account still fails to start Agent

I am trying to follow best practices for Sharepoint 2010 installation and SQL Server Agent will not start. My first reference is: Installing SharePoint 2010 using Least Privilege Service Accounts In ...
0
votes
1answer
57 views

SqlServer2005 Enterprise Fast Recovery, SqlAgent Availability, and Replication

I have a database under SqlServer2005 Enterprise 64bit sp3, that is in phase 3 of 3 of recovery after a reboot without normal shutdown. It looks like with fast Recovery, the database became available ...
2
votes
2answers
144 views

How do I configure the number of worker threads used by SqlServer 2005 Agent

How can I increase the limit of worker threads from the default 10 for SQL Server 2005 SqlAgent? I have 9 jobs that run almost continuously and that leaves only one available thread for the rest of ...
1
vote
1answer
562 views

How to schedule SQL-Agent to run a maintenance plan every x minutes?

My name is aSkywalker and I am an involuntary DBA. I have done some research, and would like to back up transaction logs every 10 minutes. I have written some powershell scripts to compress, encrypt ...
0
votes
1answer
1k views

Sql Agent Cannot Find the File Specified

I have a SQL 2008 Agent job with a single Operating system (CmdExec) step: C:\Scripts\Script.cmd Script.cmd runs a CS-Script. If I run C:\Scripts\Script.cmd, everything appears fine - I get my ...