November 6, 2009 at 8:37 am
Hi,
I have a SSIS package that is located in the Stored Packages MSDB location.. I exported that package to a file system and then opened that package using BIDS...
In bids I couldnt see much as to what are the tables or stored procedures that it is using to excute this package...
But i found out that Source connection is ServerName-MAchineA.QM Database... and the destination connection'
is Servername-MachineB. ReportCubes...
So now if i have to look for a job in the sql agent should i be looking at Machine A or Machine B.. I do see sql job for this package but it has not been enabled...
Is there any other way to check if this job was last run and where can i find it..
Any help will be appreciated..
Thanks,
Karen
November 6, 2009 at 8:38 am
Right-click the job and select History.
That's your best bet.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 6, 2009 at 8:53 am
Should i look in Machine A or Machine B or you can call this job from a different server?
November 6, 2009 at 8:56 am
Whichever machine the job was scheduled on.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 6, 2009 at 8:59 am
You should be looking the history of the Job where it is scheduled.
Let me explain, the SSIS Package can be scheduled to run on MachineC which is neither Source nor the Destination.
Updated: Did not see the reply made by Gsquared.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
November 6, 2009 at 9:13 am
I see a job on Machine A but its not been enabled so i am guessing thats not the job they are using... but there is no where else i can see... cause I checked the other servers too and found no luck..
I also checked the schedules on the Machine A and B but found nothing related to this...
November 6, 2009 at 9:20 am
is there any chance they are running this job even though it is disabled? Maybe some other job calls this job, or some code somewhere calls and executes this job?
If the history for the job is empty then they are running the job on a different server for the package.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 6, 2009 at 9:24 am
Do you guys know anything about SSIS Package Release and what kinda information will be in there...
Cause when i logged into the integration services server and right clicked on the Instance name I found a log file viewer a which lists some the packages it ran and one of the entries said that "SSIS Package Release STarted" and after sometime i got a "SSIS Package Release Completed successfully"..
Date11/6/2009 2:00:12 AM
LogWindows NT (NT Events)
SourceSQLISPackage
Category(0)
Event1073819648
Userusername
Computercomputer
Message
Package "SSISPackage release" started.
Any help will be appreciated..
thanks,
Karen
November 6, 2009 at 9:30 am
CirquedeSQLeil (11/6/2009)
is there any chance they are running this job even though it is disabled? Maybe some other job calls this job, or some code somewhere calls and executes this job?If the history for the job is empty then they are running the job on a different server for the package.
The last run date on this job was 7/3/2009.. but if i see the last record in the most frequently used table i know the last record that move over was 11/05/2009 at 7:19 pm.. and in the source table i see records that have been created after 10:22pm last night.
So i am guessing this package runs around 10pm ish...
but i am not 100% sure to back it up...
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply