June 21, 2013 at 8:38 am
I set a job to execute whenever the database engine is started but it has failed to connect whenever i try to connect it gives me an error, see attachment below.
June 21, 2013 at 9:49 am
Need more information regarding the job, the procedure being run, what database it is running in.
June 21, 2013 at 12:04 pm
It is running in the sql server 2008 R2...i was testing if i could schedule a job to run a querry when the engine is started.
June 21, 2013 at 12:50 pm
Again you have not provided enough information.
A startup job in sql agent would not prevent other clients from connecting to SQL because SQL Agent is just a client of SQL. You need to break down the information of what exactly you are trying to do with some code examples and a set of steps you are attempting. Without that we can't help you, as Lynn suggested.
CEWII
June 21, 2013 at 4:18 pm
Perhaps this may help:
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply