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 |
|
JordyDB
Starting Member
8 Posts |
 Posted - 2012-07-04 : 04:53:13
|
| Hi all,I'm making a sql job that opens a bat-file.In this bat-file it opens a website.The job gives no errors, but also doesn't open a website.I'm executing with sql server agent, the job is done by sysadmin |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-07-04 : 05:02:20
|
What is the expected result?A job isn't a dialog and you can't see what the job is opening so that sounds like a bad idea...
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
JordyDB
Starting Member
8 Posts |
Posted - 2012-07-04 : 05:04:23
|
quote:
Originally posted by webfred
What is the expected result?A job isn't a dialog and you can't see what the job is opening so that sounds like a bad idea...
No, you're never too old to Yak'n'Roll if you're too young to die.
That it opens internet explorer with www.google.com as link. |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-07-04 : 05:17:28
|
It does but you can't see - it is senseless to do that.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-07-04 : 05:21:34
|
Have a look at the task manager and you will see the batch and the explorer are running as often as you have started the job...
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
JordyDB
Starting Member
8 Posts |
Posted - 2012-07-04 : 06:58:34
|
quote:
Originally posted by webfred
Have a look at the task manager and you will see the batch and the explorer are running as often as you have started the job...
No, you're never too old to Yak'n'Roll if you're too young to die.
I have a aspx page where I have written a searchscript on. So I want that the sql job visits the webpage so the pageload event fires and the search starts. Is the page open? Or is just IE proces running? |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-07-04 : 08:19:48
|
It is the same as if you have double clicked the bat-file. So I think the page is opened. BUT you have to kill the process because there is no one who is closing the page/the explorer.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
SQL Job