Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rmg1
Constraint Violating Yak Guru
256 Posts |
 Posted - 2010-10-01 : 09:01:13
|
| Hi allThis is probably a daft question, but is it possible to run an SQL query via a Windows scheduled task.The IT bods here won't give us the necessary permissions to set up jobs.Anyone any ideas? |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-10-01 : 09:03:07
|
It is a very bad idea to do something like this without your IT.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-10-01 : 09:05:24
|
| Well you can create a Windows exe & embed the SQL query in it & then schedule it by Windows scheduled task.PBUH |
|
|
|
rmg1
Constraint Violating Yak Guru
256 Posts |
Posted - 2010-10-01 : 09:16:46
|
| Thanks guys. Looks like out IT dept has some work to do (either setting up and managing the jobs or giving us the permissions). |
|
|
|
Deepak1983
Starting Member
23 Posts |
Posted - 2010-10-01 : 09:54:50
|
| I don't know but somehow it relates to what u have asked.If you have permission to SSRS (SQL Reporting Service), you can create one report using that query and using subscription on Reporting Server you can schedule that report.Deepak Arora |
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2010-10-01 : 10:53:07
|
I think what you really want is to use SQL SERVER AGENT. It's a way to make jobs that are targeted at a database and have 'steps' which you can configure yourself. You then schedule the jobs to run as required (at a certain time each day for example or every x minutes / hours).Ask your DBA they should be fine with this. At the very least they should be OK with taking your sql, looking at it very carefully and scheduing a agent job themselves if they don't trust you (which they probably wont if they are doing their job properly  )good luck.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
|
|
|
Run SQL query via Scheduled task