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 |
|
Fateme
Starting Member
13 Posts |
 Posted - 2010-07-22 : 19:44:08
|
| Hi everyone,I have a SSIS package and I've created a job to schedule this SSIS package everyday at 3.00 AM. this job runs everyday on time, but from yesterday this job can not be run and when I check the job history, there is not any log for that, it means this job does not run. I wouls like to know how can I trace that and find the reason. Any help would be appreciated.Many thanks,Fateme |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Fateme
Starting Member
13 Posts |
Posted - 2010-07-22 : 20:04:29
|
| Thanks Tara for your reply,I've checked that, it has "No end date", so means should be run for ever.Regards,Fateme |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Fateme
Starting Member
13 Posts |
Posted - 2010-07-22 : 20:33:53
|
| I've rescheduled that but it didn't start again. |
|
|
|
Fateme
Starting Member
13 Posts |
Posted - 2010-07-22 : 20:42:48
|
| Tara,I've tried to tun the job manually, and I got below error, It means the job is runnig but I can not see any log or history or any result."Start failed for Job 'Download_UKTitlesV16'. ADDITIONAL INFORMATION:An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)SQLServerAgent Error: Request to run job Download_UKTitlesV16 (from User AdminSA) refused because the job is already running from a request by Schedule 33 (Download_UKTitlesV16). (Microsoft SQL Server, Error: 22022)"Do you know what is the reason?Thanks,Fateme |
|
|
|
Fateme
Starting Member
13 Posts |
Posted - 2010-07-22 : 21:35:14
|
| The job's run successfully and created a log,it's so odd!!I am not sure, but I think it is a bug in SQL Server.Thanks again Tara for your hint.Regards,Fateme |
|
|
|
|
|
|
|
|
SSIS scheduled job can not be run.