2
votes
1answer
180 views

MSSQL Server 2012 Scheduled PowerShell Job fails

I have a simple PowerShell script that runs fine from the console (PSVersion 2.0). $psftpPath = "C:\Program Files (x86)\PuTTY\psftp.exe" $sftpHost = "foo.baa.com" $userName = "myusername" ...
0
votes
1answer
192 views

MSsql 2008 sql agent task output to network drive

I'm trying to get the SQL agent job (task) to run my query then put the output file to network drive. When I select the output file the only drives listed are local. I'm new to jobs and MSSQL but have ...
1
vote
1answer
262 views

Suggestions for Scheduled Tasks to call OSQL without hard-coding cleartext password

Can anyone think of any techniques where i can have a Windows scheduled task run OSQL, but not have to pass the clear-text password with cleartext password being in the clear? E.g.: >osql -U iboyd ...
1
vote
1answer
242 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 ...
2
votes
4answers
1k views

SQL Server 2008 (SSMS) : Find next run date for a job

I would like to know if there is a way to get the next time a job is supposed to be running in SQL Server 2008, using a T-SQL query or even in SSMS if possible, without having to consult all the ...
0
votes
1answer
104 views

There are no email addresses or profiles when trying to configure a scheduled job to use email notification in SQL Server 2008?

I have configured and tested the database mail. That all works. I configured SQL Server agent to use the profile I created. I restarted SQL Server agent. When I configure the job and go to ...
6
votes
7answers
3k views

How do I automatically run nightly backups for Microsoft SQL Server 2005?

I don't see any built in mechanism for scheduling nightly backups in SQL Server 2005. What tools are available to perform this task and how reliable are they?